Free universal database tool and SQL client
Changes since 23.2.5:
- Security: database drivers were updated due to security reasons: DB2, Google BigQuery, Athena, and YugabyteDB
- SQL Editor:
- Autocompletion of column names with special characters was fixed
- Output panel display in the statistics tab was fixed
- Selected query execution was fixed
- Queries with CTE execution was fixed
- Data Editor:
- Filter value search was fixed
- Advanced Copy as HTML with spaces in the column names was fixed
- Numeric value "infinity" representation was fixed
- ER Diagrams:
- Diagram update on metadata changes was fixed
- Automatic re-layout on notation or routing change was fixed
- General:
- Tips of the day were updated
- Constraints rename was fixed
- Idle transaction rollback notification was fixed
- Data Transfer:
- "Native clients" were renamed into "Local clients"
- Update on conflict behavior was improved (now it respects indexes too)
- Database restore was fixed
- List of supported variables was updated
- Database tasks: missing line break was added to the task log file
- Connections:
- Driver download error handle was fixed was fixed
- ‘Check for new driver version’ setting save was fixed
- Databases:
- Firebird: default values for procedure parameters are now displayed
- PostgreSQL/Greenplum: foreign key creation was fixed
- MySQL5 driver is available again
- Oracle: comments were added to the newly created columns
- A number of minor UI bugs were fixed
- SQL editor:
- Syntax coloring and code completion: smart columns abd aliases recognition was added (experimental)
- Numerous improvements in single-tab results visualization
- Quoting of identifiers with special characters was fixed
- Issue with read-only column in queries with comments was resolved
- COMMIT/ROLLBACK statements are now recognized as transaction state change statements
- Data transfer:
- Issue with unquoted column names was resolved (data import)
- File import toolbar was redesigned
- Library for XLSX export/import was updated, many minor issues were resolved
- Accessibility:
- Screen-readers support was improved (JAWS)
- Editor tab names reading was fixed
- ER diagrams: issues with notation switch were resolved
- General:
- Issue with output file name after multiple executions of data export task was resolved
- Error "Data transfer IO error" was resolved
- Comments in generated DDL now can be disabled (configurable)
- Countdown visualization before auto-close was added for idle transactions
- Extra tips added in connection keep-alive configuration
- Database navigator: click in empty space handle was fixed (thanks to @itsyfx)
- Databases:
- MySQL:
- Driver version was upgraded to 8.2
- Legacy MySQL 5.x driver was deprecated and replaced with MySQL 8 driver
- Oracle:
- Materialized views indexes management was supported
- Materialized views permissions and dependencies view was added
- Column alter DDL was fixed (NULL clause)
- PostgreSQL:
- Issue with VARCHAR limit change was fixed
- Function comment delete support was added
- SQL Server: extra dialect keyword were added (thanks to @brunodmartins)
- SQL editor:
- Code completion for update statements was added
- Smart completion and replacements of quoted expressions was fixed
- Redundant errors on opening SQL Editor for the first time were removed from the logs
- Database Navigator:
- Filtered objects visualization was added
- Script folder opening was fixed
- Data transfer:
- Attributes names for quoted attributes are handled correctly
- "Copy as HTML" result presentation is improved
- Data editor:
- Background color reset was fixed
- Message about content representation size limit was fixed
- App freeze in binary editor was fixed (MacOS)
- ER diagrams: one-to-one connection rendering was fixed
- Connections:
- SSH connection page validation is enhanced for jump servers
- Complex JDBC driver support was improved (context classloader + driver cache)
- General:
- Script names are sorted alphabetically
- Refresh button was added to the ‘Generate DDL’ dialog
- Issue with app launch was fixed (rare case)
- Databases:
- Oracle: search package bodies as packages was supported
- PostgreSQL:
- Default privileges presentation and editing was supported
- Sequences permissions reading for quoted roles was fixed
- SQLite: required columns creating was fixed
- Data editor:
- Excel (XLSX) export now supports columns auto-fit
- Copy from row bellow/above command was fixed
- Shortcut for "Got to column" column was changed to Ctrl+Shift+G
- SQL editor:
- Script statistics configuration was extended
- AI completion bugs were fixed and configuration UI was redesigned
- Tabs close in horizontal mode was fixed
- Script to connection association save was fixed
- Data export:
- Data import tasks wer fixed for schema-less databases
- Columns value transform expressions evaluation was fixed
- All data transfer were migrated to a new IO API
- Export functionality now can be disabled completely
- Tasks loading for missing database objects was fixed
- ER diagrams: one-to-one connections rendering was fixed
- General:
- Default file encoding was changed to UTF-8. IT affects all external tools integration.
- Web based authentication is now opened in external browser by default
- Version update functionality now can be disabled completely
- Databases:
- Clickhouse: map data type visualization was fixed
- Databricks: issue with national encodings was resolved
- Greenplum:
- Issue with case-sensitive table names was resolved
- FFL for function parameters was fixed
- MySQL: session manager now shows info from performance_schema
- OpenEdge: root catalog is now hidden; data export was fixed
- PostgreSQL: foreign key DDL was fixed (MATCH FULL)
- Misc: we switched to Eclipse 2023-09
- SQL editor:
- Aut-completion for complex SQL queries was improved
- Reconnecting of open editors when switching between Simple and Advanced view was fixed
- SQL console now can be saved as script
- ER diagrams:
- Diagrams notations switcher was added
- Connections rendering was improved
- Crow’s foot notation was added
- Data editor:
- Multiple query results now can be displayed vertically
- `Go to column` (Ctrl+F) action was added
- Column search was added to Metadata panel
- Numeric formatting was fixed for floating point numbers
- Issue with empty table after opening the Calc panel was resolved
- Setting row color for the result set was fixed
- Data transfer: columns automating mapping is now configurable
- General:
- `Restore defaults` on preference pages now resets to actual default preferences
- Eclipse 2023-09 plugin API is now supported
- Reset UI settings was fixed on macOS
- App crash when running on Wayland was fixed
- java.compiler and java.scripting modules were included in bundled Java
Databases:
- Dameng database extension was added (thanks to @Stkai)
- Clickhouse: array map representation was fixed
- Google Spanner: table DDL generation was fixed
- DB2 LUW: trigger editor was fixed
- Exasol: customer group creation was fixed
- Fireberd: several keywords were added
- Materialized: system schemas loading was fixed
- PostgreSQL:
- Backup/restore native tools execution was fixed
- `Europe/Kyiv` timezone support was fixed
- Redshift:
- Schemas loading was fixed
- Spectrum tables loading was fixed (for custom driver configurations)
- SQL Editor:
- Aliases proposals for tables with joins were improved
- SQL console can now be saved as a script
- Enhanced smart completion is enabled (configurable)
- Issue with big string contents (json, xml) edit was resolved
- JSON formatting in the separate editor was fixed
- Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
- JSON functions keywords were added to the SQL Assist
- Representation of errors on query execution was fixed
- ER Diagrams: issue with duplicate relations on the diagram was fixed
- Data Editor:
- Big content representation end editing was limited to 1MB (configurable)
- User can now add a shortcut for setting row color
- Issue with hiding the wrong column from the context menu was resolved
- Grouping panel now shows actual executed SQL
- Decimal rounding error was fixed
- General UI:
- When exporting a project, a warning about replacing an existing project was added (thanks to @MontejoJorge)
- Scroll bars were added on the connection page, and other wizards
- Issue with broken quotes in localization files was resolved
- Connectivity:
- Driver download UI was improved: already downloaded driver files are colored in grey
- JDBC drivers maven artifacts resolve was fixed
- The "Propagate driver properties" option was added to the driver settings
- New drivers:
- JDBCX driver was added (thanks to @zhicwu)
- Databases:
- Clickhouse: IPv4 data representation was fixed
- Greenplum: External tables representation was fixe
- MySQL: Unsupported engine types are replaced with the default one
- Oceanbase:
- Views editor was supported
- Routines and procedure parameters read was fixed
- PostgreSQL:
- Foreign tables folder was added
- Enum data types reading performance was enhanced
- Redshift: Backup/Restore tools were deprecated and removed from UI
- Snowflake:
- Driver was updated to 3.13.25
- Materialized views are now supported
- Schema create UI was enhanced was enhanced
Trino: Views DDL support was added
- Changes since 23.1.5:
- Data Editor:
- Spatial values rendering was fixed
- Spatial images capture was fixed
- Special characters rendering was improved
- Grouping panel icons were improved
- ER Diagrams: saved diagrams now can be opened on another computers
- Data transfer: import settings handling was improved
- Accessibility:
- Connection dialog now supports screen readers
- Cell value reading was improved
- Ctrl+Shift/Alt+PageDn: vertical tabs switch
- Ctrl+ALT+6: SQL editor and results tab switch
- Ctrl+Shift+Enter now opens ER diagram entities
- Ctrl+Shift+N: new connection dialog open
- Database drivers:
- Bigquery: DDL for tables, views and stored procedures was added
- Clickhouse: arrays and structures visualization was fixed
- Greenplum: external tables reading was fixed
- Teradata: issue with the missing templates was fixed
- Many minor UI and database issues were resolved
- Data editor:
- Dictionary viewer panel UI was redesigned
- Spatial data types: curved geometries linearizing was fixed
- Issue was result tab close on data save was resolved
- Column tooltips was fixed
- Charts rendering errors visualization was improved
- SQL editor:
- Autocompletion in single-line comments was fixed
- Variable value editor was fixed
- Smart completion for CTE queries (WITH/SELECT) was fixed
- @include command handler was fixed (reuse the console for the same included script)
- INSERT SQL query generation was fixed (identity columns)
- Issue with text search/replace in hidden files was fixed
- ERD editor: grid foreground color was fixed
- General UI:
- Objects sorting in tables now can be reset to the original ordering
- Network handlers (SSH, SSL, etc) UI was redesigned
- New object creation shortcut was added (Alt+Insert)
- External files opening was fixed on MacOS and Linux
- Command line connection opening was fixed
- User name/password prompt dialog as fixed for SSH tunnels
- Issue with preference pages in Eclipse plugin was resolved
- Accessibility:
- JAWS and Narrator support was improved for data editor and vertical tabs
- High contrast theme support was significantly improved
- Databases:
- Clickhouse: map and array data types visualization was added
- Greenplum: tables DDL was fixed (for version 7)
- OpenGauss DB: json data types support was added
- PostgreSQL: default native clients (pgsql, pg_dump) version was changed to 15
- Yellowbrick: stored procedures drop query was fixed
- Localization:
- Chinese localization was updated (thanks to @bianyun)
- SQL editor:
- Table alias generation was fixed (issue with duplicated aliases)
- Auto-proposals now respect option "empty line is a query delimiter"
- Auto-proposals calculation performance was significantly improved in some cases
- Aliases completion was fixed (issue with redundant spaces)
- Table name completion was fixed for invalid SQL queries
- Spelling errors and other annotations now work in console mode
- @import command behavior is now configurable
- Data editor:
- Filters/orderings/colors reset UI was significantly improved
- Spatial viewer now hides empty labels
- Copying of spatial viewport/selection bounds was fixed
- Drag-n-drop in grouping panel fixed on Linux
- Data transfer: previous export settings loading was fixed
- General:
- Auto-commit mode switch behavior was fixed
- CLI processing was fixed in multi-workspace environment
- "Tip of the day" now shows OS-specific shortcuts corectly
- Redundant logs of SSH tunnel closing were removed
- Logical database structure settings can be disabled or reset in the connection editor dialog
- Driver search UI was fixed on MacOS
- Number of minor UI bugs were resolved
- Database:
- Athena: multi-catalog support was added
- Derby: grouping queries generation fixed
- DuckDB: time/timestamp data types support was added
- MySQL: issue with missing table partitions folder was resolved
- Oracle: table DDL shows permission grants in "full" mode
- PostgreSQL: issue with duplicated tables was resolved
- Redshift: SQL dialect was enhanced with extra keywords
- Yellowbrick: execution plan visualization was fixed
- Spatial data viewer:
- Geometry object labels were added to the map (configurable)
- Curves rendering was implemented
- Coordinates and viewport bounds copy was implemented
- EWKT format support was added
- Toolbars and lasso visibility toggle was fixed
- Data transfer:
- Import of multiple tables from an XLSX was implemented
- Lazy initialization of configuration pages was implemented
- Issue with duplicated file selector dialog was fixed
- Export in XML format was fixed (doctype section is not optional)
- Issue long filenames on Windows was fixed
- Data Editor:
- Find/Replace dialog and shortcut in the Value view panel were fixed
- Column description was added to the Metadata panel
- Folding in the XML presentation was fixed
- Displaying of images in the the value view panel was fixed on Linux
- Confirmation dialog for the result set filtering was improved
- Accessibility:
- JAWs screen reader can now read data in the Data grid
- General UI:
- Tips of the day were updated
- Creation of objects with mixed-case identifiers was fixed
- DDL generation for sequence was fixed
- Logical project deletion was fixed
- Issue with opening of a local project was fixed
- AI:
- New GPT 3.5 Turbo 16К model was added
- Issue with long metadata information sending was fixed
- Connections:
- Duplicates on driver creation were removed
- Issue with maven artifacts editing was fixed
- Certificate management UI was improved
- New drivers:
- Materialize database driver was added (thanks @bobbyiliev)
- Crate DB via PostgreSQL driver was improved (thanks @proddata)
- Databases:
- DB2: users can see Column Mask Objects
- TimescaleDB branding was updated
- Localization:
- Chinese Simplified localization was improved (thanks @bynyun)
- German localization was improved (thanks @fjf2002)