DBeaver 23.2.5

Posted on by Serge
  • 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)
Posted in Releases

DBeaver 23.2.4

Posted on by Serge
  • 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
Posted in Releases

DBeaver 23.2.3

Posted on by Serge
  • 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
Posted in Releases

DBeaver 23.2.2

Posted on by Serge
  • 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+J) 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)
Posted in Releases

DBeaver 23.2.1

Posted on by Serge
  • 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
Posted in Releases

DBeaver 23.2

Posted on by Serge
  • 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
    • Posted in Releases

    DBeaver 23.1.5

    Posted on by Serge
    • 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)
    Posted in Releases

    DBeaver 23.1.4

    Posted on by Serge
    • 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
    Posted in Releases

    DBeaver 23.1.3

    Posted on by Serge
    • 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)
    Posted in Releases

    DBeaver 23.1.2

    Posted on by Serge
    • SQL editor:
      • Mouse hovering over editor annotations was fixed
      • Trailing DDL query delimiter processing was fixed
    • Data editor:
      • References panel refresh was fixed
      • XML presentation was fixed (NULL value handler)
    • General UI:
      • Settings reset UI and behavior were redesigned
      • Editor tab tooltip now contains information abut resource’s project
      • CLI parameter for app version print was added
      • Objects with mixed case names caching was fixed
      • Issue with program launch with wrong Java version was fixed
      • Preferences export/import UI was improved
      • Maven snapshot repository was added to default configuration
    • Connections: kerberos support in legacy JDBC drivers (Hive) was fixed
    • Data transfer: table information for tasks with broken connection was fixed
    • Databases:
      • BigQuery: driver version was upgraded to 1.3.3 (thanks to @fredlegaucher)
      • DuckDB: LIST data type support was added
      • Firebird: filters and sorting in grouping panel were fixed
      • IBM i: driver download was fixed
      • Oracle:
        • Partitions cache refresh was fixed
        • Stored procedures edit/save was fixed
      • PostgreSQL: enum columns alter was fixed
      • Snowflake:
        • Client application name set was fixed
        • Quoted identifiers auto-completion was fixed
    • Misc: internal app controller server now uses HTTP instead of RMI
    Posted in Releases