Release DbSchema 8.3.2

Improve connection dialog

Now can choose to build URL automatic or manual.

Connection Dialog

PDF Documentation

Generating PDF documentation can read the comments as mouse over tooltips. Now the tooltips are showing faster and stable.

PDF Comments

Integrate Azure Synapse

Azure Synapse is available as a distinct entry in the database list.

Integrate TimescaleDB

Table dialog has an option field where you can add the
statement for creating the hyper table.

Postgres Constraints DEFERRABLE

DbSchema does correctly reverse engineer ‘DEFERRABLE’ and ‘INITIALLY DEFERRED’ constraints specification.

PostgreSQL Deferrable Constraints

SQL Parser from SELECT

For example, in this image DbSchema can deduce the schema from the SELECT statement.
This feature is accessible in the Welcome pane by choosing ‘Open SQL file and deduce schema’ or
from the SQL editor like here.

Parse SQL Scripts

The automation scripts which were accessing the parser should be adapted to the new API.

Support for MongoDb Views

DbSchema does reverse engineer and can also create Views for MongoDB.

MongoDB Views

MongoDB Virtual Foreign Relations

They work now also for referring fields from sub-documents. The relational data editor can explore data from both collections.

Improve Dark Theme

Dark Theme

Sync Settings Dialog

With DDL pre/post scripts and sync filter. Pre and post scripts are migrated from local settings to the project.

Synchronization Settings

Code Samples Dialog

The dialog is accessible from the SQL Editor menu and Synchronization Settings Dialog.
It shows code samples which can be used for DbSchema automations, synchronization filter or forms and reports.

Code Samples

Improve Data Export Task

The Data Export Task was improved for better compatibility with all databases.

Bug Fixes

  • Save the model file in the same folder as the one where it has been open
  • Issue when generating PDF documentation
  • Postgres reverse engineer timestamp
  • Postgres reverse engineer identity columns

Share this blog post on Twitter, Facebook, and LinkedIn