The most visible improvement of this version is new look of DbGate window. Especially in dark mode on Windows now it looks much better. There is also posibility to use classic native menu, this option is available in settings dialog.
Also the main toolbar was removed, as it included commands, which are used quite rarely. These commands (ge. SQL generator, schema compare) are available from menu tools. There is new contextual toolbar on the bottom of current tab, with commands related to selected tab.
This version brings lot of important changes.
Virtual foreign keys, applications
DbGate has lot of features (master/detail views, lookups), which are dependend on correcly defined foreign keys in database. Unfortunately, lot of databases lacks forcing reference integrity, so DbGate doesn’t know relations between tables.
This is time for virtual reference - you define foreign keys only in DbGate. This foreign key is stored in somewhat, which is called in DbGate “application”. You can than assign the same application to more databases, so it isn’t necessary to define virtual foreign keys again for each database.
I am proud to announce, DbGate now supports creating ER diagrams.
Create from table or database
You can create ER diagram in database context menu (than all tables will be in diagram) or in table context menu (that tables related with selected table will be on diagram).
Super fast and easy to use
Diagram feature in DbGate is designed to be fast and easy to use. You can only display diagrams of existing databases, designing new database in diagram is not supported. You have access to full table context menu from diagram.
The main highlight of this release is under the hood of electron app. But there are also significant UX improvements.
“Natural” tab order
Tabs in DbGate are ordered by database, to which the tab belongs. In new version, this paradigma is preserved, but user could reorder tabs with drag & drop. Tabs in database are ordered by opening time instead of alphabetical order. Also it is possible to drag all tabs belonging to one database.
This release brings schema editor. You can edit table schema, define primary keys, foreign keys, indexes and unique constraints.
When alter operation is not directly supported by SQL engine (eg. drop constraint on SQLite), DbGate generates table recreate script.
Table modifications with recreates are not recomended to run od production databases.
Changelog after 4.2.4 version
4.3.0
- ADDED: Table structure editor
- ADDED: Index support
- ADDED: Unique constraint support
- ADDED: Context menu for drop/rename table/columns and for drop view/procedure/function
- ADDED: Added support for Windows arm64 platform
- FIXED: Search by _id in MongoDB
4.2.6
- FIXED: Fixed MongoDB import
- ADDED: Configurable thousands separator #136
- ADDED: Using case insensitive text search in postgres
4.2.5
- FIXED: Fixed crash when using large model on some installations
- FIXED: Postgre SQL CREATE function
- FIXED: Analysing of MySQL when modifyDate is not known