HeidiSQL 12.12 bugfix release

Get it from the download page

The v12.12 Windows release now abandons the 32 bit portable releases and nightly builds. Only 64 bit releases from now on.

Back in Jan 2019, for v10.0, I created the first 64 bit release with the support of the Delphi 10.3 at that time. Since that release I provided both 32 and 64 bit releases for more than 6 years now. Due to the decreasing availability of 32 bit drivers and libraries, and with a user base of ~0.5% it makes sense to safe the effort for these. Note the previous releases with 32 bit variants are still available on the download page.

Also notable: heidisql.com has been moved to Manitu, an excellent hosting provider in Germany. Update checks, SQL formatting and statistic calls should benefit from the enhanced speed.

New stuff:

• Issue #2254: Support for trigger editing on SQLite

3rd party updates:

• Upgrade compiler to Delphi 12.3.
• Update MariaDB Connector/C to v3.4.7
• Add MySQL Connector libmysql v9.0.4
• Update SQLite libraries to v3.50.4
• Update SQLite multiple cipher libraries to v2.2.4.
• Update PostgreSQL libpq/17 to v17.0.6
• Update PostgreSQL libpq/15 to v15.0.14
• Remove PostgreSQL libpq/10 and 12, depending on the outdated and insecure libssl v1.1.1w
• Update Virtual-TreeView component to v8.2 from Sep 5 2025

Bugfixes and enhancements:

• Issue #2161: fix reading and writing user limitations in newer MySQL versions
• Issue #2126: rephrase SQL query for retrieving the oid of citext data type, to prevent errors in the server logs
• Issue #2257: fix height of grid column header
• Issue #2122: support table comment syntax when creating new PostgreSQL tables
• Issue #41: use N(ational) prefix on MS SQL strings on all quoted strings, regardless of their exact data type, to support Unicode in meta queries as well
• Issue #2167: remove fallback to insecure http calls when https failed
• Issue #2250: use N(ational) prefix in MS SQL for any text value going through the second version of EscapeString(), supporting Unicode now when importing a file into a table.
• Fix unsaved highlighter selection of default "General"
• Fix memory leak
• Issue #2249: call FixVT() in FormCreate consequently, so the trees do not change their row height after the second use. Also increase TextMargin and reduce Margin.
• Issue #2243: keep UserKnownHostsFile enabled in ssh.exe mode, so the message saying "permanently added xyz to the list of known hosts" is telling the truth now
• Do not require a "Content-Length" response header in THttpDownload. Responses mostly come compressed with "Transfer-Encoding: chunked" and then need hacks to get a Content-Length header. See https://www.heidisql.com/forum.php?t=44407
• Issue #1313: support MariaDB's COMPRESSED attribute for columns in table editor
• Issue #2243: suppress prompt to save a yet unknown host key in ssh.exe mode, by disabling StrictHostKeyChecking and UserKnownHostsFile . I have no clue to where ssh.exe sends that message, it's neither in stdOut nor in stdErr.
• Issue #2243: fix input being ignored by plink by adding a linefeed after y/n
• Issue #2243: add -legacy-stdio-prompts argument only to plink v0.82 or newer, not on older versions
• Issue #2233: fix detection of column length in SQLite, when the column type contains a space before parenthesis
• Issue #2212: add type prefix to export file name, when exporting one file per object, to fix overwriting same filename for different object types
• Issue #2218: don't disable completion proposal when cursor is right besides a string or comment
• Issue #2205: Remove subpart from column indexes when user changed its data type to non-text
• Issue #2193: expect some more characters to indicate a boundary for an identifier: ! < >
• Table data generator: use only space, new line and letters in text columns, and limit to 1024 characters
• Issue #176: move foreign key column value behind the text value, in the grid foreign key drop-down, so a user may select an item by typing letters
• Leave space for column id in grid column headers. See https://www.heidisql.com/forum.php?t=44161
• Issue #2266: Invisible virtual column syntax is generated wrong

v12.12 Linux now available.

Get it from the download page

Full changelog: https://github.com/HeidiSQL/HeidiSQL/commits/lazarus/

Latest notable changes:

• Most of the updates done on the Windows version (see post above), plus:
• Fix a bunch of compiler warnings and hints
• Update check: do not confuse users with a changelog link of the Windows version, and hide (Windows) nightly build text
• Issue #2201: allow GetSessionNames() to create the given ParentPath if it does not exist, in this case the empty "Sessions" root key
• Let PortOpen() return true when netstat command could not be run, to prevent loops with broken commands
• Remove dead comments from THttpDownload
• Issue #2225: fix crash in grid editing, when canceling through Esc key
• Issue #2225: fix crash in grid value change, apply patch from hennerdrewes with Application.QueueAsyncCall in DoEndEdit
• Prefer UTF-8 encoding for loading files, instead of auto-detection, which breaks in many cases. See https://www.heidisql.com/forum.php?t=44351
• Issue #2229: prefer const over constref for FPC>=3.2.4, fix unsupported TabOrder on TSpeedbutton, pass a float value to FloatToStr
• remove unused units from uses clause in lpr project file
• Issue #2221: fix wrong detection of table alias and following dot, with text after the current cursor position
• Issue #2221: enhance SQL completion proposal in a way SynEdit/Lazarus propagates it, with a focus on column names
• Issue #2227: enable formatter for JSON code in text editor
• Issue #2203: auto-convert Windows home path to Linux home path when importing a setting file
• Issue #2222: fix missing last character in CREATE TABLE code on table editor and copy-table dialog
• Issue #2202: show a more helpful hint when no library was selected (and none is available) for connecting
• Issue #2216: remove predefined SynMemo keystrokes ecLineBreak, ecInsertLine, ecDeleteWord. The latter one inactivates Ctrl+T shortcut for new query tab
• Issue #2202: prefer libmariadb over libmysql when none of them is installed. Also, prefer the -dev packages.
• Issue #2202: depend on libgtk2.0-0t64, openssl and openssh-client. Also, require all of the database driver libraries so users are not potentially left with an empty library drop-down.

Thanks and kudos for Linux build! Looking good on Omarchy.

Huge thanks for the Linux version. I've been using it since, and the stability has improved greatly compared to the previous release.