DBeaver 7.1.3

Midsummer release. Vacation time

  • Spatial presentation: tooltips rendering was fixed
  • DB2: UI tools were converted into database tasks
  • MySQL/MariaDB: database restore was fixed (binary data corruption)
  • PostgreSQL: data type DDL was improved + comment edit support was added
  • Oracle: problem with connect as SYSDBA was fixed
  • Exasol: (thaks to @Sargul)
    • Database error type discovery was added (proper handle of “connection lost” errors)
    • Metadata read performance was improved
  • Googlee Spanner: official driver configuration was added (thanks to @olavloite)
  • Simple view mode was fixed (redundant database objects were hidden)
  • Proxy configuration UI was fixed
  • MacOS installer was fixed (potential vulnerability was removed, thanks to @De4dCr0w)
  • Tasks management: error handing was improved (for deleted tables)
  • We reverted to Eeclipse 2020-03 platform (it resolves a set of UI glitches on some platforms)
  • A few minor UI and database-specific bugs were fixed
Posted in Releases

DBeaver 7.1.2

  • Data viewer:
    • Now we refresh entire row after cell value update (handy if you have triggers)
    • Generate SQL context menu was fixed
    • Horizontal scroll with mouse wheel support was added
    • Export data in source code (PHP arrays) format was added
    • Bug with Ctrl+Backspace handler was fixed
  • SQL Editor:
    • Query cancel handler was improved (problem with UI stuck was fixed)
    • Now we show query information in the result tab tooltip
    • Query parser was fixed (active query extraction for Ctrl+Enter action)
    • Template variables (${word_selection} and ${line_selection}) support was fixed
  • Navigator:
    • Icons for “Create object” actions were fixed
    • Main menu File items were reordered
    • Heading and trailing spaces trim was added to all edit dialogs/panels
  • Session manager: problem with multiple windows was fixed
  • SQL Server: Database tools (index rebuild, triggers disable) were redesigned
  • Firebird: new table and table column creation was fixed
  • PostgreSQL: Table partition DDL was fixed
  • MySQL: CHECK constraints edit support was added
  • Oracle:
    • Table statistics read was fixed
    • Schema indexes folder was added
    • Check constraints editor was added
    • Trigger status icon was fixed
  • Exasol: (thanks to @Sargul)
    • Metadata read performance was improved
    • Metadata search support was added
    • Table references
    • Index create DDL was fixed
    • Table statistics read performance was improved
  • Redshift: driver download was fixed
  • SQreamDB driver was added
  • YugabyteDB driver was added
  • We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs
Posted in Releases

DBeaver 7.1.1

  • 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

  • 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

  • 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

  • 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

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

  • 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

  • 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

  • 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