Release DbSchema 8.3.2
Improve connection dialog
Now can choose to build URL automatic or manual.
PDF Documentation
Generating PDF documentation can read the comments as mouse over tooltips. Now the tooltips are showing faster and stable.
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.
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.
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 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
Sync Settings Dialog
With DDL pre/post scripts and sync filter. Pre and post scripts are migrated from local settings to the project.
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.
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