Softpedia >Mac >Developer Tools >DbSchema >  Changelog

DbSchema Changelog

What's new in DbSchema 9.5.3

Apr 25, 2024
  • 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.
  • 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.
  • 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
  • The keystore files are saved to the ‘.DbSchema/connection/‘ folder in the user home.
  • Copy/Paste tables using SQL.:
  • Move or clone tables between different design models using the option Edit / Copy as SQL and Paste 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.

New in DbSchema 9.5.2 (Feb 25, 2024)

  • UI Internationalization:
  • DbSchema UI can show in english, spanish, german, italian, portugese, japanese, and chinese simplified.
  • We use Azure AI Translation.
  • This can be re-configured from Model / Settings Dialog
  • Floating License Server:
  • Floating licenses can be used by teams, when a license can be shared across multiple users.
  • This is more for the cases when DbSchema is used by multiple users in a team, for short intervals to time each.
  • The floating licenses requires installing the floating license server on a separate machine. The client computers will connect to the floating license server.
  • The floating license server can be started from DbSchemaCLI using the command ‘license server’.
  • Manually Start DbSchema PRO Evaluation:
  • In the earlier releases, DbSchema PRO trial was started automatically, after installation.
  • This has created confusion, as the design model was a feature the PRO edition, and as soon as the trial ended this feature couldn’t be used anymore.
  • Now, the PRO trial is started only at the user request, making users aware about this.
  • Improve Relational Data Explorer:
  • Exploring the data from one table will open the table in maximized view. The view can be restored using the maximize button in the upper right corner.
  • Cascading a further table will automatically minimize the table.
  • Editing table data will show the editor directly into the table. Double-click cells to start editing. Press ENTER with Control pressed to enter new lines of text.
  • Multiple table cells can be edited simultaneously.
  • Auto-completion for Java Groovy Scripts:
  • DbSchema can automate different tasks using Java Groovy automation scripts. Sample scripts are shown in the Tools menu / Automation Scripts.
  • Scripts can be added in the Automation Scripts dialog under User Defined.
  • You can also open the SQL editor, switch to Java Groovy and edit or execute scripts.
  • Now, pressing CTRL-Space a completion menu will show.
  • Placing the caret between the method brackets and pressing CTRL-P, the different parameter combination can be listed.
  • Other improvements:
  • Feature: Add method Schema.cloneTable()
  • Feature: Logical design specify column auto_increment
  • Feature: Upgrade Firebird JDBC drivers
  • Bug: Editing foreign key columns was not possible for Pk tables with more than 100 records
  • Bug: Editing column in table dialog, after sorting the columns, would break the sort
  • Bug: Data explorer insert UUID in PostgresSQL
  • Bug: Browse Filter pop-up not showing when the data view is scrolled to right
  • Bug: Different bugs in GIT dialog

New in DbSchema 9.5.1 (Jan 17, 2024)

  • 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.

New in DbSchema 9.5.0 (Dec 5, 2023)

  • 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

New in DbSchema 9.4.3 (Oct 24, 2023)

  • 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)

New in DbSchema 9.4.2 (Sep 18, 2023)

  • Feature: Data Governance Dialog
  • Feature: Oracle table option for partitioning
  • Feature: Option to export data including auto-increment columns
  • Feature: SQL Editor add area selection with Alt key
  • Feature: Upgrade MySql, MariaDb, H2 and PostgreSQL JDBC Drivers
  • Feature: PostgreSQL use DDL to reverse schema from the database. Use Model / Settings / Show Reverse Engineer DDL to see the statements in the Help / Output Logs.
  • Feature: GIT dialog, add fields for author name and email in the commit pane
  • Feature: Upgrade Snowflake JDBC Driver
  • Feature: Include Synchronization Pre an Post scripts in the Commit Dialog scripts
  • Feature: Support TimescaleDB
  • Bug: Links in markdown documentation
  • Bug: Create statement on foreign keys shows an empty script
  • Bug: GIT revision date is incorrect
  • Bug: Postgres reverse engineer unique indexes/constraints
  • Bug: Commit schema changes dialog, when pressing the ‘Skip’ button

New in DbSchema 9.4.1 (Aug 4, 2023)

  • 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

New in DbSchema 9.4.0 (May 25, 2023)

  • 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

New in DbSchema 9.3.0 (Apr 12, 2023)

  • Change Payment Gateway:
  • We move to a new payment gateway, PayProGlobal. We introduce a license as monthly subscription.
  • 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.
  • 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.
  • New JDBC drivers for SqlServer, MySql, MariaDB, Postgres:
  • Get the latest drivers by deleting the folder .DbSchema from the user home directory (C:Users).
  • Restart DbSchema, and next time you will try to connect, the latest drivers will be downloaded.
  • 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.
  • Schema Documentation Improvements:
  • Documentation select multiple layouts using ComboBox. If multiple layouts are selected, generate table documentation only one time for all layouts.
  • GIT Dialog:
  • The GIT dialog got different bug fixes and improvements.
  • 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

New in DbSchema 9.2.2 (Feb 27, 2023)

  • Grid Editor:
  • The Grid editor is a fast way of editing tables, columns, indexes and foreign keys. The editor is available in the table right-click pop-up.
  • Here you can faster create columns, set data type and comments.
  • Selecting multiple rows you can apply the editing to all rows simultaneously.
  • The Grid editor can show the items as tree or as table. From the header you can sort the items.
  • Tag Manager:
  • Beside comments, each table, column, index or foreign key can have tags as pairs of key/values.
  • Using the tag manager you can pre-define some tags, add a list of values for each tag, and define for which element can be used.
  • The tags are saved only in the design model and not in the database.
  • Logical Design conversion to Physical Design:
  • We have improved the naming and conversion dictionaries. We also added auto-suggestion on name fields in the table and column dialogs, based on the names
  • from the naming dictionaries.
  • The workflow is to generate from the logical design the physical design, which can be than synchronized with the database.
  • A direct synchronization between the logical design and the database is no longer possible.
  • Improve Options Pane and Field:
  • The option pane is a tab in the Table Dialog. Options fields are available in the Column Dialog.
  • The option pane is used to define a database-specific collation, storage option, partitioning, temporal tables, etc.
  • The possible options can be completely different from database to database.
  • In the option dialog you can select an option on the right, then add it to the exiting options on the left.
  • The possible values for the options are configurable in the Model / Settings / Database Specific / SQL Language / Table/Column/Index/Foreign Key options.
  • Other Features:
  • Improve data generator repository. The data generator has an option to generate data to SQL File.
  • Renaming a column in the offline mode and logical design will rename also the columns bind by foreign keys.
  • Sqlite improvements in creating foreign keys
  • MySql generated columns disable mandatory field
  • Bug Fixes:
  • Create or edit indexes exception
  • Editing tags activate the save button
  • MySql text default length 65535
  • Editing pattern in Data Generator
  • Data Explorer, hidden columns showing again on cascaded tables
  • SqlAnywhere and SAPHana fixes in reverse engineer

New in DbSchema 9.2.1 (Jan 24, 2023)

  • Improve Logical Design:
  • The relations can make use of different settings: Identifying / Mandatory and Cardinality.
  • Except the Many-to-Many relations, all other settings will be implemented in the logical design directly after closing the dialog.
  • Show Database Objects in the Project Structure:
  • DbSchema includes now code to explore other objects from the database, like collation, partitions, file groups, tablespaces, etc.
  • They are shown in the Project Structure, in a folder with a ‘magnifier’ icon.
  • They are not saved in the design model.
  • Improve HTML5 Documentation:
  • The documentation got a better look.
  • ‘SQL’ Button to Table Dialog:
  • This option can be used to view the CREATE TABLE statement.
  • The option is available also for columns, indexes, etc.
  • 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

New in DbSchema 9.2.0 (Dec 12, 2022)

  • SqlServer improve reverse engineer speed:
  • In the previous versions we used two procedures to reverse engineer the schema.
  • One of the procedures was called for each table.
  • Now we use a PSQL Block ( begin…end ) which can be called only one time per schema.
  • New Video Tutorials Dialog:
  • The video tutorials are explaining more in details the DbSchema features.
  • MongoDb Tree Arrangement & Virtual Setting:
  • We arrange collections in a tree manner.
  • Collections can be marked as ‘virtual’. Virtual collections won’t get any validation rule implemented in the database.
  • Improvements in the Table and Column Options Field:
  • The ‘options’ field can be used to select database-specific settings.
  • For GENERATED AS IDENTITY one of the BY DEFAULT or ALWAYS settings are selected by default.
  • Dark Theme:
  • Improve Dark theme.
  • Other Features and Bug Fixes:
  • 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

New in DbSchema 9.1.1 (Nov 9, 2022)

  • Result Pane:
  • Add icon in Result Pane cell to show large text cells in PopOver
  • MongoDB:
  • MongoDB collection flag for virtual (no validation rule) and also symbol in the diagram.
  • Setting it will skip implementing validation rules.
  • Import Model from External Formats:
  • Add Dialog to import model from CSV file. See Model / Load from External Format.
  • Dark Theme:
  • Improve Dark theme.
  • Other Features and Bug Fixes:
  • Feature: Project Structure expand by default only the first schema
  • Feature: Refactor SQL and JSON indentation (Ctrl-I in SQL Editor)
  • Feature: Add search field in Automation Scripts Dialog
  • Feature: Add data type auto-match patterns to the Model / Settings / Database Specific / Data Types. Used to match newly created column names and auto-select the data type.
  • Feature: Auto-disable diagram shadow when the rendering is slow.
  • Feature: Change tab traversal policy in the Column Dialog.
  • Bug: In MongoDB Query Builder

New in DbSchema 9.1.0 (Oct 11, 2022)

  • Welcome Screen and Quick Tour:
  • The welcome screen and the quick tour tips has changed.
  • Query Builder:
  • Thanks to JavaFX configurable CSS look, we were able to improve our look and feel.
  • Improvements for JSON documents. Query Builder use joined routing and show data type
  • Also improvements for MongoDB and better handling of large documents.
  • Diagram performance improvements:
  • Diagram routing and drawing works faster.
  • Logical and Physical Design:
  • We introduced the data type and naming dictionaries.
  • GIT Dialog:
  • The GIT dialog has improved. It has options to compare the model from two revisions, or generate the change audit log from multiple revisions.
  • 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

New in DbSchema 9.0.3 (Sep 5, 2022)

  • New Look and Feel:
  • Thanks to JavaFX configurable CSS look, we were able to improve our look and feel.
  • Improve Logical Design:
  • The logical design contains a number of improvements, including dictionaries for converting the data types and the entity and field names.
  • We continue to work on the logical design.
  • 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=…)

New in DbSchema 9.0.0 (Apr 12, 2022)

  • Logical Design:
  • DbSchema supports logical design. The logical design is database-independent, with entities and sub-entities.
  • Sub-entities can be created by adding a field of type sub-entity to a table.
  • There are also supported different relation types.
  • The logical model can be converted to a physical model and synchronized with the database.
  • We continue to improve the logical design also in the upcoming releases.
  • Reverse engineer using DDL:
  • In the previous versions, we reverse-engineer the schema by reading the metadata from system tables.
  • For most of the databases, we call methods from the JDBC driver, and only for a few of them did we execute direct queries on the system tables.
  • Now, we are using a DDL parser that can reverse engineer the schema from the CREATE TABLE DDL statement.
  • The DDL is generated using commands like ‘Show create table’, or using a dedicated procedure (SqlServer).
  • Comment Tags:
  • Besides text, the table, column, and foreign keys can use key/value comment tags.
  • The tags can be used in the automation scripts, and in the logical design for the entity or field’s physical name.
  • This allows us to reverse engineer all parameters, like collation, partition keys, etc., and more table-specific parameters - like temporal tables, etc.
  • This feature is available for all databases where we found a way to generate the table DDL.
  • Here are the current databases where this feature is implemented:
  • MySql, MariaDb, Oracle, SqlServer, AzureSQL, Snowflake, Redshift, Vertica, Sqlite, Exasol, SAPHana, GoogleBigQuery, Databricks, Cassandra
  • Improvements for MongoDB:
  • We do diagrams and schema validation rules for MongoDB. Whenever a validation rule is defined, we reverse engineer the collection structure using it.
  • If not, we deduce the collection structure by introspecting a few documents.
  • Whenever you design a collection, the collection validation rule gets updated.
  • In version 9 we added a text pane in the result pane.
  • We renamed the virtual relation to relationship, and we refactored the menu.
  • Automation Scripts for generating HTML or PDF Documentation:
  • We added more parameters for generating the HTML or PDF documentation.
  • Therefore we created a more flexible method in Java. Please have a look on the DbSchema API for details.
  • Further improvements:
  • Feature: Result Pane error message as dialog
  • Feature: InfluxDB integrations
  • Feature: PDF documentation, add parameter for skipping tooltip comments. Improve look.
  • Feature: Add more options to the documentation dialog
  • Feature: Exasol support hashtype data type
  • Feature: Color picker editable hex value
  • Bug: Fixes and improvements in the DDL Parser
  • Bug: MongoDB load statement using the driver class loader. This solves issues with ObjectId.

New in DbSchema 8.5.0 (Jan 10, 2022)

  • CSV Editor for Large Files:
  • DbSchema include now a CSV Editor for large files. The editor can open files up to 500 million of records, depending on the record size.
  • Analytic Applications:
  • The DbSchema Reports was renamed to Analytic Applications. The designer was improved.
  • Now it is more easy to create charts.
  • New Look:
  • We improved our default theme.
  • Other improvements:
  • Feature: Snowflake connection using private key
  • Feature: Implement functions, procedures and trigger comments into the database
  • Feature: Right-click copy to clipboard message dialogs
  • Feature: Oracle use GENERATED AS IDENTITY
  • Feature: Groovy scripts rename com.wisecoders.dbs.diagram.model.Location to com.wisecoders.dbs.diagram.model.Point
  • Bug: MongoDb rename collections and objects
  • Bug: MongoDb use ‘int’ instead of ‘integer’ data type
  • Bug: Query Builder exclude table won’t remove it from the generated SQL
  • Bug: HTML5 documentation fix special character
  • Bug: Fix unreadable red error message in result pane
  • Bug: Improve connectivity layer, for better code and correctly closing the SQL dead statements
  • Bug: Fixes in SQL Parser
  • Bug: Snowflake support varchar() without length
  • Bug: Vertica reverse engineer table and column comments

New in DbSchema 8.4.4 (Sep 6, 2021)

  • Feature: Improve connection dialog:
  • The database selection is done in a separate dialog
  • In the next dialog we also have a separate combobox for the JDBC Driver and the JDBC URL template.
  • From the JDBC template combo you can choose also to edit the JDBC URL.
  • In the next release we will continue to improve the connection dialog.
  • Feature: Support for Databricks:
  • Databricks is now officially supported in DbSchema.
  • Feature: Add setting ‘Commit after SELECT’ in Model / Settings / Transaction. Postgres uses AutoCommit off, and this enabled:
  • We do ‘SET AUTOCOMMIT OFF’ in DbSchema, in order to let users explicit commit the transactions.
  • If you do, for example, an update and the number of modified rows is higher than expected, you can rollback the transaction.
  • For Postgres and MySql this may create issues, as SELECT statements are also opening a transaction, which will lock the table.
  • Therefore, we introduced the ‘Commit after SELECT’ which automatically commits the transaction after an SELECT statement.
  • Feature: Execute Reports as stand-alone Webserver:
  • Database reports are saved as stand-alone running files .dbsr. They can be started using DbSchema -r
  • Feature: Improve HTML5 documentation look:
  • We also have upgraded the bootstrap libraries, used in the documentation and Reports
  • Further Improvements:
  • Feature: Renew the Windows Code Sign certificate. This caused a decrease of reputation in Windows Defender. Is a matter of time to get the reputation back.
  • Bug Fix: Refresh Schema from DB would reverse engineer all tables even if only few were selected
  • Bug Fix: Improve the database reports

New in DbSchema 8.4.3 (Sep 6, 2021)

  • Introduce Logical Design:
  • DbSchema can do logical design.
  • You can create entities with attributes and relations, which will map to tables, columns, and foreign keys in the physical model.
  • The relations can have a logical type.
  • Inside the layout, you can create different shapes and arrows.
  • From the menu, you can generate the physical model from the logical model.
  • Use different converters to map the data types from logical to physical names,
  • convert the table or column names and the column default values.
  • The logical design feature is released as a beta feature. We are happy to get feedback from you.
  • MySql Reverse Engineer the Schema Using SHOW CREATE TABLE:
  • This feature has to be enabled from the Model / Settings / Reverse Engineer dialog.
  • During reverse engineer, this will deduce the table structure by parsing the output of the SHOW CREATE TABLE command.
  • This feature is more precise and will load more table parameters compared to the traditional reverse engineer from the database metatables.
  • For now, this feature has to be enabled manually. Later we will make it the default setting.
  • Other Features:
  • Postgres comment on sequences
  • Improve SQL auto-completion
  • MongoDB reverse engineer relations using DBRef
  • Add prepend/append scripts to the schema
  • Improvements in data generator and groovy patterns
  • Bug Fixes:
  • Hive drop column issue
  • Include all tables by foreign key issue
  • Crash saving project file when closing DbSchema with ALT-F4
  • Improve Views and User Data Type support
  • Enable the save project on table color or options change
  • Snowflake autoincrement
  • Editor tabs cannot be closed or selected

New in DbSchema 8.4.2 (Jul 26, 2021)

  • New SQL Parser:
  • DbSchema can deduce the schema structure and diagrams by parsing SQL scripts from the file.
  • Then you can use DbSchema to document the model, edit it, create new layouts, or deploy it on different databases.
  • DbSchema 8.4.2 has a new SQL Parser, which is much more flexible. It can parse all database scripts, including Snowflake, SqlServer, Postgres, MySql, Oracle, with partition indexes, sorting, and clustering specifications.
  • Please write us if you find any statement which is not correctly parsed.
  • Markdown Database Documentation:
  • DbSchema can export now documentation in Markdown format.
  • Reports Designer:
  • We redesigned the reports designer.
  • You have to press the Design button to edit the report. Then you can click any cell to edit or create a component.
  • We got less feedback about the reports designer, please write us about your experience with it! Together we can make it a very powerful tool.
  • Other Features:
  • Feature: Prepare code for implementing Logical Design using DbSchema
  • Feature: Sqlite supports renaming columns
  • Feature: Hive - fix add & drop column, cluster, partition and skew keys
  • Bug: MySql & MariaDB datetime and timestamp precision
  • Bug: Reverse engineer Postgres functional columns.
  • Bug: Export data on large tables for more than 10k rows.
  • Bug: Postgres drop column cascade
  • Bug: Fix Elasticsearch JDBC URL

New in DbSchema 8.4.1 (Mar 18, 2021)

  • Add SqlServer Fulltext Index
  • Implement Mongodb Validation Rules:
  • Validation rules are used to ensure a collection has a given structure.
  • All inserts and updates into a collection should match the validation rule.
  • When creating a new collection or field, DbSchema will also implement the validation rule.
  • Reverse engineering the schema will deduce the schema from the validation rule, if a validation rule is available.
  • Include role in Snowflake connection:
  • Sometimes, connecting to Snowflake you will see no tables in DbSchema.
  • In this case you may need to set a role in the connection.
  • Other Features:
  • Feature: Use System Proxies by default
  • Feature: Include role in Snowflake connection
  • Feature: Improve dark theme
  • Bug: SqlServer comments in multiple databases
  • Bug: SqlServer identity synchronization issue

New in DbSchema 8.4.0 (Mar 18, 2021)

  • Feature: Support Google Cloud Spanner
  • Feature: Snowflake reverse engineer faster
  • Feature: Hive partitioning, clustering, sorting
  • Feature: Better look on large monitors
  • Feature: Auto-place only on a group
  • Feature: Improve diagram look
  • Feature :Rename Data Analyst to Reports
  • Bug: Improve SQL Result Pane and Data Explorer result column size
  • Bug: Issue when renaming SQL Editors
  • Bug: Zoom using mouse wheel issue on Linux
  • Bug: MongoDb insertMany() didn’t work fine. Fix require to drop the driver. Reconnecting will automatically download the latest driver.
  • Bug: Help dialog didn’t work properly
  • Bug: Result pane column width

New in DbSchema 8.3.4 (Dec 14, 2020)

  • Launch DbSchema Analyst BI:
  • Analyst BI is a tool for creating charts and database reports.
  • Improve SQL editor color scheme and rendering:
  • The color schemes has changed.
  • Support MonetDB:
  • DbSchema can connect, reverse engineer schema and manage MonetDB databases.
  • Bug in Relational Data Explorer:
  • Fix problem with resizing columns in Relational Data Explorer.
  • Improve space in the Synchronization dialog:
  • Improve space in the Synchronization dialog.

New in DbSchema 8.3.3 (Nov 5, 2020)

  • Launch DbSchema Free Version:
  • We created two DbSchema Editions: Free and Pro. There is a single download package, which will start the Free edition after download. From the menu you can choose to evaluate the Pro Edition.
  • Improve the Relational Data Explorer:
  • Better editing functionalities, improve menu, table header more compact.
  • Integrate ThoughtSpot Database:
  • This is a new database that we added to our list.
  • Trebuchet MS Diagram Font:
  • Now we use Trebuchet MS font for diagrams.
  • HTML5 Documentation:
  • Add option to generate documentation images in separate SVG files.
  • Upgrade OpenJDK and OpenJFX Libraries:
  • Upgrade to OpenJDK 15 and OpenJFX 15.0.1
  • Sqlite autoincrement:
  • Sqlite reverse engineer column autoincrement
  • Connection Properties. Support Oracle Kerberos Authentication:
  • We added a field to the Connection Dialog for setting connection properties. This is used for example by Oracle Kerberos Authentication.
  • Redesign Forms and Reports:
  • The Forms and Reports designer will work directly over the generated form or report. We are working to add charts to the designer. In the next versions we will create a powerful BI tools out of it.
  • Bug Fixes:
  • Generating PDF with TOC fix error
  • SSH Tunnel conflict with local running database.
  • Relational Data Explorer when foreign key is over multiple columns.
  • Data loader on large files may wrong evaluate the MANDATORY (not null) for new tables. Therefore we create all columns as nullable.
  • SQL Editor issues with Japanese text
  • Column dialog default value automatic add comma bug

New in DbSchema 8.3.2 (Sep 28, 2020)

  • Feature: Improve connection dialog. Now can choose to build URL automatic or manual.
  • Feature: PDF comments are easier to read
  • Feature: Integrate Azure Synapse
  • Feature: Integrate TimescaleDB
  • Feature: Support for MongoDb Views
  • Feature: SQL parser can deduce schema also from SQL Select statements. The Groovy scripts to start the parser has changed.
  • Feature: MongoDB virtual foreign keys work also from/to sub-documents.
  • Feature: Improve appearance
  • Feature: Support Postgres Constraints 'DEFERREABLE' and 'INITIALLY DEFERRED'
  • Feature: Migrate to latest SqlServer, PostgreSQL and MySql JDBC drivers
  • Feature: Add Schema / Sync Settings dialog, with DDL pre/post scripts and sync filter. Pre and post scripts are migrated from local settings to project.
  • Feature: Add Groovy Code Samples Dialog. Accessible from SQL Editor menu and Sync Settings Dialog.
  • Feature: Improve Data Export Task for better compatibility with all databases
  • Bug: Save the model file in the same folder as the one where it has been open
  • Bug: Issue when generating PDF documentation
  • Bug: Postgres reverse engineer timestamp
  • Bug: Postgres reverse engineer identity columns

New in DbSchema 8.3.1 (Sep 10, 2020)

  • Bug: Issues with Unique index and Unique Keys. Synchronization skips the differences between this two.
  • Bug: Issue with SqlServer reverse engineer Foreign Keys
  • Feature: Improve diagram font size. Make SQL text readable by increasing SQL Editor font size

New in DbSchema 8.3.0 (Aug 6, 2020)

  • Feature: Rename 'DbSchema Project' to DbSchema Model. Use this all over the menus and website.
  • Feature: Connection dialog, the JDBC URL is editable directly in the first tab.
  • Feature: HTML5 and PDF documentation omit description column if empty
  • Feature: Improve HTML5 documentation annotations and TOC.
  • Feature: Data Importer use serialization for XLSX files - avoid memory issues for large input files.
  • Feature: Use batches for Data Importer and Random Data Generator for faster data insert.
  • Feature: Improve Schema Synchronization dialog
  • Feature: Schema catalog is editable in the Schema dialog
  • Feature: In Index Dialog added checkbox to implement unique indexes via constraint (ALTER TABLE ADD CONSTRAINT) or index (CREATE UNIQUE INDEX). This should solve also some issues when dropping unique indexes.
  • Feature: MongoDB Random Data Generator and Data importer use batches. New MongoDb driver deployed.
  • Bug: Oracle correct reverse engineer VARCHAR2(length CHAR)
  • Bug: Postgres create view having 'with(exp)' failing
  • Bug: Synchronization dialog 'Generate Script Button' does not work by second click.
  • Bug: Open large project files with many browse and query editors is opening all of the editors.
  • Bug: Fix error dialog position. Sometimes they show on the very left side of the screen
  • Bug: Reverse engineer Postgres User Defined Type as enum. The values were not quoted.
  • Bug: Relational Data Browse edit enumeration columns.

New in DbSchema 8.2.12 (Jul 3, 2020)

  • Feature: Improve MongoDb support for ISODate()
  • Feature: Improve reverse engineer selection dialog
  • Feature: Improve virtual foreign keys dialog
  • Bug: Fix flickering tooltip on icons

New in DbSchema 8.2.11 (Jun 25, 2020)

  • Bug: Loose zoom when dragging new table in layout
  • Bug: Sqlite reverse engineer multiple foreign keys between two tables
  • Bug: Issue in schema selection dialog
  • Bug: Relational Data Browse edit date time bug fix
  • Feature: Project / Settings / Export Schema Script - add option for pre and post scripts to be attached to exported schema script
  • Feature: Support reading comments by reverse engineer from SQL files
  • Feature: Integrate NuoDb
  • Feature: SQL result pane status and error combo use Monospaced font
  • Feature: Option to compare two schemas
  • Feature: Improve dark theme
  • Feature: Redshift reverse engineer diststyle
  • Feature: Improve PDF documentation
  • Feature: Customizable UI Scaling added in Project / Appearance

New in DbSchema 8.2.10 (May 6, 2020)

  • Feature: Review Sqlite data types
  • Feature: Postgres support for types and enums
  • Feature: Postgres reverse engineer indexe WHERE clause
  • Feature: Improve Find Virtual Foreign Keys dialog to support multiple databasese
  • Feature: Vertica improvements
  • Feature: Improve MongoDb diagram auto-arrange
  • Feature: New Driver for MongoDb
  • Feature: Upgrade SqlServer driver to 8.2.2
  • Feature: Improve Pdf documentation look
  • Feature: Upgrade to OpenJdk 14 and OpenJFX 14
  • Feature: Move fast view table data ( CTLR-SHIFT-click table header ) to dialog
  • Bug: Sqlserver reverse engineer only column collations which are different from the database
  • Bug: Improve view reverse engineer
  • Bug: Improve column options dialog
  • Bug: Data Importer with Excel empty cells
  • Bug: Postgres drop unique index statement
  • Bug: Insert data in Relational Data Browse
  • Bug: Fix for ZoomIn shortcut on Mac
  • Bug: Fix PDF documenation with Cyrilic text
  • Bug: Fix show print page borders in combination with zoom

New in DbSchema 8.2.9 (Mar 29, 2020)

  • Feature: Intoroduce JDBC driver for CSV files. Now listed as 'CSVFiles' database - directly execute SQL over CSV files.
  • Feature: Support Firebird domains
  • Feature: Improve dark theme
  • Feature: Support for Postgres Arrays in Relational Data Browse
  • Feature: Snowflake fast list databases
  • Feature: Improve Report a Bug dialog
  • Bug: MonogoDb insert document
  • Bug: MySql reverse engineer procedures
  • Bug: Fix rendering issues in SQL Editor result pane

New in DbSchema 8.2.8 (Mar 3, 2020)

  • Feature: Include Apache Ignite Database
  • Feature: Sybase support multiple databases
  • Feature: Add description dialog for procedures and functions. Available in right-click pop-up.
  • Feature: Redesign Forms and Reports
  • Feature: Reverse engineer collation for PostgreSQL and SqlServer
  • Bug: Improve synchronization
  • Bug: Fix threading in schema reverse engineer
  • Bug: Fix $and statements in MongoDb driver
  • Bug: Rename index bug crashes script generation
  • Bug: PostgreSQL reverse engineer indexes with 'order asc'
  • Bug: postgreSQL 9.x and before reverse engineer identity columns to 'nextval'

New in DbSchema 8.2.7 (Jan 29, 2020)

  • Feature: Random data generator edit dialog cell notification to press ENTER
  • Feature: Improve error dialog
  • Feature: New logic for Views. We store the complete view definition, including CREATE VIEW..., with tags for view and schema name.
  • Feature: Improve Architect Look & Feel
  • Bug: SQL Editor / Run Script for SqlServer
  • Bug: Cassandra and MongoDb reverse engineer with latest JDBC drivers
  • Bug: SQL Editor error highlight for Redshift
  • Bug: Layout tooltip moved position after 1 sec
  • Bug: Copy/Paste in SQL Editor
  • Bug: Exasol drop functions

New in DbSchema 8.2.6 (Jan 13, 2020)

  • Bug: Fix SqlServer schema synchronization issues after adding support for multiple databases. See also the Connection Dialog/Others/Edit Schema Mapping
  • Bug: Fix export materialized views in Schema / Generate SQL Script
  • Bug: Fix Mongodb db.collection.count()
  • Bug: Fix bug in Data Importer for importing tab separated CSV files
  • Bug: Fix SqlServer add comments on columns
  • Feature: Improve Welcome screen
  • Feature: Improve Find Virtual Foreign Keys dialog
  • Feature: Add table create computed column to Table Dialog.

New in DbSchema 8.2.5 (Jan 13, 2020)

  • Feature: Add Apple Notarization required by Mac OS Catalina
  • Feature: Improvements in SQL Editor / Run Script
  • Feature: Compatibility improvements for Exasol
  • Bug: Issue in data type options and saving edited data types from Project / Settings
  • Bug(Minor): Copy /Paste in SQL Editor find/replace bar
  • Bug(Major): Closing Frame threading issue may lock the application lock

New in DbSchema 8.2.4 (Jan 13, 2020)

  • Feature: Snowflake clustering key
  • Feature: Exasol improvements
  • Feature: Improve virtual foreign key finder dialog
  • Feature: SqlServer show initially only 'dbo' catalogs
  • Bug: Fixes in MongoDb JDBC driver
  • Bug: Blocking window on Synchronization SQL dialog
  • Bug: Foreign keys not being saved correctly

New in DbSchema 8.2.3 (Nov 25, 2019)

  • Feature: Improve column, table and index options
  • Feature: Support SqlServer multi-database
  • Bug: Fix Exasol partition and distribution keys
  • Bug: Fix locking when 'show page borders' was enabled and computer had no configured printer
  • Bug: For SqlServer show correctly the schemes, triggers and procedures

New in DbSchema 8.2.0 (Nov 25, 2019)

  • Feature: Add Postgres options for table, column and indexes: collation, tablespaceName and other.
  • Feature: Update SqlServer and AzureSql driver to version 7.4.1
  • Feature: Improve Sqlite reverse engineer of foreign keys
  • Feature: Implement our own xBase and FoxPro DBF JDBC driver: https://github.com/dprutean/dbf-jdbc-driver.git
  • Feature: Update PostgreSQL driver to version 42.2.7
  • Feature: Oracle reverse engineer tables using query on system tables. This allow correct importing INTEGER data type
  • Feature/Bug: Fix Shortcuts interpreter to use the focused editor for the case a shortcut is used in multiple places ( Ctrl-Z in diagram and SQL Editor )
  • Feature: Make few settings like 'Records per page' configurable per database.
  • Bug: Fix Mac shortcuts for Zoom In / Zoom Out
  • Bug: Reverse engineer Vertica views
  • Bug: SqlServer create check constraints fix
  • Bug: Fix SSH password as password field

New in DbSchema 8.1.9 (Aug 29, 2019)

  • Feature: support functional indexes: create index idx on person(lower(lastname)). In index dialog there is an option for adding functional columns.
  • Feature: move pdf generation to openPdf and include unicode font for cyrillic and chinese text
  • Feature: configurable callout font in DbSchema/config/appearance/custom.css
  • Feature: improve Data Loader and upgrade to apache.commons.csv:1.7
  • Bug: Reverse engineer procedures in SqlServer
  • Bug: Create sequences in SqlServer
  • Bug: Installer view changelog prevents downloading correctly the new version

New in DbSchema 8.1.8 (Jul 22, 2019)

  • Feature: Improve SQL editor rendering speed. This makes the UI generally faster.
  • Feature: Foreign key dialog - add find table functionality
  • Feature: MongoDb to work with mongodb+srv: option
  • Feature: Update Cassandra JDBC driver to the latest native driver
  • Feature: Add HTML5 documentation dark theme
  • Feature: Improve dark theme
  • Bug: Fix Snowflake schema import
  • Bug: Closed Browse Tables are not removed from the project
  • Bug: Threading issue in Synchronization Task

New in DbSchema 8.1.7 (Jun 26, 2019)

  • Bug: fix 'null' in Export data from database dialog
  • Feature: Improve Schema Mapping Dialog
  • Feature: Improve table auto-arrange code
  • Feature: Add DbSchema/config/appearance/user.css where look and feel css properties can be edited
  • Feature: Migrate MongoDb JDBC driver to Gradle and mongo-java-driver:3.10
  • Feature: Merge Connection/Rdbms Settings Dialog in Project/Settings Dialog
  • Feature: Improve Foreign Key Dependency Dialog
  • Bug: Clone table clone also foreign keys
  • Bug: fix in Data Loader date format
  • Bug: JSqlParser correct handle quoted table and column names
  • Bug: Fixes for Random Data Generator - Fk Generator

New in DbSchema 8.1.6 (May 17, 2019)

  • Feature: Create Virtual Foreign Keys dialog. Virtual foreign keys can be deduced by parsing the cached SELECT statements from the database and looking for JOINS. A new dialog is now available under Layout/Manage Virtual Foreign Keys
  • Feature: Add navigation text field and history to Help Dialog
  • Feature: Add Virtual Data Type. This allows defining columns using a virtual type, and change real type for each database.
  • Feature: Improve in Look & Feel
  • Feature: Refactor code and obsolete more old Swing Classes. DbSchema Java API has changed.
  • Feature: Migrate DbSchema API JavaDoc to Gradle and generate new Documentation
  • Feature: Document view columns in HTML5 documentation
  • Feature: Improve validity checks for Foreign Keys and Constraints in UI
  • Feature: Support Primary key specification for one column PK among the column definition
  • Bug: Fix Postgres GENERATED ALWAYS AS IDENTITY statements

New in DbSchema 8.1.5 (Apr 19, 2019)

  • Feature: Release DbPrompt Version 1.0 Beta. Free-multi-database console featuring simultaneous query execution, Groovy scripts, cron jobs, error reporting and more. Details on https://www.dbschema.com
  • Feature: Advanced menu on clicking Fk icon near columns. Pressing the icon with CTRL pressed may jump to referring/referred table in other layouts
  • Feature: Add Unicode font to Pdf generator (support for Asian text)
  • Feature: Add Copy to clipboard for SQL result pane
  • Feature: Improve schema synchronization. New dialog for managing renamed tables, columns..., so we can better match them during synchronization.
  • Feature: Improve UDT support for Cassandra. Show User Defined Types with columns in diagrams.
  • Feature: Add icon for MongoDb and Cassandra map and array column lists.
  • Feature: Implement Undo/Redo in Diagram Pane
  • Feature: SQL editor / Groovy scripts can run in offline mode
  • Bug: fix database combo not listing databases
  • Bug: fix flickering tooltips on tip labels and checkboxes
  • Bug: thread issue in ResultPane causing cells to show as null
  • BUg: Redshift fix commit after select

New in DbSchema 8.1.4 (Apr 19, 2019)

  • Feature: Improve Random Data Generator interface and documentation
  • Feature: Improve Default Look and Feel
  • Feature: Improve PDF documentation
  • Feature: Add TOC (list of tables) option to the documentation
  • Feature: Add SqlServer encrypted connection URL
  • Feature: Improve Data Loader
  • Feature: Improve Quick Tour
  • Bug: Reduce PATH on DbSchema.exe. This was creating issues on computers where old Java versions were present in the PATH.
  • Bug: SQL code editor copy/paste remove non-printable charachters
  • Bug: Fix bug with ToDo Flags in Diagram
  • Bug: Fast preview popup not working on Windows

New in DbSchema 8.1.3 (Apr 19, 2019)

  • Feature: Look and Feel improvements, for Default and Dark theme
  • Feature: Do not list SqlServerDriver when DbSchema runs on Mac or Linux.
  • Feature: Cloning columns will create new column as nullable to avoid problems if the table contains data.
  • Feature: Clicking browse frame header will show the filter/sort popup.
  • Feature: Upgrade Derby JDBC driver
  • Feature: SQL result pane show tooltip on column headers
  • Feature: Implement 'Toggle Case' in SQL Editor
  • Feature: Sort data types in Column Dialog
  • Feature: Support derby data type 'varchar() for big data'
  • Bug: Fix SqlServer time precision to range 0-7.
  • Bug: Query Builder filter on booleans(bit data type) use 1 instead of true.
  • Bug: Connectivity port and driver fixes for Frontbase.
  • Bug: SQL Editor - display hidden characters (non-printable unicode characters).
  • Bug: Threading issue on rendering diagrams. This could have caused locking problems.
  • Bug: SQL result pane - fix threading issue
  • Bug: Fix directory chooser for Derby create new database
  • Bug: Fix view synchronization issue

New in DbSchema 8.1.2 (Jan 31, 2019)

  • Feature: Dynamic printing resolution, keeping track on available video memory
  • Feature: Navigation buttons in HTML and PDF documentation for multiple layouts documents
  • Feature: Update SqlServer and Azure JDBC drivers to 7.0.0. This may create issues, please write us on Technical page for support.
  • Bug: Pdf Documentation scan for bad encoding characters
  • Bug: Relational Data Browse - fix 'Edit Cell to NULL'
  • Bug: Work on stability of JavaFx threading. Bug affects the application stability
  • Bug: Fixed drag and drop of one or multiple columns over other column to create foreign key or over table header to clone columns
  • Bug: Database Driver Manager - save edited URL is fixed.

New in DbSchema 8.1.1 (Jan 10, 2019)

  • Generate interactive PDF documentation. Move the mouse over diagram table and columns to read schema comments.
  • Improve Printing : better quality, show print dialog, remember page settings
  • MAC CRASH BUG: There is a bug in Java, which leads to application crash with an 'NSInternalInconsistencyException'. We reported this to Java team, they will fix it mid January. There is no fix for this, eventually please downgrade to DbSchema 7 (see the archive link on download page).
  • Improve connection dialog
  • Bug fix in SQL Editor - running some SQLs would never finish
  • Disable aliases in Cassandra Query Builder
  • PLEASE REPORT BUGS AND FEATURE REQUESTS. We are focusing now to get a stable DbSchema 8.2 version, any feedback on [email protected] is appreciated.

New in DbSchema 8.1.0 (Dec 19, 2018)

  • Move project to Gradle
  • Support for Java 11
  • Dark look and feel improvements

New in DbSchema 8.0.9 (Oct 26, 2018)

  • Improve application alerts ( information, warning, error )
  • Fix bug on right-click table and 'Refresh from Database'
  • Improve Connection Dialog
  • Fixes for MongoDb
  • Improvements in Forms and Reports

New in DbSchema 8.0.8 (Oct 2, 2018)

  • Implement column aliases in Query Editor
  • Improve Forms and Reports
  • Show Quick Tour dialog as pane when the application is started for the first time
  • Update Font Awesome icons
  • Upgrade Groovy to version 3.0
  • Test and fix automation using DbSchema ( DbSchema -x script.groovy )
  • Improve connectivity tips in the Connection Dialog
  • Bug fix in SQL Editor text pane
  • Use gradient background for diagrams. Is better for large monitors. Also improve Welcome pane look.
  • Bug fix related to closing layout.
  • Bug fix with drag and drop large tables.
  • Bug fix in using Date filters in Query Builder.

New in DbSchema 8.0.7 (Sep 12, 2018)

  • Relational Data Browse, fix editing of Timestamps and Date
  • Improve Browse Arrow between tables
  • Connection dialog got a distinct tip label, on top of driver combo
  • SQL Editor - improve shortcuts: indent, un-indent, word selection
  • Improve connectivity tips and Help
  • Add Shortcut Manager dialog to main menu and each tool menu
  • Fix bug related to error highlighting in SQL Editor
  • Add find field to Import Schema Selection Dialog
  • Improve Azure schema reverse engineer
  • Query Editor : fix on editing filters
  • Forms and Reports : edit cell as a pane, no separate dialog
  • Tabs can be reordered by drag&drop : layouts, sql editors, browse, etc.
  • New JDBC driver for OrientDb

New in DbSchema 8.0.6 (Aug 6, 2018)

  • Embed Java 10.0.2 in Windows and Mac installer
  • Improve drag and drop to Relational Data Browse
  • Upgrade JDBC drivers: Access, Hive. We are happy for any feedback about issues with them.
  • Disable 'Generated as identity' setting in Edit /Rdbms Settings for Postgres 8 and 9
  • Improve driver combo title: the connection method is bold
  • Fix Help and Tips and Tricks dialogs to show in a Stage, preventing some display issues.
  • Main frame remember last open position and size
  • New Firebird and GoogleBigData drivers

New in DbSchema 8.0.5 (Jul 24, 2018)

  • Fix installer for correct requirements on Java 10 or 9
  • Various bug fixes
  • Improve Synchronization dialog
  • Fix horizontal scroll
  • Improve SVG documentation
  • Move DbSchema help to web. Refactor help dialog.

New in DbSchema 8.0.4 (Jul 17, 2018)

  • Complete remove Swing. All components are JavaFx.
  • Various bug fixes. Complete migration to JavaFx.

New in DbSchema 8.0.3 (Jun 18, 2018)

  • Paint layout speed improvements.
  • Bug fix in Forms and reports
  • Different fixes for create foreign keys
  • Increase graphic memory for high resolution monitors
  • Set default font Candara 12px

New in DbSchema 8.0.2 (Jun 18, 2018)

  • Bug fix related to SQL Editor paint text. We use our own text editor implementation, on some platforms we had issues.
  • Fix diagram background on MacOS
  • Issue with Foreign Key and Callout Editors
  • Bug fix in Schema Selection Dialog
  • SQL Editor right click menus didn't auto-hide
  • Fix some appearance colors
  • Switch computation of String width to JavaFx algorithms
  • Update Sqlite Jdbc driver
  • Update Access Jdbc driver
  • Sqlite fixes in generate schema script
  • Disable shadows if painting diagrams is slow
  • Fix diagram zoom using mouse
  • Change diagram rendering hints to LCD
  • Fix bug with left awt components in JavaFx dialogs

New in DbSchema 8.0.1 (May 29, 2018)

  • Complete migration to JavaFx. Advantages of JavaFx:
  • Latest technology standard
  • Better look, support for dark theme
  • Integrated WebBrowser

New in DbSchema 8.0.0 Beta (May 16, 2018)

  • This version is a migration to JavaFx: dark theme, latest technologies& better look.

New in DbSchema 7.6.6 (Mar 22, 2018)

  • THIS RELEASE IS FOCUSED ON JAVAFX, WHICH WILL BE EFFECTIVE IN THE NEXT RELEASE.THIS IS A TECHNOLOGICAL UPGRADE WITH ADVANTAGES FOR A BETTER USER INTERFACE, WITH SUPPORT FOR DARK APPEARANCETHIS WILL ENABLE US ALSO DEVELOPING POWERFUL TOOLS FOR DATA ANALYSIS AND BUSINESS INTELLIGENCE
  • Minor bug fix in Relational Data Browse
  • Add parameter LITERAL_PARAMS=true for Sybase JDBC url. This allows executing queries with 'value=?'.
  • Add message if JavaFx is missing
  • Add Rdbms CTreeAce

New in DbSchema 7.6.5 (Jan 16, 2018)

  • START MIGRATING CODE TO JAVAFX. We hope to have first the SqlEditor done, then develop a module for Data Analytics ( Business Intelligence ) under JavaFx.Further-on all modules will be migrated.The current version requires Oracle Java with JavaFx.
  • Forms Multirow Sheet from ControlsFx
  • Video Presentation: General, Relational Data Browse, Query Builder, MongoDb
  • Google Plus and Facebook
  • Exasol Graphs
  • Views sync ( no name )
  • Computed columns SqlServer
  • Bug fix in saving text configuration
  • SqlServer fix for reverse engineer sequences

New in DbSchema 7.6.4 (Jan 16, 2018)

  • SqlServer : add custom query to reverse engineer foreign keys much faster
  • SqlServer / Jtds driver / add Instance parameter to default URL
  • SqlServer: Bug fix related to clustered indexes
  • SqlServer: added support for computed columns
  • SqlServer: add instance to default connection string
  • Firebird: added Advice for fixing Wire Encryption in Jaybird 3
  • Cassandra: support for reverse engineer User Defined Types
  • Cassandra: bug fix for reverse engineer indexes
  • MongoDb: Error highlight in Query Editor
  • Layout: Auto-generate virtual foreign keys option under the Layout menu
  • Layout: Improve table auto-arranger
  • Random Data Generator: add seed setting for each columns. Two columns can be then set to use the same values.
  • Reverse Engineer: Bug fix related to index reverse engineer
  • Forms and Reports: Fix bug related to generated WAR
  • Synchronization: Fix bug with comments on Foreign keys
  • Diagram: improve foreign key line routing - less line intersections
  • JDBC Drivers: download drivers from repository fix for accepting certificates
  • Forms and Reports: fix bug for master-detail reports

New in DbSchema 7.6.3 (Oct 30, 2017)

  • Add instance to SqlServer default connection string
  • Fixes for SqlServer / import procedure and functions
  • Fix bug for SQL Editor execute query with Ctrl-Enter
  • Add SapAdvantage to the list of supported databases
  • Improve callout rendering in HTML5 documentation
  • Fixes for Foxpro, SapAdvantage
  • Move website and logic to https: instead of http:
  • Better table arrangement in diagrams
  • Ingres reverse engineer table and column comments

New in DbSchema 7.6.2 (Oct 30, 2017)

  • Support Sqlite adding foreign keys on existing tables and dropping columns
  • Improve auto-generating diagrams for schemes with more than 3000+ tables
  • Mongodb relational data browse filters on ObjectId's
  • MongoDb delete record when database name include special charachters
  • Diagram font size was not persisted correctly
  • Bug fixes for Cassandra, Teradata and MongoDb
  • Animation in HTML5 documentation - set using checkbox in Documentation Dialog.
  • Create only two layouts after project reverse engineering, one with Query Builder, SQL editor and Relational Data Browse
  • Improve table auto-arrangement in diagram.

New in DbSchema 7.6.1 (Oct 30, 2017)

  • New driver and fixes for Salesforce
  • Added distribution keys and sort keys ( clustering keys ) support for Amazon Redshift, Cassandra, Exasol
  • Fixed bug related to custom connection URL
  • Improve look of HTML5 table documentation
  • Improvements in Forms designer

New in DbSchema 7.6.0 (Jul 27, 2017)

  • Improved SQL script execution. Now aware on Mysql 'delimiter $$', Postgres 'do $$', Oracle 'declare .... /'
  • Changed SQL Editor shortcuts. Run Query : Ctrl-Enter, Run Script: Ctrl-Shift-Enter
  • Fix reverse engineer of Postgres smallint and functions. Functions are now shown under 'Procedures' as driver works like this.
  • Add repeatable 'Print Stack Trace' in Help / Output logs
  • Improvements for HTML5 documentation: better Fk higlight for IE, improve table comments
  • Update Cassandra JDBC driver to native driver 3.3.0

New in DbSchema 7.5.2 (Jun 29, 2017)

  • Reverese engineer Functions and procedures parameters.Now dropping functions will work correctly for Postgres.Also multiple functions with same name but different parameters are handled correctly.
  • Improve edit mode in Relational Data Browse
  • Show executed SQL in SQL Result pane combo
  • Improve look of Forms Designer and foreign key names in diagram
  • SqlServer connectivity: added more connection strings for the native driver and sqljdbc_auth.dll is automatically installed.
  • Higer JSqlParser library version will improve parsing of SQL scripts* Bugs
  • Fixes for SQL autocomplete
  • Pre-select default printer in print preview dialog
  • Capture from UI Structure Tree exceptions
  • Fix AmazonRedshift data types

New in DbSchema 7.5.1 (May 30, 2017)

  • New driver for Access ( 4.0.2 )
  • HTML5 documentation: clicking table name in text documentation will jump to SVG image
  • Access: add statements for creating foreign keys, ignore index and fk renaming
  • Interbase integration: connectivity, data types, SQL statements
  • Improve forms designer menu
  • Upgrade embedded Java to 1.8.131* Bugs
  • Relational Data Browse issue when editing Timestamps
  • Cassandra bug on relational data browse

New in DbSchema 7.5.0 (May 8, 2017)

  • Implement Database Manager Launcher ( see Forms / Database Manager, now for Postgres and MySql )
  • Improvements in SQL autocomplete
  • SqlServer bug in storing comments larger then 30 chars
  • Switch MongoDb default diagram notation to Barker
  • Fix bug regarding save of MongoDb groups
  • Add percent_true parameter to boolean random data generator.
  • Improve MongoDb Random Data Generator
  • Configurable colors for production, development and test connections

New in DbSchema 7.4.14 (Apr 4, 2017)

  • Ensure only one Sync task can run. Avoid this way duplicate synchronization.

New in DbSchema 7.4.13 (Mar 6, 2017)

  • Space Manager for MySql ( Apps / Space Manager )
  • Improvements for MongoDb. First time reverse engineer will show an Query Editor.
  • Bug fix in Synchronization pane
  • Fixes in Cassandra JDBC driver for getTime(), getTimestamp(), getDate()
  • Add random data generator pattern for UUID
  • Bug fix in saving CSV sheets headers
  • Integrate HBase into DbSchema
  • New drivers for Informix

New in DbSchema 7.4.12 (Feb 7, 2017)

  • Postgres Space, Permission and Activity Manager Applications ( under App menu )
  • Forms final migration from Swing to JavaFx
  • Include OrientDb
  • New Oracle drivers
  • Fix bug: refresh view columns when view changed
  • Add support for SqlServer clustered indexes
  • Add history button in connection dialog
  • Bug fix regarding loaded projects after dropping a schema

New in DbSchema 7.4.10 (Dec 12, 2016)

  • New forms sample application in App / Sample
  • Improvements in Forms and Reports
  • Added Netezza to known databases list
  • Improved look and feel for Mac OS
  • Bug fix in HTML documentation

New in DbSchema 7.4.9 (Nov 24, 2016)

  • Improvements in HTML5 documentation
  • Random Data Generator use Hierarchical tree plus bug fixes for MongoDb
  • New option in Browse edit menu to disable confirming updates
  • Drivers will be ordered by version in Connection dialog driver combo
  • In connection editor can choose previous edited connections from the alias combo field.
  • Redesigned forms menu
  • Connections can be highlighted as : Production, Development, Test. See advanced tab in connector editor.
  • SQL editor remember the column width after reload
  • Search box on top of the layout will resize if the table names are long
  • Improved diagram look 'Architect' ( see Help / Appearance )
  • Added extended tip on Data Browse frame. Large table rows can be easy read on mouse-over. See Browse editor Edit menu for options.
  • Bug fix in Relational Data Browse edit cell

New in DbSchema 7.4.8 (Oct 31, 2016)

  • font and look and feel improvement for Mac OS
  • added Sybase jconn4.jar Jdbc driver
  • bug fix in forms and reports encoding
  • workaround for MongoDb columns and embedded documents

New in DbSchema 7.4.7 (Oct 7, 2016)

  • Updates many JDBC drivers to recent versions
  • New option in Edit / Configuration for disabling number grouping ( dots used at thousands, etc. ).
  • Added Schema / Synchronization Filters. Use custom Java code to reject certain Sync differences. For example always reject diffs based on table or column name.
  • HTML5 mouse over effect changed to text-shadow
  • Bug related to display of Lists fields in MongoDb
  • Support for SnappyData analytics db
  • FoxPro, Db2 bug fixes

New in DbSchema 7.4.6 (Sep 13, 2016)

  • Fix issues with schema compare and synchronization

New in DbSchema 7.4.5 (Sep 2, 2016)

  • Added Hive to supported databases ( Hadoop )

New in DbSchema 7.4.4 (Aug 10, 2016)

  • Cassandra:
  • Added support for partition key, clustering keys, ordering in clustering keys. This can be set when the table is created.

New in DbSchema 6.4.0 Build 3867 (Aug 1, 2013)

  • Bug fix in saving database settings.
  • Improvements for Groovy support.

New in DbSchema 6.4.0 Build 3865 (Aug 1, 2013)

  • Informix won't setAutoCommit(false). Added setting configuration for this.

New in DbSchema 6.4.0 Build 3849 (Aug 1, 2013)

  • Fix fk routing bug.

New in DbSchema 6.4.0 Build 3831 (Jul 26, 2013)

  • Upgrade Nsis installer software.
  • Improve draw foreign key lines, threading on routing the lines.
  • Bug fixes.

New in DbSchema 6.1 (Sep 14, 2012)

  • Produced Build 3653
  • Fixes on create new layout. Problems were related to frame docking.
  • SqlServer fix for correctly importing varchar(max)
  • Added option to extend trial period with further 15 days. Option is available on the www.dbschema.com/editions.html.

New in DbSchema 6.0 (Oct 21, 2011)

  • Synchronization dialog shows the table SQL differences
  • improved search in Relational Data Browse
  • compatibility with Java 1.7
  • Ingres, MySql, PostgreSQL fixes

New in DbSchema 5.7 (Apr 22, 2011)

  • Code refactoring
  • Improved data browse
  • Graphical explain plan for Oracle, PostgreSql and few more
  • Various bug fixes
  • First steps for multilingual support
  • Synchronization improvements