You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
DBeaver
- Autor tematu Jarom
- Rozpoczęty
DBeaver 21.2.5
November 15, 2021
- Data editor:
- Spatial viewer now saves proper SRID for tables and columns
- Find/replace for BLOB/CLOB columns was fixed
- Metadata editor:
- Navigator refresh was fixed
- Schema-level index create was fixed
- ERD editor: columns search was implemented
- SQL editor:
- Files copy into new project was fixed
- Backup/restore wizard UI was fixed (MySQL and PostgreSQL)
- Task wizard buttons enable/disable was fixed
- SQLite: driver updated to version 3.36
- Greenplum/Redshift: session and lock managers were added
- MariaDB/MySQL: tables metadata load performance was improved
- Oracle:
- Full-text search for functions and procedures was implemented
- Option “show only current schema objects” was implemented
- PostgreSQL:
- Foreign key settings edit was implemented
- Array value parser was fixed
- Roles names quote was fixed in grant/revoke commands
- Snowflake: driver version was updated (fixes problems with MFA)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.0
November 28, 2021
- Data viewer:
- Filters configuration dialog UI was fixed (MacOS)
- Found occurrences highlighting was fixed (find/replace)
- Problem with long columns resize was fixed
- Problem with overlapping column icons was fixed
- Diagram viewer: connections auto-layout was fixed
- Problem with SQL script preview dialog was fixed on MacOS
- Error “PKIX path building failed” was fixed on Windows (OS certificate storage is now the default)
- Dark theme: bug with mismatching colors was fixed on MacOS
- Problem with missing file extensions was fixed (Windows)
- Metadata editor: editor flickering after mode change was fixed
- Full-text search now keeps original table filters
- Currupted projects auto-recovery feature was added
- Legacy error/warning icons were replaced with new ones
- Version auto-upgrade:
- Incorrect package type detection was fixed
- Incorrect architecture (M1/ARM/x86) detection was fixed
- Driver editor:
- URL template edit support was added for all drivers
- Maven artifacts import/edit UI was improved
- SSH tunnel test: system variables support was added
- New database drivers:
- Babelfish driver was added (thanks to @okeuday)
- OceanBase driver was added (thanks to @LuckyLeoZZ)
- Greenplum: permission editor was fixed for older GP versions
- MySQL/MariaDB/PostgreSQL: backup/restore tasks create wizard was fixed (NPE)
- ODBC: app crash on editor open was fixed
- PostgreSQL:
- Database structure was redesigned (all cluster-level entities moved to the top level)
- Multirange data types support was added
- Exclusive schema filters support was fixed
- Support of JSON columns in unique keys was added
- SQLite: table indexes create/delete support was added
- SQL Server: auto-completion and hyperlinks were fixed in stored procedures
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.1
December 12, 2021
- SQL editor:
- Auto-completion for tables without alias was fixed
- Script file name template support was added
- Data editor: column filters edit dialog UI was improved
- Resource manager: cross-project connection drag-n-drop was fixed
- Task manager: task statistics read was fixed
- SQL query generator: string values quotation was fixed
- Driver manager: Maven artifacts import/edit UI was improved
- Connection lock password support was fixed
- Navigator:
- Object filters now support backslash escape
- Multiple minor UI bugs were fixed
- DB2: table organization property was added
- PostgreSQL, Greenplum, Redshift:
- Permission editor UI was fixed (redundant GRANT/REVOKE commands merge)
- Composite data types support was fixed
- Execution plan rendering was fixed (“Parallel” scan)
- Partition tables statistics read was fixed
- SQL Server: column data type modifiers generator was fixed
- SQLite: table foreign keys editor was added
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.2
December 26, 2021
- Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
- SQL editor: “hippie” auto-completion support was added (beta)
- SSHJ implementation now included in DBeaver Community by default
- Problem with DBeaver crash was fixed (when workspace path contains spaces)
- Session manager: column grouping was added
- Command line support: default connection now set for opened SQL scripts
- SalesForce driver was added
- AWS Athena: driver version was updated, problem with column filters was resolved
- Clickhouse: typed arrays support was added
- Derby: check constraints support for remote server driver was fixed
- SAP HANA: public schema presentation was changed (thanks to @kai-morich)
- SQL Server: external tables support was added
- Data editor:
- Auto-completion was fixed in filters panel
- XML auto-format was fixed (elements sort was disabled)
- Filter by column with alias was fixed
- Numeric type transformer was fixed
- Extra tab close action were added (close to the left/right)
- Arrays presentation in record view was fixed
- Driver management:
- New Java11 modules were added to support new JDBC drivers (java.net.http)
- Drivers copying was fixed (keep advanced driver settings)
- Maven artifacts edit dialog was fixed
- Data transfer:
- CSV parser performance was significantly improved
- Identifiers case configuration was added in SQL export format
- Option to append results to an existing file was added
- Date formatting was fixed for JSON format
- Variables support in saved tasks was fixed
- Support of arrays import from CSV was added
- Problem with export wizard buttons enablement was fixed
- Babelfish:
- Synonyms, sequences and triggers were removed from metadata navigator
- Cross-database access was disabled, only default database is visible
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.3
- Data editor:
- Date/time editor now supports calendar-like UI
- Column names quoting was fixed in filter clauses
- Filter for array columns was fixed
- Gis viewer: SRID switch behavior was fixed
- Save/cancel button are now disabled during data save process
- Column filter now uses exact match for numeric values
- Status message now shows execute timestamp
- Advanced copy now respects quoted column names
- SQL Editor:
- Multiple result tabs refresh was fixed
- Import file now supports multiple files selection
- Client-side commands (@set, @include) parser was fixed
- Auto-completion fix for SELECT .. INTO queries
- Auto-completion now uses "hippie" completion algorithm by default
- Copy as source code: Delphi format was fixed
- "Copy selected query" command was added
- Variables and parameters deletion was improved
- SQL formatting was fixed (redundant empty lines eliminated)
- Tab context menu was improved (additional items were added)
- Code folding restore was fixed
- Data transfer:
- XLSX import was improved (problem with column mapping was fixed)
- Import from CSV now uses approximate column length calculation
- Append to file mode was fixed
- Navigator: tree state loading was fixed
- SSH tunnel:
- Advanced tunnel configuration UI was improved (window auto-resize)
- Tunnel test dialog now supports test interruption
- Private key configuration was fixed for jump servers
- Task execute status now shows more detailed information
- Eclipse plugin: history navigation shortcuts support was fixed
- MacOS: application termination on detached window close was fixed
- Localizations:
- Simplified Chinese localization was significantly updated (thanks to @bianyun1981)
- Italian localization was updated (thanks to @capitanfuturo)
- Japanese localization was fixed and updated (thanks to @yoshinorin)
- Oracle: native quoting parser was fixed
- PostgreSQL:
- Error (NullPointerException) in explain execution plan was fixed
- Role DDL was fixed (connection limit)
- SAP HANA: hyperlink navigation ws fixed
- SQL Server:
- Database metadata read fix (problem with is_external column)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.4
February 6, 2022
- Data editor:
- Row fetch size now can be set to a small value (up to 1 row)
- Search in data grid with enabled numbers formatting now works properly
- Date/time editor calendar presentation now shows proper error messages
- Data loss on resultset scrolling confirmation was added
- Option to highlight selected cell value was added
- Value view panel now supports shortcuts to switch between data formats (configurable)
- SQL editor:
- Bug with missing resultset tab focus was fixed
- Script selector panel now supports “All connections” mode
- Data transfer:
- Export of columns of composite data types support was added
- Popup message boxes were replaced with task bar notifications
- Navigator tree: database object comments render was added (configurable)
- BLOB/binary editor: problem with changes saving in hex editor was fixed
- Dashboard view: problem with memory leaks was resolved
- Auto-close of idle connections option was added (configurable)
- Driver editor: Maven artifacts settings save/load was fixed
- Bug with empty editor tabs after restart was fixed
- Redundant logging during connection context menu opening was fixed
- New database drivers:
- Apache Calcite Avatica
- Apache Druid
- Apache Kylin
- Clickhouse:
- New driver was added. Old driver was renamed to Legacy.
- LIMIT clause support was added for data read queries
- Exasol: execution plan save/load was implemented
- MySQL/MariaDB: permission editor was redesigned, grant option support was fixed
- MariaDB:
- New driver (3.x) support was added
- Packages and sequences support was added
- Oracle:
- Table constraints load performance was significantly increased (thanks to @skybber)
- PL/SQL syntax support was improved (packages and procedures parser was fixed)
- WITH clause parser was improved
- PostgreSQL:
- Identifiers quoting was added for table DDL
- Database backup now supports “drop if exists” option
- Row replace method “ON CONFLICT DO UPDATE” support was fixed
- Redshift:
- New view create was fixed
- Driver version was updated to 2.1
- Generic driver now support sequences and synonyms edit/rename
- Japanese localization was improved (thanks to @yoshinorin)
- Several minor UI bugs were fixed
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 21.3.5
February 21, 2022
- SQL editor:
- Problems with app freeze on very complex queries executing was fixed
- Parameters binding dialog now supports multiline editor
- Script selector panel UI was fixed
- New scripts now position cursor to the end of script
- Data editor:
- Columns drag-n-drop support was fixed (Linux)
- Dictionary table editor now supports default column names customization
- Connection-specific data formatting settings save was fixed
- Metadata editor:
- Table DDL is now auto-updated after new table editing
- Navigator:
- Bug with connection element expansion during connect was fixed
- Table statistics refresh was fixed
- Columns configuration (visibility, size, order) save/load was improved
- “Expand on connect” now expands both database and schema
- Column reordering now supports multiple columns
- SSH: known_hosts support and validation of target host before connect were added
- Various database tools: NullPointer error in task wizard was fixed
- Data transfer: table re-create option was added
- Clickhouse: problem with access to read-only connections was fixed
- Firebird: columns autoincrement option editor was added
- Generic driver: ClassCast error during connection instantiation was fixed
- PostgreSQL:
- Event triggers support was added
- Greenplum, EDB: local clients configuration was added
- Google Cloud driver support was fixed (driver dependencies)
- Functions signature now include out parameters
- GIS viewer for columns in complex data types ws fixed
- CIDR data type support was added
- Deferrable foreign keys create was fixed
- SQL Server Synapse support was improved (metadata reading)
- Trino: problem with corrupted navigator tree after long connect was fixed
- New drivers: Denodo driver configuration was added (thanks to @scruz-denodo)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0
Changes since 21.3.5:
- Data transfer:
- Table recreate mapping type was added
- Table selector dialog now supports filters configuration
- Variables configuration for data transfer tasks was fixed
- Variables auto-complete was fixed in output file name
- Custom data formatting now applied for TXT export format
- Insert statement now supports DEFAULT clause for empty list of columns
- Data editor:
- Row count calculation query was fixed
- Rows scrolling was disabled for data modifying queries
- Problem with editor focus after new row add was fixed
- Column value filter was fixed (wrong SQL query)
- SQL editor:
- Parameters binding dialog was improved (multiline editor was added, keyboard shortcuts were fixed)
- Filtering and ordering by columns with aliases was fixed
- Problem with cursor jump to script end was fixed
- Script selector popup was fixed (issue with datasource association)
- Script task execute was fixed (for connections without default database)
- DDL generator: option to generate FKs as separate statements was added
- Metadata search: search by LIKE pattern was fixed
- Session manager UI was fixed (multiline cells on Linux, background color for connection type)
- Interface language now can be changed in preferences (for MacOS and Linux installers)
- SSH: option to disable host name validation was added
- Local clients configuration load was fixed (MySQL and PostgreSQL derived drivers)
- Azure SQL server: view definition read was fixed
- Clickhouse: read-only connections support was improved
- H2:
- Driver configuration for version 2.x was added
- Check constraints support was added
- Unique keys support was added
- MySQL: new view creation was fixed (DDL)
- Oracle:
- Metadata read performance was significantly increased
- Case-sensitive navigator filters support was fixed
- Snowflake: custom authentication configuration option was fixed
- SQLite: sequences read was fixed
- SQL Server: open database object dialog now respects selected database
- Italian localization was improved (thanks to @capitanfuturo)
- Many minor UI bugs were fixed
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0.1
March 20, 2022
- Navigator:
- Connection read-only state switcher was added in main toolbar/menu
- Data editor:
- Auto-refresh UI was fixed (stop on error visualization)
- Array data types handling was improved (PostgreSQL, Clickhouse)
- Invalid fractional seconds rendering was fixed
- Filter panel is removed in non applicable presentations
- Number of selected rows calculation was fixed
- Row colors reset option was added
- Edit controls enable state was fixed for plaintext view
- Keyboard shortcuts were fixed in inline date/time editor
- Next segment auto fetch was fixed for specific queries
- Data transfer:
- "Ignore duplicated rows” option was added
- Table mapping “re-create” support was improved
- Skipped columns configuration save was fixed
- SQL editor:
- Data filter injection for custom SQL queries was improved
- Transaction monitor was fixed (amount of statements in a transaction)
- Tasks: task ordering was fixed (folders on top)
- Command line: possibility to specify external variables file was added
- MySQL: indexes edit support was added
- Oracle:
- Sequences DDL tab was added
- Scheduler jobs metadata read was fixed
- Arrays presentation was improved (numbers formatting was fixed)
- Materialized view save was fixed PostgreSQL:
- View source editor was fixed (redundant ‘create or replace’ clause was removed)
- Template databases are now visible is specified in connection settings
- Server version < 8 support was improved
- Saved backup/restore tasks UI was fixed
- Redshift:
- Search in procedure definition was fixed
- Vertica:
- Metadata performance was significantly improved
- Table/column comments are now read in lazy mode
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0.2
April 4, 2022
- Data editor:
- Option “show whitespaces” was added
- Columns reordering in data filter dialog was fixed
- Line numbers were added to plaintext view
- SQL editor:
- Script error visualization is not configurable
- Block statements (BEGIN, IF, CASE) auto-close was improved
- Auto-completion was fixed for INSERT queries
- “Cancel active query” command was added
- Filtering of aliased columns was fixed
- Problem with DML queries re-execution on connection lost was fixed
- Python source code format was added to Copy As command
- “Hippie” auto-completion was disabled by default (due to performance problems)
- SQL commands parser/navigation was fixed (thanks to @arvillion)
- Parameter bindings dialog was disabled for long strings (like $$)
- CASE/WHEN formatting was fixed
- Driver editor:
- Driver description editor was fixed
- Maven artifacts version resolution was improved
- Data transfer: recreate table mapping support was fixed (saved configuration and tasks)
- SSH tunnels: connection timeout/keep-alive parameters change was fixed
- MacOS: problem with application launch was fixed (problem with plist file modification)
- Dark theme: buttons UI now matches OS theme
- Apache Druid, Apache Kylin:
- Table data read was fixed
- Data type properties were fixed
- Indexes read was fixed
- Azure Databricks driver was added
- Clickhouse: array data type editor was implemented
- DB2: query terminator redefine support was added
- H2:
- System views DDL generation was fixed
- Geometry data type rendering in new H2 driver was fixed (thanks to @ebocher)
- MySQL: functions execute was fixed
- PostgreSQL:
- Nested arrays editor was implemented
- Functions source code generation was fixed (function signature)
- Portuguese localization was fixed (thanks to @TiagoValdrich)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0.3
- Data transfer:
- "Append to existing file" feature was improved (for CSV, TXT and XLSX formats)
- Export wizard now loads saved properties on demand
- Export of result set with reordered/hidden columns was fixed
- Export in SQL format: "split on multiple files" now works correctly
- Task execution notification was improved
- SQL script tasks support was fixed (NullPointer error was resolved)
- Export of many tables into a single target table was fixed
- Import from CSV was fixed (problem with null handling was resolved)
- Trim whitespaces option was added for CSV import
- Table columns mapping UI was fixed on MacOS
- SQL editor:
- Error position information was added in error messages
- Query error highlighting was improved
- Database navigator:
- Support of databases with bug number of schemas was improved
- Column grouping now shows number of grouped elements
- Auto-completion was improved in properties editor
- General:
- DBeaver now shows EULA on start (one time)
- Problem with workspaces on network paths was resolved
- Kerberos configuration load was fixed on RHEL
- Apache Phoenix: connectivity problem was fixed by setting proper driver version
- CockroachDB: ROWID columns support was added
- DB2 i:
- Sequences support was added
- View definitions read was implemented
- Unique and check constraints support was added
- Multiple minor improvements in metadata read were added
- Exasol: search in view/procedure source code was implemented
- MySQL: problem with table lock during database dump was fixed
- Oracle:
- View source code edit was fixed (problem with view comments was resolved)
- PostgreSQL:
- pg_dump and pg_restore version was upgraded (to PG 14)
- Script execute task now shows all script errors
- Snowflake: support of LIMIT for custom SQL queries was added (affects performance)
- Italian localization was significantly improved (thanks to @capitanfuturo)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0.4
May 1, 2022
- SQL editor:
- Problem with semicolon on a new line was fixed
- Problem with client-side commands parsing was fixed
- Error highlighting support was improved
- Tabs close/confirmation behavior was improved
- Script with multiple @set commands processing was fixed
- Command for data export automation was added (@export)
- Toggle comment command was fixed (thanks to @arvillion)
- SQL script datasource association command was fixed
- Data editor:
- Value filter now shows total number of distinct values
- Search for whole word was fixed
- Custom filter value save was fixed
- Spatial viewer:
- Ability to select spatial objects on map and data grid was added
- Default zoom level option was added
- Data transfer:
- Default data type mapping was improved (especially for char/varchar columns)
- Multi-table transfer now opens all target tables
- Database restore task now requires additional confirmation
- Output folder parameter now supports additional variables
- Import task UI was fixed (problem with lost target tables configuration)
- SQL export format now supports append mode
- Navigator: database selector popup was fixed (null pointer error)
- SSH: problem with connections and corrupted known_hosts file was resolved
- CLI: parameter “create” was fixed for connection opened using -con parameter
- Windows: DBeaver now supports workspaces on network paths (e.g. \network-shareworkspace)
- MacOS: problem with UI freeze after data edit was fixed
- DB2 i: keys and foreign keys metadata read was fixed
- MySQL:
- Generate SQL for geometry data types was fixed
- Permission editor was fixed (problem with duplicated permissions)
- Problem with decimal data types with zerofill flag was fixed
- UPDATE SET replace method was added
- Netezza: table rename SQL was fixed
- Oracle: table partition metadata read was fixed
- PostgreSQL:
- Problem with SQL generation and JSONB columns was fixed
- View column edit support was added
- Default driver version was changed to 42.2.25 due to security reasons
- SQLite: connection settings dialog UI was fixed (Open and Create buttons behavior)
- SQL Server:
- Money data type support was fixed
- Connection settings dialog was redesigned
- A lot of minor fixes in application localization
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.0.5
May 22nd, 2022
- Data editor:
- Numbers formatting: digit group size option was added
- Problem with unexpected change of timestamp values was fixed
- Smooth scrolling on MacOS was improved (thanks to @Andrew0002)
- Data transfer: XML format export was improved (encoding information)
- SQL editor:
- Results tab reuse behavior was fixed + new config option was added
- Result logging was added for script execute task (thanks to @avandorp)
- Redundant “Problems” view popup was removed
- Keywords highlighting was fixed (problem with identifiers which start with underscore)
- Diagrams:
- Connected entities highlighting was added
- Entities and columns search was improved
- New diagram routing was added
- Problem with unreadable comments was fixed (dark theme)
- Export in SVG and Graphml formats was improved
- Pseudo columns were removed from diagrams
- Diagram re-arrange was fixed
- Many minor bugs were fixed
- Connections:
- Creating connection from JDBC URL was improved
- Opening connection using CLI was improved (extra option -save was added)
- Preference pages: problem with small font size ws resolved
- Linux:
- Problem with workspace load was fixed on some
- Problem with UI freeze in connection type editor was fixed
- PostgreSQL:
- SSPI authentication support was added (problem with JNA library conflicts was resolved)
- Read-only connections support was improved (restrict of DML queries)
- Scheduled jobs management was added
- SQL Server:
- External tables metadata read was fixed
- NTLM authentication support was fixed
- Italian localization was improved (thanks to @andreagualandi)
- Chinese localization was improved (thanks to @bianyun1981)
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
DBeaver 22.1
Changes since 22.0.5:
- General UI:
- Local timezone configuration was added in preferences
- Connection type color now affects SQL editor panels
- Tab selector (CTRL+E) now supports fast/fuzzy search
- Project rename now updates project name in all linked views
- Problem with navigator tree refresh was resolved
- Preference pages now respects font configuration
- Configuration popup positioning was fixed for low-res monitors
- Problem with embedded dropdown editors was resolved (MacOS)
- Problem with application start on some MacOS and Linux installations was fixed
- Read-only connections toggle was redesigned
- “Copy object name” action was added to tab context menu
- Data editor:
- Color by range now supports foreground color customization
- Problem with clob/json popup editors was resolved
- Epoch time transformer now supports 4 more modes (thanks to @nodaki)
- Grouping panel: problem with GROUP BY query generation was fixed for many analytical databases
- Date/time inline editor UI was improved (thanks to @PILINING)
- SQL editor:
- Right click on a script text now changes cursor position
- Part divider element visualization was improved
- Confirmation was added for “Delete this script” action
- Dangerous query execution confirmation configuration was fixed
- DB2: procedure name auto-completion was fixed
- HANA: procedures output parameters fetch was fixed
- Netezza: case-sensitive user names support was added
- Snowflake: database metadata read performance was significantly improved
- Teradata: SQL query limit (TOP) support was added
- Many minor UI bugfixes
- New database driver: Apache Kyuubi
Zaloguj
lub
Zarejestruj się
aby zobaczyć!
Udostępnij: