DBeaver v5.1.3

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.1.3 (15 Jul 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:

  • Database objects search fixed (GoTo object dialog)
  • Database full-text search was improved (state loading, bug were fixed, search history was fixed)
  • Default error dialog was redesigned (allow message copy-paste and scrolling)
  • Drivers download errors was fixed (missing Maven artifacts handling)
  • ERD looks-and-feel was fixed. Extra configuration was added.
  • SQL editor:
    • Query comments processing was fixed
    • Left toolbar rendering was fixed (background color issue)
    • SQL formatter for sub-selects was fixed
  • Results viewer:
    • Presentation switch error was fixed
    • Sorting by ambiguous columns was fixed
    • Visualize read-only columns in grid header (different background color + tooltip)
    • Value view panel read-only state handling was fixed
    • Search in value view panels was added
    • Execution log and output panel toggle shortcuts were changed
  • PostgreSQL:
    • Driver version updated to 42.2.3
    • Multi-database support was improved (no need to switch active database on access)
    • Foreign table DDL was fixed
    • Materialized view DDL was fixed
    • Domain data types resolution was fixed (problems with date/time types)
    • Debug perspective switch was fixed
  • MySQL:
    • New driver for MySQL 8.x was added
    • Timestamp time zone issue was resolved
  • Oracle:
    • Tablespace storage information was fixed
  • Yellowbrick driver configuration was added
  • Timescale driver connection page was fixed
  • SAP HANA: activate database switch was added
  • Data export in SQL: null table name issue was fixed
  • Data transfer by segments + table truncate was fixed
  • Database output log contents filtering was added (zero characters)
  • Database navigator: icons position was fixed
  • New table columns rename was fixed
  • MacOS installer was fixed (CE and EE version on the same machine issue)
  • Debug logging was fixed (do not log secure information)
  • Many minor UI fixes
Advertisements

DBeaver v5.1.2

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.1.2 (01 Jul 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:

  • SQL editor:
    • Commands toolbar was redesigned
    • SQL formatting for JOINs was fixed
    • Indentation in auto-formatter was fixed
    • Vertical editor selection bug was fixed
    • Support multiple values in @SET command
    • Command shortcut processing was fixed
  • Results viewer:
    • Filter editor behavior was fixed (Enter key processing)
    • Glitch with text edit panel (CLOBs) was fixed
    • Column (row) drag-n-drop in record mode is now supported
  • ERD:
    • Entity render was improved
    • Associations (foreign keys) resolution was fixed
  • PostgreSQL:
    • Active database switching was fixed
    • Metadata editor was improved (materialized views tablespace, table extra options)
    • Materialized views refresh tool
    • Explain plan conditions formatting was added
    • Index columns view was improved
  • MariaDB/MySQL:
    • Server time zone selected add in connection edit page (MySQL only)
    • Show view algorithm in metadata viewer
    • Save view was fixed
    • Save Trigger was fixed
    • Permissions grant was fixed for HISTORY privilege (MariaDB)
  • Oracle:
    • Show used/available space for tablespaces
    • View source extraction was fixed (extra semicolon issue)
    • Procedures auto-completion was fixed
  • DB2: sequence creation was fixed
  • SQLite: sequence reading was fixed
  • SAP HANA: procedures and functions were separated
  • Timescale: driver configuration was added
  • GoTo database object dialog: connection health checking was added
  • Row count calculation for custom queries was fixed
  • Metadata editor supports dialog with multiline editor for comments/remarks
  • Output log viewer auto-clear option was added
  • Connection invalidate was fixed (do not show notifications for alive connections)
  • Many minor UI and localization fixes

DBeaver v5.1.1

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.1.1 (17 Jun 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:

  • Results viewer:
    • Filter text can be expanded (for multi-line filter values)
    • Filter editor now supports undo/redo and drag-n-drop
    • Text value editor was fixed (undo/redo commands)
    • Grouping panel UI was fixed (settings save, dark theme, keys navigation)
    • Table ordering is saved between foreign keys navigation
    • Context menu was refactored
  • SQL Editor:
    • Parser performance was improved
    • SQL formatting was improved
    • Support special characters in table names for auto-completion
    • Stored procedures execute was improved
    • Stored procedures names auto-completion was added
  • Driver manager dialog was fixed
  • ERD:
    • Palette is visible by default
    • Notes edit was fixed (+ undo/redo)
  • Table/tree editors UI was fixed for MacOS
  • Ping/keep-alive background jobs visualization was fixed
  • PostgreSQL:
    • Use fully qualified data type names in DDL
    • View default values for procedure parameters
    • Enum/set values editor was fixed
    • Revoke all permissions command was fixed
    • Show template databases
  • MySQL:
    • Event DDL was fixed
    • View DDL was fixed
  • SQL Server: datetime/datetime2 data types handle was fixed
  • HSQLDB: synonyms support was added
  • Data transfer:
    • CSV values escaping was fixed
    • Support export in SQL format for custom SQL queries
    • Finish wizard message can be suppressed
  • Localization was improved

DBeaver v5.1

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.1 (04 Jun 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:
– Results viewer: Groupings panel was added (GROUP BY generator)
– Results viewer: Aggregate panel was renamed to Calc
– Results viewer: links navigation was fixed (references rendering)
– Results viewer: show confirmation if panel data was modified
– Results viewer: improved drag-n-drop support for all controls
– Results viewer: icons were fixed
– Mockdata: template generator was added
– SQL editor: show stored procedures/functions in SQL completion
– SQL formatting was fixed (single line comments)
– XLS export: empty tables export was fixed
– Update site management preference page was added
– Columns visibility/order configuration dialog was improved
– Date/time formatted was fixed (nanoseconds format pattern)
– HANA: functions source code reading
– Clickhouse: array data types support was added
– Oracle: session elapsed time was added
– Oracle: timestamp with timezone handler was fixed (check driver version)
– PostgreSQL: drop sequence query was fixed
– RedShift: driver configuration was fixed
– Many minor UI bugfixes

DBeaver v5.0.6

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.0.6 (27 May 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:
– Support of cells edit for queries with joined tables
– SSH tunnels: test connection button was added
– Results viewer: horizontal scroll with mouse wheel
– Results viewer: extra header tooltips were added
– PostgreSQL: debugger – fix breakpoints support
– PostgreSQL: data types loading performance was greatly increased
– PostgreSQL: search_path updating was fixed
– PostgreSQL: array data type support was improved
– MySQL 8+ support was fixed
– Oracle: jobs scheduling (thanks to Neil Crow)
– Oracle: schema create dialog improvements
– Oracle: error positioning was improved
– Oracle: timestamp with timezone support was added
– Oracle: CASE statements parser was fixed
– SQL Server: triggers reading was fixed
– SQL Server: drop trigger feature was added
– Vertica: table columns editor (data type, nullability)
– Redshift: driver version update
– Cassandra: JSON formatter for all text columns
– ERD: include nullability in attribute type description
– Queries history browser was fixed
– Some keyboard shortcuts were changed (results navigation)
– Some icons were updated
– Spanish localization was added (thanks to Ishibashi Takken)
– Japanese localization was added (thanks to faibistes)
– Misc minor UI bugfixes

DBeaver v5.0.5

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.0.5 (13 May 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:
– PostgreSQL procedures debugger was added in CE
– Search in query history feature was added
– Query manager view was redesigned
– DBUnit data export format support was added (thanks to Henrik Hansen)
– Eclipse Mars (and earlier) support was fixed
– Foreign key values browser was improved (progress visualizing, values ordering)
– Results viewer/editor key bindings activation was fixed
– Results viewer now respects database navigator filters (default column visibility)
– Results viewer shortcuts (fetch page/fetch all) were changed to avoid conflicts with Linux def shortcuts
– XLS data exporter was improved (column comments support)
– SQL formatter was fixed (special characters processing)
– SQL Editor: auto-completion was fixed for Generic driver (including SQL Server and Informix)
– Connect, disconnect and invalidate timeouts were added
– PostgreSQL: view comments and permissions support was added
– PostgreSQL: asynchronous server output reading is now supported
– PostgreSQL: schema create was fixed
– MariaDB: packages support was added, procedures read was fixed
– DB2: table columns create/edit supports was added
– Oracle CASE statement parsing was fixed
– Misc minor UI bug fixes

DBeaver v5.0.4

DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v5.0.4 (29 Apr 2018)

Note:
1) DBeaver now requires Java 8.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management.

DBeaver EE is no longer free. Last known free version is v4.0.5 (http://dbeaver.jkiss.org/files/4.0.5/) or v3.8.5 (http://dbeaver.jkiss.org/files/3.8.5/).

Change Log:
– Different action icons were fixed (results viewer, SQL editor, file operations)
– Results viewer: context menu was redesigned (compacted)
– Results viewer: scrolling shortcuts were changed
– HighDPI support: composite icons rendering was fixed
– Data export: SQL INSERT format support for custom SQL queries
– Mockdata: commands contributions (menu and toolbar) was fixed
– SQL editor: object search now can search inside object names
– SQL editor: auto-indent was fixed (identifier replace issue)
– SQL editor: “to upper case/to lower case” command shortcuts were fixed
– SQL editor: bold font style configuration
– Bookmarks drag-n-drop inserts real object name
– Database objects create: mixed case identifiers support was fixed
– Database aliases support was added (DB2, Oracle)
– Diagram viewer: support aliases drag-n-drop
– Diagram viewer: tables/columns copy action was added, context menu was redesigned
– Table truncate support (for data transfer, mock data generators, etc)
– Oracle: default driver version changed to 12.2
– Oracle: expired passwords change UI
– Oracle: DROP INDEX was fixed
– PostgreSQL: permissions reading was redesigned
– PostgreSQL: table columns permissions view/edit support was added
– PostgreSQL: create function dialog redesign
– PostgreSQL: schema DDL support was added
– PostgreSQL: schema comments edit support was added
– PostgreSQL: tablespace edit support was added
– PostgreSQL: constraint indexes support
– PostgreSQL: default schema change was fixed
– PostgreSQL: trigger attribute view
– MySQL: enum columns parser was fixed
– SQLite: read-only connections support was added
– Firebird: driver version was updated. 2.x driver was removed.
– Firebird: SET TERM command evaluation was fixed
– Vertica: tables, projections and columns comments support was added
– Clickhouse: metadata read fix
– Misc minor UI bugfixes