HeidiSQL

The newest major version of HeidiSQL released in April 2022

3rd party updates:

Update SQLite libraries to v3.38.0
Update VirtualTrees component source to v7.6.1
Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode)
Update libmariadb.dll and plugins to current stable versions

New stuff:

Experimental support for high DPI in default Windows theme/style
Experimental support for Interbase and Firebird connections (issue #1169)
Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (issue #362)
SQL export: add new menu item "Copy mysqldump command line" in "Options"
Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini
Create editor commands for moving line up/down (Alt+Up, Alt+Down, "Edit" menu)
Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285)
New context menu items "Close query tabs to the right", and "Close all query tabs" (issue #710)
New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360)
New grid export format: SQL UPDATEs (issue #125)
New grid export format: Jira Textile (issue #1013)
Empty-tables-confirmation supports disabling foreign key checks (issue #1491)
Support renaming SQLite tables in database tab (#1427)
Editor highlights all occurrences of selected word, similar to Notepad++ (issue #670)

Bugfixes and enhancements:

Loading an sql file does not activate its tab, e.g. when loading
multiple files. Fix crash happening when active tab is not a query tab
in such cases.
Remove closing PHP tag from export as PHP array
Performance enhancement with many opened query tabs
Fix some potential file related exceptions in text file import
Support filenames with accented chars in text file import dialog (issue #1387)
New query tab uses the same memo height as the current tab
Session background color now used on query result tabs, and in query gutter (issue #932)
Fix various style/theme related crashes, for instance when closing the grid export dialog
Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns
Fix missing SET TIME_ZONE.. on export target server (issue #1457)
Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (issue #1417)
Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (issue #1259)
Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See https://www.heidisql.com/forum.php?t=38150
Support UINT columns in SQLite mode (issue #1453)
Update SynEdit's list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series (issue #1437)
Run current query: Prefer query left to the current one, if current one contains no text (issue #603)
SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables
Activate auto-suggest option "Find matches in middle of entered text" by default.
Don't clear variable from --description cli parameter. (#1295)
Quote column names for quick filter, when column name matches an SQL function (#1398)
Session manager: Auto-expand session folder when user filter matches a child session
Fixes for handling virtual columns (#1210)
Add option to turn off tab close by doubleclick/middleclick (#1151)
Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (issue #1539)
NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (issue #202)
Binary values in foreign key pulldown now works with hex code, instead of binary garbage (issue #1540)
Enhanced foreground/background colors for matching brace in dark themes. (issue #887)
Fix EAbort error when copying text from SynMemo without highlighter

Application Details:

Maintainers: About Maintainership