New in Database Workbench 6

The original version 6 release became available in 2021 and development continues to this day. New features and enhancements as well as bug fixes have been added to the product.

Besides improving the application itself, we've also added support for new releases of the supported database systems during this time frame, for example:

  • SQLite, completely new module
  • Firebird 4 and 5
  • MariaDB 10.x and 11.x
  • MySQL 8.x and 9.x
  • Oracle 19, 21 and 23
  • InterBase 2020 and 15
  • PostgreSQL 16, 17 and 18

Major new features in version 6 releases

Improved User Interface

There are many new user interface features in Database Workbench, including:

  • New, more clear and consistent toolbar and object images
  • Many multithreading improvements and faster meta data loading in large databases
  • Fast Object Selection boxes with filters
  • Improved HiDPI support
Database Workbench Enterprise Edition
  • Special edition for development teams
  • Central registered server & database repository in additional to locally stored server and database configuration
  • Central repository with Workspaces and Todo-lists
  • Database VCS system for meta data objects

New in release 6.9

Support for new database system versions

As database systems continue to improve, we're adding support for new releases and features too:

  • InterBase 15
  • SQLite 3.50 and 3.51
  • PostgreSQL 18
  • Support for PostgreSQL range and text search types
Reporting improvements

The reporting system has been improved, new features and enhancements include:

  • Report Designer has a New Report Wizard to quickly create a new basic report
  • Reports now include font and background styles, a set of default styles can be found in the Preferences
  • Quickly create a new project report right from the SQL Editor
  • New properly scaled and clear images in the same style as the rest of the application

Other improvements
  • Text Compare tool now has a new differences outline, this tool is also used for the TeamServer VCS feature
  • Speed improvement in opening DataPump source data with regard to computed columns
  • SQLite library updated to most recent version
  • Several bugfixes...

The full list of changes is available here.

New in release 6.8

Support for new database system releases

As database systems continue to improve, we're adding support for new releases and features too:

  • MySQL 9.2 and 9.3
  • MariaDB 11.7
  • PostgreSQL 17
  • Oracle 23
  • Other PostgreSQL improvements: support for EVENT TRIGGER objects and for non default index access methods.
  • Other MySQL improvements: support for dependencies in MySQL 8 and up and table column comments.

The full list of changes is available here.

New in release 6.7

Small new features and bugfixes

This release focused on small new features like CSV import/export defaults and improvements and drag and drop editing in the Table Editor.

Another new features is PostgreSQL PgVector data support.

The full list of changes is available here.

New in release 6.6

Usability improvements and new database releases

Adding objects to the Workspace is easier now and you can add custom "default" drop down box entries for Table/Procedure/Function and Domain Editors.

This release also adds support for MySQL 9 and MariaDB 11.3 and 11.4.

Other notable changes include Windows ARM64 support, bugfixes to Oracle Direct Mode data fetching and Firebird & InterBase statistics now fetched as int64.

The full list of changes is available here.

New in release 6.5

Usability improvements and new database releases

Several improvements and new features, including:

  • Ability to "paste" images directly into the BLOB Editor
  • Start the Visual Query Builder without having to open any other editors like the SQL Editor
  • New versions of developer fonts included
  • Several import/export improvements
  • Database Migration changes to take differences between systems into account
  • Data Source selection boxes (Data Pump, Data Compare, Database Migration and Database Compare tools) use same folders as Server Manager for extra clarity

This release also adds support for Firebird 5, MySQL 8.3 and PostgreSQL 16.x.

Many bug fixes have been made, you can view the detailed list of changes here.

New in release 6.4

New module for SQLite

This release adds the new SQLite module, as per custom request. The Pro and Enterprise Editions can even open SQLite databases in meta data read only mode without a SQLite module license.

Several other improvements include:

  • Changes to increase speed with a large number of database objects
  • Code Editor improvements when selecting text
  • Exporting multiple items can now use automatic table order

The complete list of changes can be viewed here.

New in release 6.3

SQL Server and MariaDB support improved and several usuability improvements

This release completes support for the latest SQL Server release and the ability to connect without the OLEDB/Native Client. The latest MariaDB versions are supported too.

Several other new features and improvements include:

  • Ability to throttle speed in Data Pump
  • A new "Empty Tables" tool, with optional automatic table order
  • A InterBase or Firebird CHAR(16), OCTETS can be converted to native UUID data type during Database Migration
  • Data grid filter support for InterBase or Firebird CHAR(16), OCTETS columns

The full list of changes is available here.

New in release 6.2

General improvements and new PostgreSQL version support

Support for PostgreSQL version 14 and 15, as well as new support for PostgreSQL function overloading and Stored Functions that return RECORD type.

Several other new features and improvements include:

  • Export binary data to Base64 in CSV export
  • Ability to use Database Workbench on Windows Terminal Server
  • Database Search improvements
  • All Object Editor windows now include a drop down object selector with ability to filter items

The full list of changes is available here.

New in release 6.1

Support for new InterBase and Oracle, and general improvements

This release brings support for InterBase 2020, Oracle 19 and 21 and MariaDB 10.8.

Other improvements include:

  • Support for Firebird User Defined Routines (external functions)
  • Support for InterBase Change View Subscriptions
  • Ability to start Database Workbench Enterprise without a TeamServer connection
  • Added Identity column support for Oracle and PostgreSQL
  • Oracle stored routine debugging improvements
  • Ability to use an (updateable) View as the target in the Data Pump tool

The complete list of changes is available here.

New in release 6

Improved User Interface

There are many new user interface features in Database Workbench.

  • New, more clear and consistent toolbar and object images
  • Many multithreading improvements and faster meta data loading in large databases
  • Fast Object Selection boxes with filters
  • Improved HiDPI support
  • Improved visual feedback and more consistent look and feel
  • Many small changes and features added...
Improved BLOB Editor

Flexible BLOB Viewer/Editor to view documents, images or binary data in the database.

  • Improved auto-detection of content type
  • Additional supported images formats: SGI & PSP
  • Support for PDF documents
  • Support for RTF, DOC and DOCX documents
InterBase & Firebird Query Statistics

Our customers requested a graphical overview of query statistics

  • Easy overview of query statistics
  • Includes filter for different types of operations
  • Text-based statistics also available
New Database Features
  • Firebird 4 support
  • PostgreSQL table inheritance
  • Oracle multi-segment expression indices support
  • InterBase System Encryption Password support
  • Create databases on SQL Server cloud services
  • Graphical query statistics summary for InterBase and Firebird
Database Workbench Enterprise Edition
  • Special edition for development teams
  • Central registered server & database repository in additional to locally stored server and database configuration
  • Central repository with Workspaces and Todo-lists
  • Database VCS system for meta data objects
Even More New Tools and Features!

Based on customer suggestions, we've created new tools and features, including but not limited to:

  • Ability to copy result set rows to Microsoft Excel/OpenOffice Calc
  • Easier Visual Query Builder navigation with query tree-view
  • Visual Query Builder opens up much faster with large number of objects
  • Each page in SQL Editor has its own result set
  • Oracle multi-schema improvements and support for multi-column expression indices
  • Dependency Viewer filters
  • Faster meta data loading
  • Duplicate View now includes triggers and indices
  • Auto-detect BLOB contents in BLOB Editor
  • Improved filter in Database Navigator
  • Quick Filters for data grids
  • Easier SQL Insight filtering