Changelog

Changed

• Automatically generate entity relationship diagrams to visually map out your database structures. Simply right-click on the tables folder of a database and select the “Entity Relationship Diagram” option.

Fixed

• Light themes were not showing the correct database icons for MariaDB in the connection picker.

Fixed

• Tables now always open with the maximum row limit configured in settings (100,000). Right-clicking on a table provides an option to open it with a different limit.
• SQL Server connections failed unless the user account had the sysadmin role assigned.

Changed

• Data within a table can now be edited, added, or deleted, with changes saved directly back to the database.

Fixed

• Opening a table sometimes did not render the data.
• SQL Server displayed incorrect lengths for nvarchar and nchar datatype columns.

Changed

• Clicking on a table or view in the explorer now loads its data in a new tab.
• Added setting dbcode.maxRowsToFetch to control the maximum number of rows fetched when opening a table.

Changed

• Added SSH Tunnels. Tunnels are automatically detected from ssh.config and can also be manually created.
• Introduced a table icon to the results tab; clicking on this icon will pin the tab for easy access.

Fixed

• Postgres: Ensure columns in indexes are displayed in the correct order, even when they differ from the table order.

Changed

• MariaDB support added.

Fixed

• MySQL connections required SSL and would not work without SSL.

Changed

• MySQL support added.
• Timescale support added.
• Yugabute support added.
• Renamed Primary Keys to Primary Key in the explorer.
• Hovering over tables and views in the editor reveals column and table/view comments.

Fixed

• When running multiple statements simultaneously, column names were missing from all results except the first.
• Postgres failed to indicate when a primary column was utilized in a foreign key in the explorer.
• Confirmation dialogs previously didn’t respond properly to users not making a choice and exiting via escape.

Changed

• CockroachDB support added.

Changed

• Reduced memory usage and initial startup time.

Fixed

• Notebook incorrectly opening new editor tab when an SQL error occurred.