DBeaver 7.1.1

Posted on by Serge
  • Database navigator:
    • Connection type highlighting was redesigned
    • Simple view support was improved
    • “Force object refresh on editor open” action was fixed
    • Main toolbar UIX was improved (no disabled selectors)
    • Database tools context menu was fixed
  • Table statistics:
    • Rendering problems (redraw on scrolling) were fixed
    • Performance problems were fixed
    • SQL Server support was added
  • Data viewer:
    • Wrong value extraction was fixed for expression aliases which conflict with table column names
    • Dictionary values separator configuration was added
    • Row coloring: support of gradient coloring for read-only columns was added
    • Data formatter:
      • Action “reset to default” was fixed in preferences
      • Preference changes are immediately applied to open data editors
  • SQL editor:
    • Results tab rename was fixed (now we save tab title between results refresh)
    • Parser of multiple SQL queries on a single line was fixed
    • Execution plan explain operation cancel was implemented
    • Coloring of numbers in scientific notation was fixed
    • Paste from source code: \n and \r characters handle was fixed (now we use proper line feeds)
    • Stored procedures call generation was fixed
  • Object editor: “reject changes” and command undo/redo command were fixed
  • Data import: open target table on finish
  • Data migration: DDL generation was improved (apply the same column data type when source and target databases use the same driver)
  • Database tasks: PostgreSQL, MySQL and Oracle tools now can be saved as tasks
  • SSH configurator: UI controls layout was fixed
  • Database driver edit dialog was fixed (legacy driver option is disabled by default)
  • MySQL:
    • User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
    • Unsigned INT and BIGINT data types support was added
  • Oracle:
    • Numeric data type modifiers (scale/precision) rendering was fixed
    • Materialized views read/create and delete was fixed (mviews were removed from table list)
  • PostgreSQL:
    • Vacuum tool was improved (run in auto-commit mode)
    • List of reserved keywords was updated
  • Redshift: View with no schema binding support was added
  • SQL Server: timestamp columns were marked as auto-generated
  • Big number of minor UI and database-specific bugs were fixed
Posted in Releases

DBeaver 7.1.0

Posted on by Serge
  • Database navigator:
    • Statistics view (table sizes) was added
    • Connection coloring was redesigned
    • Connection host name tip was added
  • Data viewer:
    • Ref cursor panel viewer was added
    • Columns sort settings save/load was added
    • Data export in HTML format was fixed (styles)
  • SQL editor:
    • Function call formatting was improved
    • Table alias generation was fixed (for unicode/numeric table names)
  • PostgreSQL:
    • Ref cursors refresh support was added
    • Table and schema statistics was added
    • Table comment and rules were added to DDL
  • Oracle:
    • Metadata search was fixed
    • Java source read was fixed
  • ODBC driver download was fixed
  • Exasol: metadata edit dialogs were redesigned
  • Clickhouse: table statistics was added
  • Firebird: view editor was fixed
  • Plain HTTP driver repositories (Maven or direct links) were replaced or removed
  • Big number of minor UI and database-specific bugs were fixed
Posted in Releases

DBeaver 7.0.5

Posted on by Serge
  • Data viewer:
    • Pin (aka “freeze”) column feature was added
    • Float (32bit) data type render was fixed (MySQL)
    • Plaintext renderer was fixed (binary values representation)
    • Filter value auto-complete was fixed (clipboard paste support)
    • Issue with “order by table column + column alias” was fixed
  • SQL editor:
    • Script close prompt was fixed
    • Hyperlinks now contain procedure parameters
    • Script selector panel positioning was fixed
    • Execute in new tab: new tabs opening was fixed
    • SQL format preferences page was improved
    • SQL formatting was fixed (line feeds after brackets)
    • SQL console title was fixed (source object name was added)
  • Non-https Maven repositories and driver links were removed
  • PostgreSQL:
    • Added parameters to the SQL execution plan explain (ANALYSE is optional)
    • Database backup was fixed on Linux/MacOS (proper table names quoting)
    • Table DDL was fixed (show table comment)
    • Sequence DDL was fixed (START parameter)
    • Object dependencies now contain links on dependent/depending object
    • Permission/role editors were fixed (roles are sorted by name now)
    • SQL auto-completion fixed for older PG (<= 8.4)
  • Oracle: unique key detection was fixed
  • DB2:
    • FOR BIT DATA columns support was fixed (show value as binary)
    • Native SQL dialect support was improved (BEGIN/END)
  • SQLite: ROWID pseudo-column support was added (as unique key)
  • Many other minor bug fixes and improvements
Posted in Releases

DBeaver 7.0.4

Posted on by Serge
  • SQL editor:
    • Format now formats active query by default
    • Matching brackets highlighting was improved
  • Data viewer:
    • Find/replace highlighting and scrolling was fixed
    • Data filter save was fixed (problem with quoted column names)
    • Auto-completion in data filter now can be disabled
  • Object editor: refresh button in bottom toolbar was unified for all pages
  • Dark theme support improved (connection type colors)
  • New connection wizard was fixed (problem with quick driver selector)
  • Driver editor dialog was improved:
    • Extra properties save was fixed
    • Legacy drivers support was added
  • Git extension packaging was fixed (older Eclipse versions support)
  • Derby: new database create was fixed
  • Firebird: system objects hide/show was fixed (determine system flag from fro meta table)
  • MySQL:
    • Read-only connections support was fixed (SQL editors)
    • Query execution plan explain was fixed
  • Oracle:
    • Driver configuration was fixed (typo in Maven artifact name)
    • Java classes source viewer was added
    • Materialized view DDL read was fixed
    • PL/SQL parser was fixed (CASE/WHEN/END)
  • PostgreSQL:
    • search_path update was fixed
    • Numeric values rendering was fixed
  • Redshift: SOCKS proxy support was fixed
  • SQL Server: table DDL generation was fixed (column type names)
  • SQLite: foreign key metadata read was fixed (FKs with no name)
  • Portuguese (BR) localization was added (thanks to @wellesximenes)
  • Many minor bug fixes and improvements
Posted in Releases

CloudBeaver 1.0

Posted on by Serge

Great news, everyone!

We released a new open-source project.

We are happy to introduce new web-based and cloud-ready database management application. Please, welcome CloudBeaver!

CloudBeaver is free and open source. As an open-source product it already supports the most popular open source databases, such us PostgreSQL, MySQL, MariaDB, SQLite and Firebird.
You can look through the code in our GiHub repository, test it on the demo server and deploy it in your database environment.
As usually, we open for your feature requests, questions and suggestions.

Take a look!
DBeaver team
Posted in Releases

DBeaver 7.0.3

Posted on by Serge
  • Data viewer:
    • Problem with unreachable last row/column was fixed
    • “Open With” action now uses configuration from last data export
    • Find/replace issues were fixed (scroll to found cell)
    • Bug in reference panel was fixed (multiple value selection)
    • Filter value auto-completion was fixed (popup close)
    • Virtual unique keys management was improved
  • SQL editor: multiline code templates apply was fixed (thanks to @VASilaev)
  • Number of bugs were fixed in the Simple navigator view
  • Transaction management was improved (redundant transaction commit confirmations were removed)
  • GIS viewer: many new (and cool) tiles were added (thanks to @mkgrgis)
  • Active catalog/schema selector UI was improved
  • Connection edit dialog was fixed (error during page switch)
  • Oracle:
    • Connection settings (SID/Service) save was fixed
    • Session terminate was fixed (for non-RAC databases)
  • Exasol:
    • Foreign key creation was fixed
    • View DDL extraction was fixed (auto-format was disabled)
  • HANA: unique key creation was fixed
  • Firebird: procedure metadata refresh was fixed
  • Problems with remote RDP connections (app crash) were fixed
  • Japanese localization was significantly improved (thanks to @ScratchBuild)
  • We have migrated to Eclipse platform 2020-03
  • Many other minor bug fixes and improvements
Posted in Releases

DBeaver 7.0.2

Posted on by Serge
  • Database navigator:
    • Simplified database structure view was added
    • Navigator view settings and presets were added
  • Object editor:
    • Context menu was added to the object breadcrumbs
    • Object alter script now can be opened in SQL editor
  • Data editor:
    • Preference and data format changes now applying immediately (without data refresh)
    • Scrollbar position reset in columns reorder/filtering was fixed
    • Number of selected rows/columns/cells now shown in the status bar
    • Query filter history save/load was fixed
    • Floating point numbers (4-byte precision) rendering was fixed
  • SQL Editor: quick search tool was added (ctrl+alt+shift+f)
  • Driver copy was fixed (problem with read-only URL)
  • PostgreSQL:
    • PGPASS support was fixed
    • Database information (ctype, collate) reading was fixed
    • Problems with default database change were fixed
    • OID types rendering fix
    • Domain metadata reading was fixed (base type qualified name)
    • Extra options were added to database backup/restore wizards
  • Redshift: data type resolution was fixed (array types)
  • SQL Server:
    • Driver download and “reset to default” was fixed
    • Default schema detection was added
    • Problems with read-only query results were fixed
    • Column comments edit was fixed
  • MySQL:
    • Permission editor was fixed (schema privileges)
    • Index rename support was added
  • Exasol:
    • Security tree (Exasol 7) was fixed
    • Auto-completion for builtin functions was added
    • Foreign keys metadata was fixed
  • Oracle: “drop procedure” support was fixed
  • SAP HANA: driver download was fixed
  • Firebird: driver version was upgraded (4.0)
  • Many other minor bug fixes
Posted in Releases

DBeaver 7.0.1

Posted on by Serge
  • Data viewer:
    • Search/replace in selected rows support was added
    • Problem with Find/Replace and scrolling was fixed
    • Floating point numbers rendering/copying was fixed (precision fix)
  • SQL editor:
    • Connection initialization was fixed (active schema set)
    • Auto-completion for DROP/ALTER procedure/function was added
    • Auto-completion for asterisk (*) was fixed
    • Auto-completion for table aliases was disabled
    • Auto sync with database navigator was fixed (proper catalog/schema change)
  • ERD viewer: table resize support was added
  • Query manager: full query text view was fixed
  • Connections invalidate was fixed (redundant connections open) and invalidate performance was improved
  • Schema compare (simple):
    • Compare progress visualization was fixed
    • Stored procedures body compare was fixed
  • SSH tunnel: default user name (current OS user) is used when user name not set
  • PostgreSQL:
    • PGPASS authentication was added
    • Unique key indexes visibility was fixed
    • Schema permissions viewer/editor was added
    • Function/procedure create dialog was fixed
    • Options for tables/functions DDL viewer now saved
    • Enum values editor was added
    • Array values copy-paste was fixed
  • Oracle:
    • Automatic driver download was added
    • View constraints create/drop support was added
  • DB2 LUW:
    • Automatic driver download was added
    • Table references read was fixed
  • SQL Server:
    • Driver download (native artifacts) was fixed
    • Custom SQL query result editor was fixed
    • Schema selector (main toolbar) was fixed
  • SQLite: column rename support was added
  • Snap package was significantly improved (thanks to @galgalesh)
  • Many other minor bug fixes
Posted in Releases

DBeaver 7.0

Posted on by Serge

DBeaver 7.0 is our new major release.

Changes since 6.0:

  • Tasks management: data transfer, backup-restore, SQL execution
  • Data viewer and data editor UI major improvements:
    • GIS/geo-spatial viewer
    • JSON viewer
    • Logical columns, primary and foreign keys
    • References panel
    • Advanced row coloring
  • SQL editor major improvements:
    • Smart-commit mode
    • Enhanced SQL parser and auto-complete proposals
  • Git integration
  • SSH agents and jump servers support
  • And a lot of other great things

Moreover:

  • We increased number of supported drivers to 81
  • We closed almost 2000 issues on GitHub.

Thank you for your support!

Changes since 6.3.5:

  • SQL script execute task:
    • Support of multiple scripts was added
    • Support of multiple connections was added
    • Configuration wizard was completely redesigned
  • SQL editor:
    • Auto-complete proposals were colorized
    • Auto-complete for table column possible values
    • Synonyms are now resolved as tables
  • Data viewer:
    • Filter panel auto-completion was fixed
    • Value viewer panel refresh was fixed
    • Boolean column transformation was added (view numeric columns as checkboxes)
  • Import from CSV: column mappings was fixed
  • Popup panels unexpected close was fixed
  • Invalidation of dead SSH tunnels was fixed
  • PostgreSQL:
    • Type cast for updates and filters is now used
    • Timestamp scale edit was fixed
  • SQL Server:
    • Driver version upgrade (to 8.2)
    • Data import for IDENTITY columns was fixed
  • MySQL: permission editor supports schema masks
  • Oracle:
    • PL/SQL parser was fixed
    • Comment editor for views and functions was fixed
    • TIMESTAMP WITH TIMEZONE support was improved
  • HANA:
    • GIS (geometry) data types support was improved (by @stefanuhrig)
    • Table column drop was fixed
  • OmniSci: driver version was updated.
  • Linux: UI freezes were fixed
  • A few minor UI improvements (icons, English localization, ERD colors, shortcuts)
  • A lot of minor bug fixes
Posted in Releases

DBeaver 6.3.5

Posted on by Serge
  • Data viewer:
    • Read-only columns UI was improved (icon + explanation were added)
    • Filter text content assistant was significantly improved
    • Row count calculation control UI ws fixed
    • “Set default value” shortcut was changed
    • Ordering in record mode was fixed
    • Data change confirmation was fixed
    • Plaintext presentation rendering was fixed (extra spaces)
    • Numbers native representation mode (no client-side formatting) was added
  • SQL editor:
    • Export from query task was fixed
    • Output tab now remains active after query execute
    • Auto-commit toggle was fixed (rollback is performed on mode switch)
    • Connection initialization was fixed (“Not connected to a database” bug)
    • Column values assistance was added
    • Numbers color and font was fixed
  • ERD viewer:
    • Entity/schema diagram “reset” action was added
    • “Show views” option handle was fixed
  • Connections and drivers:
    • Variables support was improved (now all properties may contain variables)
    • Maven artifact version resolution was fixed (null version bug)
    • External drivers configuration support was added (see wiki)
  • PostgreSQL:
    • Query cancellation was fixed
    • Hyperlinks and “Go to object” action were fixed (now they use current database instead of default one)
    • Schema privileges were added in DDL
    • Indexes read was fixed (redundant primary key constraint was removed)
    • Arrays of domain types support was fixed
    • Column copy-paste support was added
  • MySQL:
    • Identifiers redundant quotation was fixed
    • Column copy-paste support was added
  • Oracle:
    • Default schema detection was fixed
    • Double compilation of package was fixed
    • PL/SQL parser was improved (case .. when .. end)
  • DB2: alter column DDL was fixed (column modifiers were added)
  • SQL Server: metadata search was fixed (wrong object types bug)
  • AWS Athena: error position highlighting was added
  • Sybase: legacy versions (12 and earlier) support was improved
  • A lot of minor bugfixes
Posted in Releases