Release Notes and Other News

clean out docker setup

fix missing Docker host IP address forl local echo server

• Minor fix (content-type was not correctly detected)

• Add %Admin_secure resource setting for the web application.

Module version bump

A few demo calls IRIS from Python are introduced in /python/irisapp.py

Embedded python support is introduced

Embedded Python support is introduced: env variables and Callin Service on.

• fixed issue with pie chart and "children" in "tuples" response from mdx2json

• Fix a method generator issue with simple HTTP client.

• Add REST Api for Security package.

add jdbc driver postgresql-42.3.1.jar

Fixed image version
Thank you @Robert Cemper ;)

fixed quality code
upd readme

fixed GetListModules

fixed GetListModules

Republish for ZPM with Module Resource and source in UDL format

fixed jdbc module

added support jdbc gateway export/import module

New Features
Connection Setup -Support to share a SSH configuration for multiple database connections
Added support for Cassandra
Added support for Google BigQuery
Added support for Microsoft Access
Added support for SingleStore

Improvements
@import - Add the format="xxx" argument for @import

Connection Setup - Automatically reconnect when connection is lost

Connection Setup Security - SSH tunnels can now be used in DbVisualizer Free

DB Support: Azure SQL - Add support to view, create, drop, and change password for users

DB Support: Azure SQL - Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables

*DB Support: SQL Server *- Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables

DB Support: Greenplum - Add support for killing sessions

DB Support: PostgreSQL - Add support for killing sessions

*DB Support: Redshift *- Add support for killing sessions

DB Support: SQL Server - Add support for killing sessions

DB Support: Yellowbrick - Add support for killing sessions

DB Support: H2 - Add support for H2 version 2.x

DB Support: PostgreSQL - Support generating comment statements for triggers
Add support for generated columns in PostgreSQL Create/Alter

DB Support: SQL Server - Add support for create, modify, and drop of users and logins

Data tab - Having a where filter in the Data tab should show a different icon

Driver Manager - Used By column in the driver manager should when clicked show a list of database connections
Add "Reset Driver" command in driver manager

Export - Restrict formatting of numbers for SQL exports
Support exporting in TXT also for @export, Export Table and Export Schema

File Chooser - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions

OS Support: Windows - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions

Filtering/Filter Sets - Make it possible for table filters to be removed after a certain time

General - Make progress windows larger
Change icon for "duplicate" (yellow start) to the standard "copy" icon
Add icon to external web links to highlight that a browser will be opened

Grid Component - Add option to show images in binary type columns in grid
Add "Extract Filter & Sort as SELECT" action in Data tab. Used to copy the SELECT statement in Data tab including any grid column filters and sorting

*Import *- When Batch Import, commit at every executed batch
Make it easy setting data type for the multiple columns during import to new table
Make "Batch Import" default

Java 17 - Bundle Java 17 with installers
Support the ed25519 algorithm for SSH

OS Support: Windows - Remove support for Windows 32-bit

OS Support: macOS - The DbVisualizer window title bar background should follow General / Appearance setting in macOS System Preferences

SQL Commander - Add "@command ignore/resume" to ignore/resume executing any client-side commands
Add the "@stop now" client-side command used to stop the execution of the script

SQL History - Make "Search Full Script" default in SQL History

Full Embedded Python support!
call
USER>d ##class(eshvarov.sample.SeaBattle.GamePython).Run()

For Python

• fix serializer python $list

• fix source path for last version of zpm

• bypass version check

Fixed

• APPS-15075: Generating OpenAPI doc produces deterministic results
• APPS-13794: OpenAPI generated properly for query/path action parameters
• APPS-13849: OpenAPI doc includes query filter
• APPS-13664: %Dictionary.Classname is treated as string instead of object
• Unsupported actions are always omitted from OpenAPI generation

Fixed:

• Handle UTF-8 characters in git commit messages

• fixed issue with reset click filter button on charts

• prevent drilling on chart widgets if the widget has click filter

• fixed issue with multiple click filter

• Make utils abstract