Version 6.4.0 - DuckDB support

Published: 2025-04-30

I am happy to announce releasing new major version. This release adds support of popular DuckDB database, ability to import and export connections, data deployer and many smaller improvements and bugfixes.

DuckDB support

DuckDB is a high-performance analytical database system. It is designed to be fast, reliable, portable, and easy to use. DuckDB provides a rich SQL dialect, with support far beyond basic SQL.

DbGate offers rich support of DuckDB - work with table data, run queries, exports and imports. Similarily as for SQLite, you could also directly open .duckdb file.

There is only small number of limitations, because of specific DuckDB design.

Import and export connections

You could export selected connections from your installation DbGate and then import them on different computer. It is even possible to transfer connections between Team-Premium web edition and Premium/Community edition (Team Premium edition uses different storage for connections, they are stored in database).

Data deployer

DbGate historically had tool named “Data Duplicator”. This tool was hugely improved and redesigned, now it is available as Data Deployer. You could use data deployer for visually compareand synchronize data between folders with NDJSON data files and real SQL databases.

This tool could also preserve relations, so it could be used to copy related from one database into another.

You could find more about advanced data tools in documentation

Working with ZIP files

In DbGate, you could export multiple files in one step. New version adds posibility to create ZIP file with exported files. You could also import from ZIP files. You could also save ZIP files as data archives - you could browse them in data archive explorer.

Changed AWS and Azure upgrade strategy

If you use installations on AWS or Azure, in past versions, DbGate aws upgraded automatically. Now, you have to switch-on this autoupgrade, it is disabled by default.

Prefered way is now to use new image on AWS/Azure, and use Export connections/Import Connections feature to preserve settings. This feature could export/import also all users/permission/roles, so it is now safer to use clean installation with imported connections and users.

Full changelog for 6.4.0 version

ADDED: DuckDB support
ADDED: Data deployer (Premium)
ADDED: Compare data between JSON lines file in archive and database table
CHANGED: Data Duplicator => Data Replicator (suitable for update, create and delete data, much more customizable)
REMOVED: Data duplicator GUI (replaced with Data Deployer)
ADDED: Exporting to ZIP file
ADDED: Download SQL and SQLite files
ADDED: Upload SQLite files
ADDED: Upload archive as ZIP folder (Premium)
ADDED: Compress, uncompress archive folder (Premium)
ADDED: Export connections and settings #357
ADDED: Filtering by MongoDB ObjectId works now also without ObjectId(…) wrapper
ADDED: Split queries using blank lines #1089
FIXED: JSON-to-Grid only works if there is no newline #1085
CHANGED: When running multiple commands in script, stop execution after first error #1070
FIXED: Selection rectangle remains visible after closing JSONB edit cell value form #1031
FIXED: Diplaying numeric FK column with right alignement #1021
ADDED: Additional arguments for MySQL and PostgreSQL backup #1092
CHANGED: Amazon and Azure instalations are not auto-upgraded by default

Please feel free to add comment on Twitter / X to this article.