Release notes not yet updated.$$$refer - https://dbschema.com/blog/release-notes/release-notes9/

DbSchema 9.7.3$$$Update JDBC Drivers Dialog$$$The JDBC Driver Upgrades dialog makes it easy to update DbSchema’s JDBC drivers directly from the dbschema.com repository.$$$You can also roll back to a previous driver version if needed.$$$The dialog opens automatically whenever new driver versions are released; and you can manually access it at any time via Connection > Manage JDBC Drivers > Check for Updates.$$$$$$DbSchema Toolbar$$$$$$Migrate from Java to Kotlin Part I$$$At DbSchema; we invest significant effort in keeping our codebase clean; modern; and aligned with the latest technologies.$$$Kotlin; one of the most powerful and expressive programming languages today; plays a key role in this process. Its safety; conciseness; and strong support for functional programming allow us to build a more reliable; maintainable; and future-ready application.$$$By continuously improving our foundation; we ensure that DbSchema remains fast; stable; and a pleasure to use — today and for the future.$$$$$$New Theme ‘Moonlight’$$$DbSchema Toolbar$$$$$$Feature: Postgres reverse engineer GENERATED ALWAYS columns$$$Bug: Various bug fixes

DbSchema 9.7.2$$$Upgrade OpenJDK and OpenJFK to version 21 and$$$$$$Start migrating from Java to Kotlin$$$$$$Bug: Installer problems with ARM processors$$$$$$Bug: SqlServer create computed columns.$$$$$$Bug: Fix performance bottleneck when opening or closing dialogs$$$$$$Bug: HTML5 export flags$$$$$$Bug: DDL reverse engineer ALTER TABLE … ADD COLUMN IF NOT EXISTS$$$$$$Bug: Registration using Floating License$$$$$$Feature: Code reorganization$$$$$$Feature: Use WebView in Error Dialog. Use more links when showing errors$$$$$$Feature: Indexes and Foreign Keys on virtual columns will be also virtual$$$$$$Feature: DDL parser skip comment blocks

Release notes not yet updated by vendor

DbSchema 9.7.0$$$New Welcome pane$$$DbSchema Welcome Screen$$$Add Virtual Flag for Table & Indexes$$$We use a new icon for virtual tables$$$$$$DbSchema Toolbar$$$Feature: Support for QuestDB$$$Feature: Support for Dataverse$$$Add settings for SSL Key Store to Model / Settings / Connectivity. Enable by default -Djavax.net.ssl.trustStoreType=Windows-ROOT$$$Sqlite read date and timestamp values from database as strings. This is fixing an error with date format.$$$SyncSettings skip formatting the PRE and POST scripts; in order to avoid errors with ${…} variables.$$$MongoDb: Improve menu with options for inserting document; create validator or design collection (virtual validator)$$$Access: add foreign key on delete/update actions$$$Exasol: reverse engineer distribution/partition keys$$$Improve Quick Tour$$$Databricks: add catalog to JDBC URL$$$Add search functionality in the layouts and comment tags$$$Bug: Table selection during reverse engineer$$$Bug: Edit cell in SQL Editor result pane$$$Bug: Snowflake NUMERIC(38;0) imported as INTEGER

DbSchema 9.6.1$$$Encrypt Connections File$$$For a higher security; we are encrypting the connections file$$$The connections are saved in the user home ~/.DbSchema/connections/ folder; together with the password file; which is already encrypted.

DbSchema 9.5.4$$$Upgrade to OpenJDK 17.0.11.$$$Fixes for Certificate TLS check.

DbSchema 9.5.3$$$JDBC driver for CSV Files$$$Data analysts are often working with CSV files; using Excel or text editors.$$$DbSchema can handle now CSV files in a relational way; so you can visualize and manage multiple CSV files similar with a relational database.$$$$$$To use CSV files; start a new model and using ‘CSV files’ as data source.$$$This will ask for the folder where the CSV files are saved; and load them in DbSchema as tables; with indexes and foreign keys.$$$Behind the scenes; the JDBC driver is loading the data to an H2 database.$$$$$$CSV JDBC Driver$$$$$$This allows to interact with the CSV files as they would be a relational database. You can explore data in a relational way; write SQL queries$$$and use the Visual Query Editor.$$$$$$CSV JDBC Driver$$$$$$To save back the data changes to CSV use the command ‘save csv to ‘.$$$$$$KeyStore tab to the Connection Dialog$$$In the connection dialog there is now a tab where you can load TLS keys into a keystore. There are two key stores: an authentication keystore and$$$a trust store. These are passed over to Java as system variables$$$$$$java.net.sql.keyStore=<pathToStoreFile>$$$java.net.sql.trustStore=<pathToStoreFile>$$$The keystore files are saved to the ‘.DbSchema/connection/‘ folder in the user home.$$$$$$DbSchema Keystore Tab$$$$$$Copy/Paste tables using SQL.$$$Move or clone tables between different design models using the option Edit / Copy as SQL and Paste as SQL.$$$$$$Copy/Paste tables as SQL$$$$$$Other Improvements$$$Feature: Export documentation always enable ‘Generate’ button. Until now was enabled only when a file was selected$$$Feature: Oracle add FIRST_ROWS hint for browsing large tables$$$Bug: Postgres sync issues for indexes with INCLUDE clause$$$Bug: Postgres reverse engineer columns using domains as data type$$$Bug: Postgres reverse engineer tables using inheritance$$$Bug: Postgres reverse engineer column comments as table comments.$$$Bug: Oracle reverse engineer procedures; triggers and functions body text$$$Bug: Postgres read-only connections do not import FKs$$$Bug: MonetDB wrong class name in the JDBC Driver$$$Bug: Multiple message on duplicate or invalid table or column names$$$Bug: Oracle issues with reverse engineer tables with comments in Chinese. Upgrade the JDBC Driver.$$$

DbSchema 9.5.1$$$Feature: Improve View reverse engineer using DDL if they have parameters or comments in the view body.$$$Feature: Add Help / Create Article on Blog dialogs$$$Feature: Improve the Report Designer$$$Feature: Improve Dark theme$$$Feature: Upgrade MAC OS certificate$$$Bug: Data Importer always skips first line$$$Bug: UserDataTypes; Functions and Procedures export didn’t work if they contains unescaped Java backslashes ‘$$$Bug: Export PDF documentation FK arrows$$$Bug: License activation$$$Bug: Postgres reverse engineer schema missing comments in some cases$$$Bug: Fix in Export-Schema-DDL.groovy script$$$Bug: Cassandra not listing keyspaces$$$Bug: Application designer open another page when no value was selected in combo box$$$Bug: Support for OpenSSH new keys. JGit brought a JSch artifact; conflicting with Mwide artifact.

DbSchema 9.5.0$$$Feature: Improve license management$$$Feature: First phase of supporting floating licenses$$$Feature: Support for DocumentDB$$$Feature: Improve support for Oracle computed and functional columns$$$Feature: Data conversion rules support for computed and functional columns$$$Feature: Add Automation Scrips to the Logical Design$$$Feature: Cassandra connectivity add entry for SSL$$$Feature: Support for GoogleCloudSpanner with Postgres Dialect. This is showing as a separate entry in the database list.$$$Feature: Configurable max query number of lines$$$Feature: Configurable data generator null percentage$$$Bug: Google Cloud Spanner reverse engineer indexes do not load managed indexes$$$Bug: Reverse engineer fails for schemes with hyphens in names (‘test-schema’)$$$Bug: Sync issue with Postgres Timestamp and Timestmaptz default precision 6$$$Bug: View definition validation when view name contains ${schemaName} or other tags$$$Bug: Boolean and Bit data types$$$Bug: Code review and improvement of handling Input/Output Streams

DbSchema 9.4.3$$$Feature: Store database connections in a separate file ‘ ~ /.DbSchema/connections/connections.xml’; configurable in Model / Settings. Passwords are stored encrypted in ‘ ~ /.DbSchema/connections/passwords.xml’.$$$Feature: New function evaluate(…) can be used in CREATE TABLE statement; to dynamically evaluate parameters. Sample CREATE TABLE ${table} ( ${body} ) ${createPartitionEnding} ${createClusterEnding} ${createSortEnding} ${createIndex1Ending} ${evaluete(options)} Where options can be someText${System.getProperty(“test”)}$$$Feature: Support for DuckDB$$$Feature: Export dialog add combo for the file selection$$$Feature: Add Model /Settings parameter to define a custom location to store the DbSchema settings. This allows to share the settings in a team via GIT.$$$Feature: Logical Design table and column options conversion to physical using regular expressions.$$$Feature: Upgrade SqlServer JDBC Driver$$$Feature: Faster Snowflake reverse engineer View columns$$$Feature: Allow executing SQL insert statements with more than 1000 rows.$$$Feature: Make the time limit to trigger auto-refresh after running ALTER TABLE statements configurable$$$Feature: Implement DbSchema Test in Tools / Automation Scripts.$$$Feature: Automation Scripts can be executed directly in the Tools / Automation Scripts dialog$$$Feature: Improve Data Explorer insert components$$$Bug: SqlServer issue in reverse engineer with Foreign keys using columns with spaces or dots.$$$Bug: Exception in Grid Editor$$$Bug: Issue in Logical Design Naming Conversion$$$Bug: Temporary issue with printing the data types$$$Bug: SQL Editor open multiple files from one editor menu is using the wrong files.$$$Bug: Default value conversion dialog not working.$$$Bug: SQL Editor auto-completion include SELECT; UPDATE statements.$$$Bug: Postgres reverse engineer User Defined Types created in another schema$$$Bug: SQL Editor caret move left-right go to the next line$$$Bug: Postgres reverse engineer varchar[] and timestamp(precision)$$$

DbSchema 9.4.1$$$Feature: Improve GIT dialog. Add commits tree representation. Fixes for pull; push and conflicts solving.$$$Feature: HBase new JDBC drivers$$$Feature: CSV Editor add ~ delimiter$$$Feature: Databricks add support for STRUCT; ARRAYS$$$Feature: Documentation dialog has an option to export layouts having a comment tag ‘documentation’$$$Feature: Databricks support for Unity Catalog$$$Feature: Rename DbShell into DbSchemaCLI (Command Line Interface)$$$Bug: MSAccess BOOLEAN as YESNO; comments are not supported.$$$Bug: Markdown SVG encoding issue$$$Bug: Sync issue with Foreign keys shown as missing$$$Bug: SqlServer correct reverse engineer unique constraints vs unique indexes$$$Bug: Table sort in HTML5 documentation$$$Bug: GIT improve authentication mechanism$$$Bug: Azure issues with USE command; when listing the schemes and catalogs$$$Bug: DDL Parser SqlServer references FKs.$$$Bug: Redshift fixes for distkey.$$$Bug: Databricks rename column; partition key$$$Bug: GIT Clone a fresh repository error$$$Bug: GIT use SSH private key file and paraphrase

DbSchema 9.4.0$$$$$$ Feature: PayProGlobal is our new Payment Processor. We introduced a monthly subscription license.$$$ Feature: SQL Editor fixed columns and rows$$$ Feature: Add clone unit to Schema menu; with shortcut: Ctrl+2. If the model has one schema; don’t ask about the target schema.$$$ Feature: HTML5 documentation can configure to hide the logo in Model / Settings; use move cursor; sticky layout title; lighter image border color.$$$ Feature: HTML5 documentation allow to open all open layouts. Use two combo boxes for selection.$$$ Feature: Grid editor include the schema for tables.$$$ Feature: Support Tarantool database$$$ Feature: In the schema dialog; add option to create databases$$$ Feature: Layout tooltips wraps text$$$ Feature: Creating new layout will add selected tables$$$ Feature: Add option under Table Menu / Group / Select Related Tables$$$ Feature: Logical design; moving entities between subject areas keep position and refresh layouts$$$ Feature: Add Groups Manager; available from Group / right-click /Manage.$$$ Feature: Relational Data Browse can edit enum data types as combo box$$$ Feature: Upgrade JSch libraries$$$ Bug: Easy Data Preview not showing correctly when opened from the right-click popup$$$ Bug: Import from XLSX when the column names are surrounded by spaces$$$ Bug: Foreign Key not drawn when generating documentation for layouts which are not open.$$$ Bug: Moving tables between schemes (in offline mode); is using the wrong name and loosing referencing foreign keys.$$$ Bug: Saving and closing SQL Editor to file would save an empty file.$$$ Bug: Schema/Table/Column/Foreign Key naming fixes for logical design (SubjectArea/Entity/Attribute/Relation).$$$ Bug: Virtual relations can show as many-to-many in diagram after reopening the model$$$ Bug: Errors in reopening models where the schema name contains dots.$$$ Bug: SQL Editor open new files in a separate tab$$$ Bug: Renaming an index and changing the index uniqueness generates error by rename$$$ Bug: SQL Editor not painted when shown in floating tab$$$ Bug: SqlServer reverse engineer filtered indexes (using WHERE clause)$$$ Bug: GIT dialog different fixes$$$ Bug: Logical design editing relation does not save the cardinality$$$

Change Payment Gateway$$$We move to a new payment gateway; PayProGlobal. We introduce a license as monthly subscription.$$$$$$Pay Pro Global$$$$$$Video Memory Usage$$$Improve video memory usage by removing hidden canvases from scene graph.$$$This allows to open multiple layouts on high resolution monitors without issues.$$$$$$Grid Editor$$$$$$Data Generator Improvements$$$Data Generator to File cache Foreign Key values. Booleans as 0 and 1 for SqlServer.$$$The data generator can produce output to SQL file.$$$$$$Data Generator$$$$$$New JDBC drivers for SqlServer; MySql; MariaDB; Postgres$$$Get the latest drivers by deleting the folder .DbSchema from the user home directory (C:\Users<YourUser>).$$$Restart DbSchema; and next time you will try to connect; the latest drivers will be downloaded.$$$$$$JDBC Drivers$$$$$$Connection Management and Online/Offline Improvements$$$Any operation requiring a database connection won’t change the project from offline to online.$$$We keep the offline status; unless is modified manually.$$$$$$Improve connection management. Add a connection status icon on the right of the toolbar.$$$$$$Online/Offline$$$$$$Schema Documentation Improvements$$$Documentation select multiple layouts using ComboBox. If multiple layouts are selected; generate table documentation only one time for all layouts.$$$$$$Schema Documentation$$$$$$GIT Dialog$$$The GIT dialog got different bug fixes and improvements.$$$$$$GIT Dialog$$$$$$Further Fixes$$$Bug: Correctly reverse MySql and MariaDb enum and set data types. Sample: type enum(‘TASK’;’CALENDAR’;’REPAIR’)$$$Bug: SqlServer reverse engineer table and column comments from extended properties$$$Bug: Copy SQL Editor result to clipboard$$$Bug: Closing DbSchema and save the latest changes.$$$Bug: Databricks JDBC driver issues

Other Features and Bug Fixes$$$Feature: Improve Data Loader$$$Feature: MongoDB support for SSL connections$$$Feature: CSV Editor memory optimizations$$$Feature: Triple-click in SQL Editor select line$$$Feature: Show triggers under the table structure$$$Feature: Increase text sharpness in diagram$$$Feature: Improve GUI font and contrast$$$Bug: Data Loader date format issue$$$Bug: SqlServer reverse engineer foreign keys between different schemes$$$$$$Refer the link for more details$$$https://dbschema.com/2023/01/24/releases/9.2.1/

Feature: Remove group gradients$$$Feature: HTML5 documentation - add tags to text comments$$$Feature: Improve HTML5 documentation look$$$Feature: Upgrade Google Cloud Spanner JDBC Driver$$$Feature: Configurable time for deducing view columns in Model / Settings / Reverse engineer.$$$Feature: PostgreSQL; Oracle load number of rows per table$$$Feature: Improve the Reports Designer$$$Feature: Improve Dark theme$$$Bug: Adding multiple tags to tables or columns$$$Bug: Snowflake does not reverse engineer view definition$$$Bug: HTML5 Documentation when the schema; table; or column name includes <; >$$$Bug: SqlServer computed columns skip the NULL keyword$$$Bug: Driver Management dialog not showing classes without URLs$$$$$$Refer the link for more details$$$https://dbschema.com/2022/12/12/releases/9.2.0/

Other Features and Bug Fixes$$$Feature: Thread improvements for diagram routing.$$$Feature: Upgrade SSH and internal libraries.$$$Feature: SQL Syntax fixes for GoogleCloudSpanner.$$$Feature: Edit / Show Schema name will show it also in the Foreign key tooltips and documentation.$$$Bug: Editing existing connection the URL is not loaded.$$$$$$Refer the link for more details$$$https://dbschema.com/2022/10/10/releases/9.1.0/

Further improvements$$$Feature: Improve Redis JDBC driver$$$Feature: Use LIMIT and OFFSET in Relational Data Explorer$$$Feature: Support for ClockHouse Database$$$Feature: Implement database version-specific settings. Like special settings for MySql 5.7; applied on top of version 8.0$$$Feature: Add setting for browse records per page; distinct from the SQL Editor$$$Feature: New drivers for AWS Azure PostgreSQL$$$Feature: Improve Report & Application designer$$$Feature: Improve settings dialog: use 3 tabs only; with search bar$$$Feature: Support for SqlServer external tables.$$$Feature: Improvements in SQL Editor result pane; with options to copy selection as CSV; JSON; MD.$$$Feature: Virtual Primary Key for Google Big Query$$$Bug: MongoDB errors with generate schema validation script$$$Bug: Postgres serial data type synchronization differences$$$Bug: Postgres include IN-OUT for function and procedure parameters in the DROP statement$$$Bug: Export large diagram to PNG; GIF or JPEG$$$Bug: Fix threading issue in Model loader from file task$$$Bug: Relational data editor - refresh not working in floating tabs$$$Bug: Reload connection in SQL editor by timeout$$$Bug: Reverse engineer foreign keys using tables from different schemes$$$Bug: Relational Data Browse and Data Generator query fetch size$$$Bug: Aurora MySql default current_timestamp not to use brackets$$$Bug: MySql reverse engineer using DDL when schema name uses dashes$$$Bug: Improve SqlServer reverse engineer using DDL$$$Code review: Rename package com.wisecoders.dbs.rdbms to com.wisecoders.dbs.dbms$$$Improvement: Merge classes RdbmsSettings; RdbmsSyntax and Rdbms into Dbms. Update the JavaDoc.$$$Improvement: Remove ${identifier} from SQL Syntax settings.$$$Improvement: Relational Data Browse threading$$$Improvement: MongoDB JDBC driver$$$Improvement: Cassandra JDBC driver support dataCenter (dc=)