Update docker.io/dbgate/dbgate Docker tag to v6.3.3

No problems automatically updating the Docker image and run the container by Watchtower with dependency update facilitated by Mend's Renovate Bot.

This MR contains the following updates:

Release Notes

v6.3.3

Compare Source

• CHANGED: New administration UI, redesigned administration of users, connections and roles
• ADDED: Encrypting passwords in team-premium edition
• ADDED: Show scale bar on map #​1090
• FIXED: Fixed native backup/restore for MySQL+PostgreSQL over SSH tunnel #​1092
• CHANGED: Column mapping dialog - fixes and improvements for copying from one existing table into another
• ADDED: Search in columns in table editor
• ADDED: Line Wrap for JSON viewer #​768

6.3.2

• ADDED: "Use system theme" switch, use changed system theme without restart #​1084
• ADDED: "Skip SETNAME instruction" option for Redis #​1077
• FIXED: Clickhouse views are now available even for user with limited permissions #​1076
• ADDED: Multiple-token search delimited with comma (=OR) in structure search boxes
• CHANGED: When filtering columns in data browser, data view shows only filtered columns
• ADDED: Advanced settings for diagrams (Premium)
• ADDED: Diagrams - zoom with Ctrl+mouse wheel
• FIXED: Scrollable diagram exports + scroll by mouse drag
• FIXED: Fixed many problems in diagrams when zoom is applied
• FIXED: Correctly end connection process after succesful/unsuccesful connect

6.3.0

• ADDED: Support for libSQL and Turso (Premium)
• ADDED: Native backup and restore database for MySQL and PostgreSQL (Premium)
• REMOVED: DbGate internal dump export for MySQL (replaced with call of mysqldump)
• REMOVED: Import SQL dump with internal DbGate capabilities (replaced by calling of mysql and psql utilities)
• FIXED: Many fixes in stream processing (imoprt/export), especialy for MongoDB
• ADDED: Indicating progress of import/export tasks, better error reporting
• CHANGED: #​1060 - Changed shortcut for AI assistant
• ADDED: /health endpoint with diagnostic info
• FIXED: Linux Appimage crash => A JavaScript error occurred in the main process #​1065 , #​1067

6.2.1

• ADDED: Commit/rollback and autocommit in scripts #​1039
• FIXED: Doesn't import all the records from MongoDB #​1044
• ADDED: Show server name alongside database name in title of the tab group #​1041
• ADDED: Can't open Sqlite through web #​956
• FIXED: Crashed after text input at columns search #​1049
• FIXED: Incorrect autojoin for foreign keys with more columns #​1051
• FIXED: Scroll in XML cell view, XML view respect themes
• REMOVED: armv7l build for Linux (because of problems with glibc compatibility)
• CHANGED: Upgraded to node:22 for docker builds
• CHANGED: Upgraded SQLite engine version

6.2.0

• ADDED: Query AI Assistant (Premium)
• ADDED: Cassandra database support
• ADDED: XML cell data view
• FIXED: Filtering by value in Oracle #​1009
• FIXED: Operand type clash: uniqueidentifier is incompatible with int #​565
• FIXED: UX in administration
• FIXED: Error reporting of broken connections (sometimes it caused infinite loading of data grid)
• ADDED: Azure managed identity support (Team Premium)
• ADDED: Expanded JSON cell view
• CHANGED: Open real executed query, when datagrid shows loading error

6.1.6

• FIXED: Hotfix build process for premium edition

6.1.5

• FIXED: Serious security hotfix (for Docker and NPM, when using LOGIN and PASSWORD environment variables or LOGIN_PASSWORD_xxx)
• no changes for desktop app and for Team premium edition, when using storage DB

6.1.4

• CHANGED: Show Data/Structure button in one place #​1015
• ADDED: Data view coloring (every second row) #​1014
• ADDED: Pin icon for tab in preview mode (#​1013)
• FIXED: Pin icon misplaced #​1007
• ADDED: Set client name when connecting to redis #​1004
• ADDED: Redis loading keys optimalization #​1002
• ADDED: Browse redis keys with preview with keyboard
• FIXED: Cannot expand tables and views returned from search #​1000
• ADDED: Expand all/Collapse all/Expand document commands in MongoDB JSON view #​976
• ADDED: Configurable page size for MongoDB collection #​976
• ADDED: Redis - SSL connection
• ADDED: Redis JSON format for String values #​852

6.1.3

• FIXED: Fulltext search now shows correctly columns and SQL code lines
• ADDED: Configuration of SSH tunnel local host (IPv4 vs IPv6). Should fix majority of SSH tunnel problems
• FIXED: Handled SSH tunnel connection error, now it shows error instead of connecting forever
• ADDED: Support of triggers (SQLite)
• ADDED: Create, drop trigger
• ADDED: Support for MySQL scheduled events
• FIXED: Cannot connect to DB using askUser/askPassword mode #​995
• FIXED: Filtering in Oracle #​992
• ADDED: Open table in raw mode #​991, #​962
• ADDED: Introduced E2E Cypress tests, test refactor

6.1.1

• ADDED: Trigger support (SQL Server, PostgreSQL, MySQL, Oracle)
• FIXED: PostgreSQL and Oracle export #​970
• FIXED: Cursor Becomes Stuck When Escaping "Case" #​954
• CHANGED: Defualt search criteria for tables are names only
• FIXED: Search in packed list

6.1.0

• ADDED: Fulltext search in DB model and connections, highlight searched names
• ADDED: Tab preview mode configuration #​963
• CHANGED: Single-click to open server connection/database + ability to configure this #​959
• ADDED: Option to align numbers to right in data grid #​957
• FIXED: Cursor Becomes Stuck When Escaping "Case" #​954
• ADDED: Postgres GEOGRAPHY types are shown on map, event when executing query #​948
• FIXED: Error displaying CLOB and NCLOB in Oracle
• FIXED: Analysing of foreign keys in Postgres and MS SQL, when the same FKS are used across different schemas
• ADDED: Support of views, procedures, functions to Oracle. Added integration tests for Oracle
• ADDED: Display "No rows" message, quick add new row
• ADDED: Choose default database from list
• ADDED: Default database is automatically selected on connect
• ADDED: Apple-Silicon-only build for Mac #​949
• ADDED: Display comment into tables and column list #​755

6.0.0

• ADDED: Order or filter the indexes for huge tables #​922
• ADDED: Empty string filters
• CHANGED: (Premium) Workflow for new installation (used in Docker and AWS distribution)
• ADDED: Show stored procedure and function parameters (MySQL, PostgreSQL, SQL Server, MariaDB) #​348
• FIXED: Selected database has changed when closing database grouped tab #​983
• ADDED: Add line break option to editor #​823
• ADDED: Order or filter the indexes for huge tables #​922
• ADDED: Preview mode for the top bar tab like vscode #​767
• ADDED: Keyboard navigatioon between connections, databases and tables
• FIXED: Fixed some issues in connection search
• FIXED: Schema selection in Export does not provide all schemas #​924
• CHANGED: Standardized Window menu in MacOS app
• FIXED: Typecast ::date is treated as a parameter #​925
• FIXED: App crashes when trying to 'Open Structure' in a readonly connection #​926
• FIXED: Selected database has changed when closing database grouped tab #​938
• CHANGED: (Premium) Query designer and Query perspective designer moved to Premium editioin
• CHANGED: (Premium) Compare database tool - many improvements, moved to Premium edition
• ADDED: (Premium) Export DB model - exporting model to YAML folder, JSON or SQL folder
• CHANGED: Model deployer - many improvements, support of rename missing objects
• ADDED: (Premium) Premium NPM distribution
• CHANGED: (Premium) Amazon Redshift driver moved to Premium edition
• ADDED: Generated API documentation https://dbgate.org/docs/apidoc.html
• ADDED: NPM distribution now supports all dbgate database connectors, many improvements NPM packages
• CHANGED: Optimalized size of NPM plugins (eg. dbgate-plugin-mssql from 1.34 MB to 71 kB)
• CHANGED: Unsaved connections are now shown in "Recent and unsaved" folder after disconnect
• FIXED: Correctly show focused control, as defined by UX standards
• ADDED: Data duplicator - weak references
• ADDED: View JSON detail of log messages from export/import jobs and query executions
• ADDED: Rename procedure/function context menu
• ADDED: Show SQL quick view

5.5.6

• FIXED: DbGate process consumes 100% after UI closed - Mac, Linux (#​917, #​915)
• FIXED: Correctly closing connection behind SSH tunnel (#​920)
• FIXED: Updating MongoDB documents on MongoDB 4 (#​916)
• FIXED: (Premium) DbGate container correctly waits for underlying storage database, if database container is started after dbgate container is started
• FIXED: (Premium) Better handling of connection storage errors

5.5.5

• ADDED: AWS IAM authentication for MySQL, MariaDB, PostgreSQL (Premium)
• FIXED: Datitme filtering #​912
• FIXED: Load redis keys
• ADDED: Query parameters #​913
• FIXED: Data grid with hidden columns #​911
• ADDED: Added buttons for one-click authentification methods (Anonymous, OAuth) (Team Premium)
• ADDED: Link for switching Admin/user login (Team Premium)
• FIXED: Save connection params in administration for MS SQL and Postgres storages (Team Premium)

5.5.4

• FIXED: correct handling when use LOGIN and PASSWORD env variables #​903
• FIXED: fixed problems in dbmodel commandline tool
• ADDED: dbmodel - allow connection defined in environment variables
• FIXED: Load postgres schema on Azure #​906
• FIXED: Oauth2 in combination with Google doesn't log payload #​727
• CHANGED: Improved error reporting for unhandler errors
• CHANGED: Don't restart docker container in case of unhandler error
• FIXED: Crash when displaying specific data values from MongoDB #​908
• ADDED: (Premium) Show purchase button after trial license is expired

5.5.3

• FIXED: Separate schema mode #​894 - for databases with many schemas
• FIXED: Sort by UUID column in POstgreSQL #​895
• ADDED: Load pg_dump outputs #​893
• ADDED: Improved column mapping in import/export #​330
• FIXED: Fixed some errors in create-table workflow
• CHANGED: Show single schema by default only if all objects are from default schema
• FIXED: MS Entra authentication for Azure SQL

5.5.2

• FIXED: MySQL, PostgreSQL readonly conections #​900

5.5.1

• ADDED: Clickhouse support (#​532)
• ADDED: MySQL - specify table engine, show table engine in table list
• FIXED: Hidden primary key name in PK editor for DB engines with anonymous PK (MySQL)
• CHANGED: Import/export dialog is now tacub instead of modal
• ADDED: Saving import/export job
• REMOVED: Ability to reopen export/import wizard from generated script. This was a bit hack, now you could save import/export job instead
• ADDED: Autodetect CSV delimited
• FIXED: Import CSV files with spaces around quotes
• ADDED: JSON file import
• ADDED: JSON export can export objects with ID field used as object key
• ADDED: JSON and JSON lines imports supports importing from web URL
• FIXED: Editing imported URL in job editor
• ADDED: Quick export from table data grid (#​892)
• CHANGED: Create table workflow is reworked, you can specify schema and table name in table editor
• FIXED: After saving new table, table editor is reset to empty state
• ADDED: (PostgreSQL, SQL Server) - ability to filter objects by schema
• ADDED: (PostgreSQL, SQL Server) - Use separate schemas option - for databases with lot of schemas, only selected schema is loaded
• FIXED: Internal refactor of drivers, client objects are not more messed up with auxiliary fields
• ADDED: Copy connection error to clipboard after clicking on error icon
• FIXED: (MySQL) Fixed importing SQL dump exported from mysqldump (#​702)
• FIXED: (PostgreSQL) Fixed filtering JSONB fields (#​889)
• FIXED: OIDC authentication not working anymore (#​891)
• ADDED: Added tests for import from CSV and JSON
• FIXED: multiple shortcuts handling #​898
• ADDED: (Premium) MS Entra authentization for Azure SQL databases

5.4.4

• CHANGED: Improved autoupdate, notification is now in app
• CHANGED: Default behaviour of autoupdate, new version is downloaded after click of "Download" button
• ADDED: Ability to configure autoupdate (check only, check+download, don't check)
• ADDED: Option to run check for new version manually
• FIXED: Fixed autoupgrade channel for premium edition
• FIXED: Fixes following issues: #​886, #​865, #​782, #​375

5.4.2

• FIXED: DbGate now works correctly with Oracle 10g
• FIXED: Fixed update channel for premium edition

5.4.1

• FIXED: Broken older plugins #​881
• ADDED: Premium edition - "Start trial" button

5.4.0

• ADDED: Support for CosmosDB (Premium only)
• ADDED: Administration UI (Premium only)
• ADDED: New application icon
• ADDED: MongoDB type support in data editing
• ADDED: MongoDB - posibility to remove field
• ADDED: Oracle - posibility to connect via SID
• FIXED: Many improvements in MongoDB filtering
• FIXED: Switch to form and back to table rows missing #​343
• ADDED: Posibility to deactivate MongoDB Profiler #​745
• ADDED: Ability to use Oracle thick driver - neccessary for connecting older Oracle servers #​843
• FIXED: Connection permissions configuration is broken #​860
• ADDED: ssh key file authentication option missing #​876
• ADDED: Ability to reset layout #​878
• FIXED: Script with escaped backslash causes erro #​880

5.3.4

• FIXED: On blank system does not start (window does not appear) #​862
• FIXED: Missing Execute, Export bar #​861

5.3.3

• FIXED: The application Window is not visible when openning after changing monitor configuration. #​856
• FIXED: Multi column filter is broken for Postgresql #​855
• ADDED: Do not display internal timescaledb objects in postgres databases #​839
• FIXED: When in splitview mode and Clicking "Refresh" button on the right side, will refresh the left side, and not the right side #​810
• FIXED: Cannot filter by uuid field in psql #​538

5.3.1

• FIXED: Column sorting on query tab not working #​819
• FIXED: Postgres Connection stays in "Loading database structure" until reloading the page #​826
• FIXED: Cannot read properties of undefined (reading 'length') on Tables #​824
• FIXED: Redshift doesn't show tables when connected #​816

5.3.0

• CHANGED: New Oracle driver, much better Oracle support. Works now also in docker distribution
• FIXED: Connection to oracle with service name #​809
• ADDED: Connect to redis using a custom username #​807
• FIXED: Unable to open SQL files #​797
• FIXED: MongoDB query without columns #​811
• ADDED: Switch connection for opened file #​814

5.2.9

• FIXED: PostgresSQL doesn't show tables when connected #​793 #​805
• FIXED: MongoDB write operations fail #​798 #​802
• FIXED: Elecrron app logging losed most of log messages
• FIXED: Connection error with SSH tunnel
• ADDED: option to disable autoupgrades (with --disable-auto-upgrade)
• ADDED: Send error context to github gist

5.2.8

• FIXED: file menu save and save as not working
• FIXED: query editor on import/export screen overlaps with selector
• FIXED: Fixed inconsistencies in max/unmaximize window buttons
• FIXED: shortcut for select all
• FIXED: download with auth header
• CHANGED: Upgraded database drivers for mysql, postgres, sqlite, mssql, mongo, redis
• CHANGED: Upgraded electron version (now using v30)
• ADDED: Vim keyboard bindings for editor
• FIXED: Correctly select the save folder for dump
• ADDED: enum + set for mysql (#​693)
• FIXED: localStorageGabageCollector not working
• FIXED: Encoding error when opening Unicode query files
• ADDED: Add copy/paste to query tab and database list
• ADDED: Add copy name to table list
• FIXED: Make TabControl scrollable (#​730)
• ADDED: Add copy to column list
• FIXED: Problems with SQLite + glibc in docker containers
• ADDED: Button for discard/reset changes (#​759)
• FIXED: Don't show error dialog when subprocess fails, as DbGate handles this correctly (#​751, #​746, #​542, #​272)

5.2.7

• FIXED: fix body overflow when context menu height great than viewport #​592
• FIXED: Pass signals in entrypoint.sh #​596
• FIXED: Remove missing links to jenasoft #​625
• FIXED: add API headers on upload call #​627
• FIXED: Disabled shell scripting for NPM distribution by default
• FIXED: Fixed data import from files #​633
• FIXED: Fixed showing GPS positions #​575
• CHANGED: Improved stability of electron client on Windows and Mac (fewer EPIPE errors)

5.2.6

• FIXED: DbGate creates a lot of .tmp.node files in the temp directory #​561
• FIXED: Typo in datetimeoffset dataType #​556
• FIXED: SQL export is using the wrong hour formatting #​537
• FIXED: Missing toolstrip and adds up to 200% zoom to diagram view #​524
• FIXED: MongoDB password could contain special characters #​560

5.2.5

• ADDED: Split Windows #​394
• FIXED: Postgres index asc/desc #​514
• FIXED: Excel export not working since 5.2.3 #​511
• ADDED: Include macOS specific app icon #​494
• FIXED: Resizing window resets window contents #​479
• FIXED: Solved some minor problems with widget collapsing

5.2.4

• FIXED: npm version crash (#​508)

5.2.3

• ADDED: Search entire table (multi column filter) #​491
• ADDED: OracleDB - connection to toher than default ports #​496
• CHANGED: OracleDB - status of support set to experimental
• FIXED: OracleDB database URL - fixes: Connect to default Oracle database #​489
• ADDED: HTML, XML code highlighting for Edit cell value #​485
• FIXED: Intellisense - incorrect alias after ORDER BY clause #​484
• FIXED: Typo in SQL-Generator #​481
• ADDED: Data duplicator #​480
• FIXED: MongoDB - support for views #​476
• FIXED: "SQL:CREATE TABLE" generated SQL default value syntax errors #​455
• FIXED: Crash when right-clicking on tables #​452
• FIXED: View sort #​436
• ADDED: Arm64 version for Windows #​473
• ADDED: Sortable query results and data archive
• CHANGED: Use transactions for saving table data
• CHANGED: Save table structure uses transactions
• ADDED: Table data editing - shows editing mark
• ADDED: Editing data archive files
• FIXED: Delete cascade options when using more than 2 tables
• ADDED: Save to current archive commands
• ADDED: Current archive mark is on status bar
• FIXED: Changed package used for parsing JSONL files when browsing - fixes backend freezing
• FIXED: SSL option for mongodb #​504
• REMOVED: Data sheet editor
• FIXED: Creating SQLite autoincrement column
• FIXED: Better error reporting from exports/import/dulicator
• CHANGED: Optimalizede OracleDB analysing algorithm
• ADDED: Multi column filter for perspectives
• FIXED: Fixed some scenarios using tables from different DBs
• FIXED: Sessions with long-running queries are not killed

5.2.2

• FIXED: Optimalized load DB structure for PostgreSQL #​451
• ADDED: Auto-closing query connections after configurable (15 minutes default) no-activity interval #​468
• ADDED: Set application-name connection parameter (for PostgreSQL and MS SQL) for easier identifying of DbGate connections
• ADDED: Filters supports binary IDs #​467
• FIXED: Ctrl+Tab works (switching tabs) #​457
• FIXED: Format code supports non-standard letters #​450
• ADDED: New logging system, log to file, ability to reduce logging #​360 (using https://www.npmjs.com/package/pinomin)
• FIXED: crash on Windows and Mac after system goes in suspend mode #​458
• ADDED: dbmodel standalone NPM package (https://www.npmjs.com/package/dbmodel) - deploy database via commandline tool

5.2.1

• FIXED: client_id param in OAuth
• ADDED: OAuth scope parameter
• FIXED: login page - password was not sent, when submitting by pressing ENTER
• FIXED: Used permissions fix
• FIXED: Export modal - fixed crash when selecting different database

5.2.0

• ADDED: Oracle database support #​380
• ADDED: OAuth authentification #​407
• ADDED: Active directory (Windows) authentification #​261
• ADDED: Ask database credentials when login to DB
• ADDED: Login form instead of simple authorization (simple auth is possible with special configuration)
• FIXED: MongoDB - connection uri regression
• ADDED: MongoDB server summary tab
• FIXED: Broken versioned tables in MariaDB #​433
• CHANGED: Improved editor margin #​422
• ADDED: Implemented camel case search in all search boxes
• ADDED: MonhoDB filter empty array, not empty array
• ADDED: Maximize button reflects window state
• ADDED: MongoDB - database profiler
• CHANGED: Short JSON values are shown directly in grid
• FIXED: Fixed filtering nested fields in NDJSON viewer
• CHANGED: Improved fuzzy search after Ctrl+P #​246
• ADDED: MongoDB: Create collection backup
• ADDED: Single database mode
• ADDED: Perspective designer supports joins from MongoDB nested documents and arrays
• FIXED: Perspective designer joins on MongoDB ObjectId fields
• ADDED: Filtering columns in designer (query designer, diagram designer, perspective designer)
• FIXED: Clone MongoDB rows without _id attribute #​404
• CHANGED: Improved cell view with GPS latitude, longitude fields
• ADDED: SQL: ALTER VIEW and SQL:ALTER PROCEDURE scripts
• ADDED: Ctrl+F5 refreshes data grid also with database structure #​428
• ADDED: Perspective display modes: text, force text #​439
• FIXED: Fixed file filters #​445
• ADDED: Rename, remove connection folder, memoize opened state after app restart #​425
• FIXED: Show SQLServer alter store procedure #​435

5.1.6

• ADDED: Connection folders support #​274
• ADDED: Keyboard shortcut to hide result window and show/hide the side toolbar #​406
• ADDED: Ability to show/hide query results #​406
• FIXED: Double click does not maximize window on MacOS #​416
• FIXED: Some perspective rendering errors
• FIXED: Connection to MongoDB via database URL info SSH tunnel is used
• CHANGED: Updated windows code signing certificate
• ADDED: Query session cleanup (kill query sessions, if browser tab is closed)
• CHANGED: More strict timeouts to kill database and server connections (reduces resource consumption)

5.1.5

• ADDED: Support perspectives for MongoDB - MongoDB query designer
• ADDED: Show JSON content directly in the overview #​395
• CHANGED: OSX Command H shortcut for hiding window #​390
• ADDED: Uppercase Autocomplete Suggestions #​389
• FIXED: Record view left/right arrows cause start record number to be treated as string #​388
• FIXED: MongoDb ObjectId behaviour not consistent in nested objects #​387
• FIXED: demo.dbgate.org - beta version crash 5.1.5-beta.3 #​386
• ADDED: connect via socket - configurable via environment variables #​358

5.1.4

• ADDED: Drop database commands #​384
• ADDED: Customizable Redis key separator #​379
• ADDED: ARM support for docker images
• ADDED: Version tags for docker images
• ADDED: Better SQL command splitting and highlighting
• ADDED: Unsaved marker for SQL files

5.1.3

• ADDED: Editing multiline cell values #​378 #​371 #​359
• ADDED: Truncate table #​333
• ADDED: Perspectives - show row count
• ADDED: Query - error markers in gutter area
• ADDED: Query - ability to execute query elements from gutter
• FIXED: Correct error line numbers returned from queries

5.1.2

• FIXED: MongoDb any export function does not work. #​373
• ADDED: Query Designer short order more flexibility #​372
• ADDED: Form View move between records #​370
• ADDED: Custom SQL conditions in query designer and table filtering #​369
• ADDED: Query Designer filter eq to X or IS NULL #​368
• FIXED: Query designer, open a saved query lost sort order #​363
• ADDED: Query designer reorder columns #​362
• ADDED: connect via socket #​358
• FIXED: Show affected rows after UPDATE/DELETE/INSERT #​361
• ADDED: Perspective cell formatters - JSON, image
• ADDED: Perspectives - cells without joined data are gray

5.1.1

• ADDED: Perspective designer
• FIXED: NULL,NOT NULL filter datatime columns #​356
• FIXED: Recognize computed columns on SQL server #​354
• ADDED: Hotkey for clear filter #​352
• FIXED: Change column type on Postgres #​350
• ADDED: Ability to open qdesign file #​349
• ADDED: Custom editor font size #​345
• ADDED: Ability to open perspective files

5.1.0

• ADDED: Perspectives (docs: https://dbgate.org/docs/perspectives.html )
• CHANGED: Upgraded SQLite engine version (driver better-sqlite3: 7.6.2)
• CHANGED: Upgraded ElectronJS version (from version 13 to version 17)
• CHANGED: Upgraded all dependencies with current available minor version updates
• CHANGED: By default, connect on click #​332˝
• CHANGED: Improved keyboard navigation, when editing table data #​331
• ADDED: Option to skip Save changes dialog #​329
• FIXED: Unsigned column doesn't work correctly. #​324
• FIXED: Connect to MS SQL with domain user now works also under Linux and Mac #​305

5.0.9

• FIXED: Fixed problem with SSE events on web version
• ADDED: Added menu command "New query designer"
• ADDED: Added menu command "New ER diagram"

5.0.8

• ADDED: SQL Server - support using domain logins under Linux and Mac #​305
• ADDED: Permissions for connections #​318
• ADDED: Ability to change editor front #​308
• ADDED: Custom expression in query designer #​306
• ADDED: OR conditions in query designer #​321
• ADDED: Ability to configure settings view environment variables #​304

5.0.7

• FIXED: Fixed some problems with SSH tunnel (upgraded SSH client) #​315
• FIXED: Fixed MognoDB executing find query #​312
• ADDED: Interval filters for date/time columns #​311
• ADDED: Ability to clone rows #​309
• ADDED: connecting option Trust server certificate for SQL Server #​305
• ADDED: Autorefresh, reload table every x second #​303
• FIXED(app): Changing editor theme and font size in Editor Themes #​300

5.0.6

• ADDED: Search in columns
• CHANGED: Upgraded mongodb driver
• ADDED: Ability to reset view, when data load fails
• FIXED: Filtering works for complex types (geography, xml under MSSQL)
• FIXED: Fixed some NPM package problems

5.0.5

• ADDED: Visualisation geographics objects on map #​288
• ADDED: Support for native SQL as default value inside yaml files #​296
• FIXED: Postgres boolean columns don't filter correctly #​298
• FIXED: Importing dbgate-api as NPM package now works correctly
• FIXED: Handle error when reading deleted archive

5.0.3

• CHANGED: Optimalization of loading DB structure for PostgreSQL, MySQL #​273
• CHANGED: Upgraded mysql driver #​293
• CHANGED: Better UX when defining SSH port #​291
• ADDED: Database object menu from tab
• CHANGED: Ability to close file uploader
• FIXED: Correct handling of NUL values in update keys
• CHANGED: Upgraded MS SQL tedious driver
• ADDED: Change order of pinned tables & databases #​227
• FIXED: #​294 Statusbar doesn't match active tab
• CHANGED: Improved connection worklflow, disconnecting shws confirmations, when it leads to close any tabs
• ADDED: Configurable object actions #​255
• ADDED: Multiple sort criteria #​235
• ADDED(app): Open JSON file

5.0.2

• FIXED: Cannot use SSH Tunnel after update #​291

5.0.1

• FIXED(app): Can't Click Sidebar Menu Item #​287

5.0.0

• CHANGED: Connection workflow, connections are opened on tabs instead of modals
• ADDED: Posibility to connect to DB without saving connection
• ADDED(mac): Support for SQLite on Mac M1
• FIXED(mac): Unable to drag window on MacOS #​281 #​283
• CHANGED: Renamed dbgate-data directory to .dbgate #​248
• FIXED: Exported SQL has table name undefined #​277
• ADDED: More data types in table create dialogt #​285
• ADDED(app): Open previously saved ERD diagrams #​278
• CHANGED: Better app loading progress UX
• FIXED: Removed SSL tab on Redis connection (SSL is not supported for Redis)

4.8.8

• CHANGED: New app icon
• ADDED: SQL dump, SQL import - also from/to saved queries
• FIXED(mac): Fixed crash when reopening main window
• FIXED: MySQL dump now handles correctly dependand views
• FIXED(app): Browse tabs with Ctrl+Tab
• ADDED(app): Browse tabs in reverse order with Ctrl+Shift+Tab #​245

4.8.7

• ADDED: MySQL dump/backup database
• ADDED: Import SQL dump from file or from URL
• FIXED(mac): Fixed Cmd+C, Cmd+V, Cmd+X - shortcuts for copy/cut/paste #​270
• FIXED(mac): Some minor issues on macOS
• FIXED: Analysing MS SQL nvarchar(max)
• ADDED: Support for dockerhost network name under docker #​271

4.8.4

• FIXED(mac): Fixed build for macOS arm64 #​259
• FIXED(mac): Fixed opening SQLite files on macOS #​243
• FIXED(mac): Fixed opening PEM certificates on macOS #​206
• FIXED(mac): Fixed handling Command key on macOS
• FIXED(mac): Fixed system menu on macOS
• FIXED(mac): Fixed reopening main window on macOS
• CHANGED: Shortcut for net query is now Ctrl+T or Command+T on macOS, former it was Ctrl+Q
• FIXED: Fixed misplaced tab close icon #​260
• ADDED: Added menu command "Tools/Change to recent database"

4.8.3

• FIXED: filters in query result and NDJSON/archive viewer
• ADDED: Added select values from query result and NDJSON/archive viewer
• ADDED: tab navigation in datagrid #​254
• ADDED: Keyboard shortcuts added to help menu #​254
• ADDED: API logging (run enableApiLog() in developers console to enable logging)
• ADDED: SSH reconnect + moved SSH forward into separate fork #​253
• ADDED: Data type + reference link in column manager
• FIXED(win,linux,mac): Unable to change theme after installing plugin #​244

4.8.2

• ADDED: implemented missing redis search key logic

4.8.1

• FIXED: fixed crash after disconnecting from all DBs

4.8.0

• ADDED: Redis support (support stream type), removed experimental status
• ADDED: Redis readonly support
• ADDED: Explicit NDJSON support, when opening NDJSON/JSON lines file, table data are immediately shown, without neccesarity to import
• ADDED(win,linux,mac): Opening developer tools when crashing without reload app

4.7.4

• ADDED: Experimental Redis support (full support is planned to version 4.8.0)
• ADDED: Read-only connections
• FIXED: MongoDB filters
• ADDED: MongoDB column value selection
• ADDED: App related queries
• ADDED: Fuzzy search #​246
• ADDED(docker, npm): New permissions
• FIXED(npm): NPM build no longer allocates additonal ports
• CHANGED(npm): renamed NPM package dbgate => dbgate-serve
• CHANGED(docker): custom JavaScripts and connections defined in scripts are now prohibited by default, use SHELL_CONNECTION and SHELL_SCRIPTING environment variables for allowing this
• ADDED(docker, npm): Better documentation of environment variables configuration, https://dbgate.org/docs/env-variables.html
• ADDED(docker): support for multiple users with different permissions
• ADDED(docker): logout operation

4.7.3

• CHANGED: Export menu redesign, quick export menu merged with old export menu
• REMOVED: Quick export menu
• ADDED: Export column mapping
• ADDED: Export invoked from data grid respects columns choosed in column manager
• ADDED: Quick export (now merged in export menu) is now possible also in web app
• FIXED: Virtual foreign key editor fixes
• FIXED: Tabs panel style fix
• ADDED: Find by schema in databases widget
• FIXED: Column manager selection fix
• FIXED: NPM dist - fixed error when loading plugins
• CHANGED: NPN dist is now executed by dbgate-serve command
• ADDED: NPM dist accepts .env configuration

4.7.2

• CHANGED: documentation URL - https://dbgate.org/docs/
• CHANGED: Close button available for all tab groups - #​238
• ADDED: Search function for the Keyboard Shortcuts overview - #​239
• ADDED: Editor font size settings - #​229
• ADDED: Rename MongoDB collection - #​223
• FIXED: bug in cache subsystem

4.7.1

• FIXED: Fixed connecting to MS SQL server running in docker container from DbGate running in docker container #​236
• FIXED: Fixed export MongoDB collections into Excel and CSV #​240
• ADDED: Added support for docker volumes to persiste connections, when not using configuration via env variables #​232
• ADDED: DbGate in Docker can run in subdirectory #​228
• FIXED: DbGate in Docker can be proxied with nginx #​228
• FIDED: Theme persists when opening multiple windows #​207
• ADDED: Remember fullscreen state #​230
• ADDED: Improved fullscreen state, title bar with menu is hidden, menu is in hamburger menu, like in web version
• ADDED: Theme choose dialog (added as tab in settings)
• FIXED: Fixed crash when clicking on application layers #​231

4.7.0

• CHANGED: Changed main menu style, menu and title bar is in one line (+ability to switch to system menu)
• REMOVED: Removed main toolbar, use main menu or tab related bottom tool instead
• ADDED: Added tab related context bottom toolbar
• ADDED: Main menu is available also in web application, by clicking on hamburger menu
• ADDED: Added support of SQLite to docker container #​219
• ADDED: Added Debian and Alpine docker distributions (default is Debian)
• FIXED: Fixed performance problem of data grid, especially when there are cells with large data (eg. JSONs), now it is much faster
• ADDED: Open JSON and array cell buttons
• ADDED: Handle JSON in varchar cells
• ADDED: Scroll tabs on mouse wheel
• ADDED: Show edit edit MySQL column comments #​218 #​81
• ADDED: Handle sparse (mssql), unsigned (mysql), zerofill (mysql) column flags
• FIXED: Fixed same caching problems (eg. leading to indefinitely loading DB structure sometimes)
• ADDED: Show estimated table row count for MySQL and MS SQL
• FIXED: Fixed deleting rows from added rows in table data editor
• ADDED: Better work with JSON lines file, added JSONL editor with preview

4.6.3

• FIXED: Fixed Windows build
• FIXED: Fixed crash, when there is invalid value in browser local storage
• FIXED: Fixed plugin description display, where author name or description is not correctly filled

4.6.2

• FIXED: Fixed issues of XML import plugin
• ADDED: Split columns macro (available in data sheet editor)
• CHANGED: Accepting non standard plugins names (which doesn't start with dbgate-plugin-)
• ADDED: Support BLOB values #​211
• ADDED: Picture cell view
• ADDED: HTML cell view
• CHANGED: Code completion supports non-default schema names
• FIXED: More robust MySQL analyser, when connecting to non-standard servers #​214
• FIXED: Fixed configuring connection to SQLite with environment variables #​215

4.6.1

• ADDED: Ability to configure SSH tunnel over environment variables #​210 (for docker container)
• ADDED: XML export and import
• ADDED: Archive file - show and edit source text file
• ADDED: Window title shows current tab and database
• ADDED: DbGate documentation
• ADDED: Introduced application layers
• ADDED: Virtual foreign key editor
• ADDED: Application commands (SQL scripts related to database)
• ADDED: Theme can be implemented in plugin
• CHANGED: Dictionary description is stored in app
• FIXED: Unique and index editor
• FIXED: Posibility to edit UNIQUE index flag
• CHANGED: UX improvements of table editor

4.6.0

• ADDED: ER diagrams #​118
  • Generate diagram from table or for database
  • Automatic layout
  • Diagram styles - colors, select columns to display, optional displaying data type or nullability
  • Export diagram to HTML file
• FIXED: Mac latest build link #​204

4.5.1

• FIXED: MongoId detection
• FIXED: #​203 disabled spellchecker
• FIXED: Prevented display filters in form view twice
• FIXED: Query designer fixes

4.5.0

• ADDED: #​220 functions, materialized views and stored procedures in code completion
• ADDED: Query result in statusbar
• ADDED: Highlight and execute current query
• CHANGED: Code completion offers objects only from current query
• CHANGED: Big optimalizations of electron app - removed embedded web server, removed remote module, updated electron to version 13
• CHANGED: Removed dependency to electron-store module
• FIXED: #​201 fixed database URL definition, when running from Docvker container
• FIXED: #​192 Docker container stops in 1 second, ability to stop container with Ctrl+C
• CHANGED: Web app - websocket replaced with SSE technology
• CHANGED: Changed tab order, tabs are ordered by creation time
• ADDED: Reorder tabs with drag & drop
• CHANGED: Collapse left column in datagrid - removed from settings, remember last used state
• ADDED: Ability to select multiple columns in column manager in datagrid + copy column names
• ADDED: Show used filters in left datagrid column
• FIXED: Fixed delete dependency cycle detection (delete didn't work for some tables)

4.4.4

• FIXED: Database colors
• CHANGED: Precise work with MongoDB ObjectId
• FIXED: Run macro works on MongoDB collection data editor
• ADDED: Type conversion macros
• CHANGED: Improved UX of import into current database or current archive
• ADDED: Posibility to create string MongoDB IDs when importing into MongoDB collections
• CHANGED: Better crash recovery
• FIXED: Context menu of data editor when using views - some commands didn't work for views
• ADDED: Widget lists (on left side) now supports add operation, where it has sense
• CHANGED: Improved UX of saved data sheets
• ADDED: deploy - preloadedRows: impelemnted onsertOnly columns
• ADDED: Show change log after app upgrade

4.4.3

• ADDED: Connection and database colors
• ADDED: Ability to pin connection or table
• ADDED: MongoDb: create, drop collection from menu
• ADDED: Copy as MongoDB insert
• ADDED: MongoDB support for multiple statements in script (dbgate-query-splitter)
• ADDED: View JSON in tab
• ADDED: Open DB model as JSON
• ADDED: Open JSON array as data sheet
• ADDED: Open JSON from data grid
• FIXED: Mongo update command when using string IDs resembling Mongo IDs
• CHANGED: Imrpoved add JSON document, change JSON document commands
• ADDED: Possibility to add column to JSON grid view
• FIXED: Hiding columns #​1
• REMOVED: Copy JSON document menu command (please use Copy advanced instead)
• CHANGED: Save widget visibility and size

4.4.2

• ADDED: Open SQL script from SQL confirm
• CHANGED: Better looking statusbar
• ADDED: Create table from database popup menu
• FIXED: Some fixes for DB compare+deploy (eg. #​196)
• ADDED: Archives + DB models from external directories
• ADDED: DB deploy supports preloaded data
• ADDED: Support for Command key on Mac (#​199)

4.4.1

• FIXED: #​188 Fixed problem with datetime values in PostgreSQL and mysql
• ADDED: #​194 Close tabs by DB
• FIXED: Improved form view width calculations
• CHANGED: Form view - highlight matched columns instead of filtering
• ADDED: Lookup distinct values
• ADDED: Copy advanced command, Copy as CSV, JSON, YAML, SQL
• CHANGED: Hide column manager by default
• ADDED: Change database status command
• CHANGED: Table structure and view structure tabs have different icons
• ADDED: #​186 - zoom setting
• ADDED: Row count information moved into status bar, when only one grid on tab is used (typical case)

4.4.0

• ADDED: Database structure compare, export report to HTML
• ADDED: Experimental: Deploy DB structure changes between databases
• ADDED: Lookup dialog, available in table view on columns with foreign key
• ADDED: Customize foreign key lookups
• ADDED: Chart improvements, export charts as HTML page
• ADDED: Experimental: work with DB model, deploy model, compare model with real DB
• ADDED: #​193 new SQLite db command
• CHANGED: #​190 code completion improvements
• ADDED: #​189 Copy JSON document - context menu command in data grid for MongoDB
• ADDED: #​191 Connection to POstgreSQL can be defined also with connection string
• ADDED: #​187 dbgate-query-splitter: Transform stream support
• CHANGED: Upgraded to node 12 in docker app
• FIXED: Upgraded to node 12 in docker app
• FIXED: Fixed import into SQLite and PostgreSQL databases, added integration test for this

4.3.4

• FIXED: Delete row with binary ID in MySQL (#​182)
• ADDED: Using 'ODBC Driver 17 for SQL Server' or 'SQL Server Native Client 11.0', when connecting to MS SQL using windows auth #​183

4.3.3

• ADDED: Generate SQL from data (#​176 - Copy row as INSERT/UPDATE statement)
• ADDED: Datagrid keyboard column operations (Ctrl+F - find column, Ctrl+H - hide column) #​180
• FIXED: Make window remember that it was maximized
• FIXED: Fixed lost focus after copy to clipboard and after inserting SQL join

4.3.2

• FIXED: Sorted database list in PostgreSQL (#​178)
• FIXED: Loading stricture of PostgreSQL database, when it contains indexes on expressions (#​175)
• ADDED: Hotkey Shift+Alt+F for formatting SQL code

4.3.1

• FIXED: #​173 Using key phrase for SSH key file connection
• ADDED: #​172 Abiloity to quick search within database names
• ADDED: Database search added to command palette (Ctrl+P)
• FIXED: #​171 fixed PostgreSQL analyser for older versions than 9.3 (matviews don't exist)
• ADDED: DELETE cascade option - ability to delete all referenced rows, when deleting rows

4.3.0

• ADDED: Table structure editor
• ADDED: Index support
• ADDED: Unique constraint support
• ADDED: Context menu for drop/rename table/columns and for drop view/procedure/function
• ADDED: Added support for Windows arm64 platform
• FIXED: Search by _id in MongoDB

4.2.6

• FIXED: Fixed MongoDB import
• ADDED: Configurable thousands separator #​136
• ADDED: Using case insensitive text search in postgres

4.2.5

• FIXED: Fixed crash when using large model on some installations
• FIXED: Postgre SQL CREATE function
• FIXED: Analysing of MySQL when modifyDate is not known

4.2.4

• ADDED: Query history
• ADDED: One-click exports in desktop app
• ADDED: JSON array export
• FIXED: Procedures in PostgreSQL #​122
• ADDED: Support of materialized views for PostgreSQL #​123
• ADDED: Integration tests
• FIXED: Fixes in DB structure analysis in PostgreSQL, SQLite, MySQL
• FIXED: Save data in SQLite, PostgreSQL
• CHANGED: Introduced package dbgate-query-splitter, instead of sql-query-identifier and @​verycrazydog/mysql-parse

4.2.3

• ADDED: ARM builds for MacOS and Linux
• ADDED: Filter by columns in form view

4.2.2

• CHANGED: Further startup optimalization (approx. 2 times quicker start of electron app)

4.2.1

• FIXED: Fixed+optimalized app startup (esp. on Windows)

4.2.0

• ADDED: Support of SQLite database
• ADDED: Support of Amazon Redshift database
• ADDED: Support of CockcroachDB
• CHANGED: DB Model is not auto-refreshed by default, refresh could be invoked from statusbar
• FIXED: Fixed race conditions on startup
• FIXED: Fixed broken style in data grid under strange circumstances
• ADDED: Configure connections with commandline arguments #​108
• CHANGED: Optimalized algorithm of incremental DB model updates
• CHANGED: Loading queries from PostgreSQL doesn't need cursors, using streamed query instead
• ADDED: Disconnect command
• ADDED: Query executed on server has tab marker (formerly it had only "No DB" marker)
• ADDED: Horizontal scroll using shift+mouse wheel #​113
• ADDED: Cosmetic improvements of MariaDB support

4.1.11

• FIX: Fixed crash of API process when using SSH tunnel connection (race condition)

4.1.11

• FIX: fixed processing postgre query containing $$
• FIX: fixed postgre analysing procedures & functions
• FIX: patched svelte crash #​105
• ADDED: ability to disbale background DB model updates
• ADDED: Duplicate connection
• ADDED: Duplicate tab
• FIX: SSH tunnel connection using keyfile auth #​106
• FIX: All tables button fix in export #​109
• CHANGED: Add to favorites moved from toolbar to tab context menu
• CHANGED: Toolbar design - current tab related commands are delimited

4.1.10

• ADDED: Default database option in connectin settings #​96 #​92
• FIX: Bundle size optimalization for Windows #​97
• FIX: Popup menu placement on smaller displays #​94
• ADDED: Browse table data with SQL Server 2008 #​93
• FIX: Prevented malicious origins / DNS rebinding #​91
• ADDED: Handle JSON fields in data editor (eg. jsonb field in Postgres) #​90
• FIX: Fixed crash on Windows with Hyper-V #​86
• ADDED: Show database server version in status bar
• ADDED: Show detailed info about error, when connect to database fails
• ADDED: Portable ZIP distribution for Windows #​84

4.1.9

• FIX: Incorrect row count info in query result #​83

4.1.1

• CHANGED: Default plugins are now part of installation

4.1.0

• ADDED: MongoDB support
• ADDED: Configurable keyboard shortcuts
• ADDED: JSON row cell data view
• FIX: Fixed some problems from migration to Svelte

4.0.3

• FIX: fixes for FireFox (mainly incorrent handle of bind:clientHeight, replaces with resizeobserver)

4.0.2

• FIX: fixed docker and NPM build

4.0.0

• CHANGED: Excahnged React with Svelte. Changed theme colors. Huge speed and memory optimalization
• ADDED: SQL Generator (CREATE, INSERT, DROP)
• ADDED: Command palette (F1). Introduced commands, extended some context menus
• ADDED: New keyboard shortcuts
• ADDED: Switch to recent database feature
• ADDED: Macros from free table editor are available also in table data editor
• CHANGED: Cell data preview is now in left widgets panel
• CHANGED: Toolbar refactor
• FIX: Solved reconnecting expired connection

3.9.6

• ADDED: Connect using SSH Tunnel
• ADDED: Connect using SSL
• ADDED: Database connection dialog redesigned
• ADDED: #​63 Ctrl+Enter runs query
• ADDED: Published dbgate NPM package
• ADDED: SQL editor context menu
• FIX: #​62 - import, export executed from SNAP installs didn't work

3.9.5

• Start point of changelog