DBeaver

[Camel1965]

DBeaver 23.2.1​

September 25, 2023

• 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:
• Crow’s foot and Bachman diagram notation styles were added
• 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

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.2.2​

October 8, 2023

• 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
• 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)

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.2.3​

October 22, 2023

• Misc: we switched to Eclipse 2023-09
• 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)

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.2.4​

November 6, 2023

• 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

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.2.5​

November 19, 2023

• 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.
• 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)

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.3.0​

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

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.3.1​

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 23.3.1​

Zaloguj lub Zarejestruj się aby zobaczyć!

Changelog

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 23.3.2​

• Metadata editor:
  • New database objects wizard was redesigned
  • Primary/unique key can be created automatically along with new columns
• SQL Editor:
  • Outline viewer of SQL queries structure was added
  • Execution time format was improved
  • Toolbar customization page opening was fixed
  • Identifiers coloring was improved
  • Autocomplete was fixed for multiline comments
• Accessibility: notifications can be read with a screen reader (JAWs, NVDA or Narrator)
• ER Diagram: connection errors handling was added
• Data Transfer: Incorrect links in settings were fixed
• AI: legacy OpenAI models were removed
• General:
  • Incorrect links to help articles were fixed
  • Redundant items were deleted from the Context menu
  • Global network settings preferences page is available again
• Databases:
  • ClickHouse: leagacy driver configuration was fixed
  • Dameng: tablespaces are supported (thanks to @Stkai)
  • Google Cloud SQL: redundant options were removed from the context menu
  • MySQL: TLS 1.3 support was added
  • MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
  • Teradata: metadata search was significantly enhanced
• Localization:
  • Ukrainian localization was added (thanks to @CrazyTapok-bit)
  • Italian translation was improved (thanks to @coluzziandrea)
  • Portuguese localization was fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 23.3.3​

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 23.3.4​

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 23.3.5​

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 24.0.0​

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Camel1965]

DBeaver 24.0.1​

• Connectivity:
  • Shared SSH sessions support was added
  • Connection via native proxy was fixed
  • Dark theme support on the Connection page was improved
• SQL Editor:
  • Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
  • Incorrect cursor position during autocomplete was fixed
  • QUALIFY keyword was supported (thanks to @ashu7896)
• Metadata editor: automatic reference column creation for a new foreign key was implemented
• Data Editor:
  • Opening of a table with empty data was fixed
  • SRID editing was fixed
• General:
  • SVG icons support was added
  • Error when checking checkboxes in the Formatting page in Preferences was fixed
  • Disappearance of renamed project was fixed (thanks to @saikotek)
• Databases
  • Dameng: Sequence creation was fixed
  • DuckDB:
    • Sequences, views, and table definitions were supported
    • Ability to add comments via UI was added
  • MySQL: link to the driver documentation was fixed
  • RisingWave: non-working functions and folders were removed
  • PostgreSQL: issues with scheduled jobs was resolved
  • SQLite: errors when creating table was fixed
  • SQL Server: redundant authentication types were hidden
  • Sybase: stored procedures support was improved
  • Teradata: procedures and functions DDLs reading was enhanced
• Localization:
  • Romanian language support was added (thanks to @v613)
  • French translation was updated (thanks to @Jean-BaptisteC)

Zaloguj lub Zarejestruj się aby zobaczyć!

 

[Ircus]

DBeaver 24.0.2​

Spoiler

Zaloguj lub Zarejestruj się aby zobaczyć!

Zaloguj lub Zarejestruj się aby zobaczyć!