ci: bump version for v12.16 release

ci: bump version for v12.15.0.7171

Note: You can already get a preview of v13 for Windows, built on the same codebase as the Linux version. See the
download page for a zip package.

3rd party updates:

• update SQLite library to v3.51.0

Bugfixes and enhancements:

• fix: crash when grid-exporting without required key (issue #2311)
• fix: cannot save new table when added column was removed (issue #2326)
• fix: delete CLI-created session settings from registry after disconnect (issue #2162)
• fix: query batch stops at second last query if it has errors but StopOnErrors is off (issue #2317)
• feat: support SSH tunnel configuration per commandline (issue #2322)
• disable tree option asDoubleClickInsertsNodeText by default (issue #2307)
• fix: require elevation per build button only if app directory is not writable by user (issue #2305)
• feat: keep time fractions intact for CSV exports (issue #2098)
• fix: crash in AnyGridPaintText with no query result
• feat: show NULL values in system variables listing (issue #1281)
• feat: highlight same text in grids based on all selected rows
• fix: crash in printer dialog with 0 printers available (issue #2283)
• feat: support fractional UNIX timestamps in grids (issue #884)
• feat: add "source table: xyz" hint to query result column headers https://www.heidisql.com/forum.php?t=44554

Get it from the download page

3rd party updates:

• Issue #2076: exchange 32 bit SSL libraries with their 64 bit pendants, fixing SSL connections with libpq and libmariadb

First Linux version as a release with a tag.

Get it from the download page

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

Latest notable changes:

• SSH tunnel support now works, using external ssh command, like in the Windows version
• Translation support for 35 languages, through .mo files. Thanks to all the translators on Transifex!
• Icons on status bar
• Enable bracket highlighting in SQL editors
• Grid cell editors working (with quite a few crashes)
• Enabled automatic tab restore
• Table editor and the others (view, routine, trigger, event) working now
• All forms now use Lazarus' excellent anchorings for controls

Known issues:

• #2149: Missing support for MS SQL and Interbase/Firebird
• #2131: Crashes in grid cell editors, especially after hitting the Esc key
• #2143: No .rpm package for RedHat based Linux. Help appreciated.
• #2141: no wordwrap in SQL editors

A big thanks go to the Lazarus team for providing such a nice and responsive IDE. Congratulations for releasing Lazarus 4.0 these days. HeidiSQL for Linux is yet built with Lazarus v3.8 and FreePascal v3.2.2.

Get it from the download page

3rd party updates:

• Update plink executables to v0.83. See https://www.chiark.greenend.org.uk/~sgtatham/putty/
• Update MariaDB Connector/C to v3.4.5. See https://mariadb.com/kb/en/mariadb-connector-c-3-4-5-release-notes/
• Update SQLite libraries to v3.50.1. See https://www.sqlite.org/
• Update SQLite multiple cipher libraries to v2.1.3. See https://github.com/utelle/SQLite3MultipleCiphers/releases/

New stuff:

• Issue #604: add context menu item "Select top 1000 rows"
• Issue #2175: if asShowRowId option is enabled, show also the index of columns in their header, through the OnAdvancedHeaderDraw/ownerdraw event
• Issue #2168: select rows from table to export by its primary key columns, so PostgreSQL does not apply a random sorting
• Issue #2155: paint session background and icon in session drop-down of SQL export dialog
• Issue #2107: add "invert check" menu item on table tools tree
• Issue #2068: support MariaDB's new VECTOR index in table designer, without M and DISTANCE settings yet
• Issue #2068: support MariaDB's new VECTOR data type in table designer, categorize as binary
• Issue #2083: add menu item "Copy all lines" for copying visible and initialized nodes from any VirtualTree instance as CSV data
• Issue #1975: add "keep asking" checkbox to reformat dialog
• Issue #646: forget setting for "Favorite objects only" on each connection start
• Issue #2064: support UTF-8 BOM encoding when loading and saving editor files

Bugfixes and enhancements:

• Issue #1253: fix index creation on PostgreSQL tables, use separate CREATE INDEX queries
• Issue #2187: Fixed EAccessViolation when closing editor while using non-default theme
• Create helper table with the servers' default engine when exporting a view. See https://www.heidisql.com/forum.php?t=44125
• Issue #2186: fix wrong number of rows shown in grid export dialog when post filter is active
• Issue #2118: activate legacy-stdio-prompts mode in plink SSH tunnel, to fix non prompted passphrase since plink 0.82
• Issue #604: sync number of rows to query with the per-page data grid setting
• Issue #604: support multiple tables and views selected on database tab, in new "Select top 1000 rows" feature
• Issue #2172: fix wrong comment
• Issue #2172: prompt for password again, when connection has timeout or broke
• Issue #2159: fix memory leak
• Issue #2159: SQLite: export separated table indexes, and export views and triggers
• Issue #2168: turn off synchronize_seqscans variable in PostgreSQL mode, to be sure SELECT's show a stable row sorting. See https://www.postgresql.org/docs/8.3/runtime-config-compatible.html#GUC-SYNCHRONIZE-SEQSCANS
• Issue #1853: try to fix column definition changes on MS SQL wrt collation quoting and default value
• Issue #2155: high DPI fix for painting icons in SQL export target drop-down
• Issue #2156: unescape generated column expression when loading from IS.COLUMNS
• Keep retrieving exact row count on data tab header after activated via context menu, until another table has focus
• Display number or rows in data tab header for views. See https://www.heidisql.com/forum.php?t=44057
• Issue #214: when refreshing, ask user if he wants to discard modifications in table/view/routine/... editors
• Prefer Boolean over Bool type in owned code
• Issue #2139: fix missing AND's in REQUIRE clause, and move REQUIRE clause from GRANT to ALTER USER query, as MySQL does not support that in GRANT since v8.x
• Issue #2133: revert broken characters and encoding of apphelpers unit
• implementation of Unicode logic for password encryption
• Issue #2132: fix crash when saving an sql file previously loaded with auto-detected encoding
• Issue #2123: prevent crash in libpq when disconnecting an already disconnected connection
• Issue #2128: fix wrong encoding of connection string for PQconnectdb()
• Issue #2123: fix reconnect mechanism in TPGConnection.Ping()
• Issue #2119: optimize calculation of status bar panel widths
• Issue #1986: do not set CLIENT_SSL flag with libmariadb, which seems to cause a "bad handshake" in mysql_real_connect()
• Issue #2103: fix latin1 charset used with libmysql v8.x which reports "utf8mb4" by mysql_character_set_name()
• Issue #2101: attempt to reactivate progress bar in status bar when running through Wine, now with a safety check for IsWindow()
• Update default functions-mysql.ini with predefined line breaks and much more help content
• Update functions-mysql8.ini with predefined line breaks and much more help content
• Enable padding in multiline tooltips with a derived THintWindow class
• Reduce web page openings to once after successful nightly update
• Wrap long lines in data type hints. See https://www.heidisql.com/forum.php?t=43881
• Simplify and optimize functions generator for MariaDB, and update functions-mariadb.ini with predefined line breaks
• Issue #2095: fix wrong/no control characters used when changing format to Excel csv via file-save dialog
• Issue #2083: use empty field delimiter and tab separator for new copy-lines feature
• Issue #2085: tell TStringStream.Create not to free its TEncoding object after usage, as we use application-lifetime-available encoding instances
• Issue #2084: show numeric values in variables tab locally formatted in a tooltip
• Show type of exception happening through AppSettings.ExportSettings
• Issue #835: move prompt for overwriting output file from save-dialog to later when exporting is started, catching cases where the previous filename is used
• Issue #2079: work with the "default" set of SQLite encryption parameters, not the transient ones
• Prevent connection activity through hovering table token while user query is running. Similar to issue #278

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, plus:
• Issue #2197: Can't set logging due to file not open error
• Issue #2182: mariadb cannot add users
• Issue #2177: Sort icons in column headers of data and query grid
• Issue #2165: Support libperconaserverclient for MySQL
• Issue #2189: wrong digit separator localized version

Get it from the download page

The v12.12 release now abandons the 32 bit portable releases and nightly builds.

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

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, 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.

New stuff:

• feat: sort sessions and folders according to user locale (#1828)
• feat: sort session folders at top per setting (#1828)
• feat: filter box in user manager (#2275)
• add checkbox "Open file after creation" to grid export dialog (#912)

Bugfixes and enhancements:

• fix: sort empty session folders like non-empty ones (#1828)
• fix: set modified flag after move per button (#2220)
• fix: column reordering per drag and drop (#2220)
• fix: list procedures in PostgreSQL(#2278)
• fix: missing DELETE HISTORY privilege on MariaDB (#1026)
• fix: prevent crash in auto-refresh action (#1060)
• fix: bad message with no library selected (#1020)
• Table data generator: generate missing values for geometry columns
• allow modify length of index with binary column (#900)
• fix no longer working move up/down of selected columns, see https://www.heidisql.com/forum.php?t=44467 (#2220)
• end global "edit function" mode for grid editing early (#875)
• take care for escaped ENUM definitions (#799)
• work around non-greedy expression when extracting the return data type of a stored function with a space in it. (#768)
• safety replacement for folder separator when renaming a session or folder (#682)
• leave away schema when double-click table for inserting into query editor (#551)
• fix sticky empty-password warning after setting a non-empty one (#441)
• allow sorting columns in table designer by click on their header (#2220)
• ignore semicolon between double-dollar quoted strings when separating SQL queries by semicolon, e.g. $$ foo; bar $$ (#1326)