Download HeidiSQL 12.7, released on 05 May 2024

Donate

Compatibility notes

Nightly Builds of heidisql.exe

Latest automatically compiled main executable and installers for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe. Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones.

  1. Issue #1768:
    * Dynamically set the used MYSQL_OPT_* constants for libmysql v8+, to fix the reported SEC_E_ALGORITHM_MISMATCH connection error on SSL-enabled sessions.
    * add libmysql-8.4.0-64.dll to installer
    * remove deprecated and no longer used mysql_ssl_set() function

    committed: 28 May 2024 19:33 compiled: 28 May 2024 19:46

    32bit build: 16.5 MB 64bit build 22.7 MB 32+64bit installer 41.7 MB

  2. Issue #1897: initialize nodes with vsMultiLine only if toGridExtensions option is set, so the host subtabs do not suffer from other bugs. See https://www.heidisql.com/forum.php?t=42191

    committed: 21 May 2024 19:39 compiled: 21 May 2024 20:25

    64bit build 22.6 MB

  3. Issue #1768: prefer mysql_options() with MYSQL_OPT_SSL_* over deprecated mysql_ssl_set(). And merge some newer TMySQLOption items from mariadb-server\libmariadb\include\mysql.h

    committed: 20 May 2024 10:53 compiled: 20 May 2024 11:25

    64bit build 22.6 MB

  4. Use custom tab width and tabs-to-spaces setting uniquely in all places where we generate code. Provides a new CodeIndent() helper. Closes #1330

    committed: 19 May 2024 12:22 compiled: 19 May 2024 12:25

    64bit build 22.6 MB

  5. Set TLS options BEFORE calling mysql_ssl_set(). Probably helps fixing issue #1768

    committed: 18 May 2024 17:40 compiled: 18 May 2024 18:26

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 41.1 MB

  6. Fix retrieval of PG foreign keys on table names which exist in multiple schemata. Closes #1956.

    committed: 18 May 2024 12:11 compiled: 18 May 2024 12:25

    64bit build 22.6 MB

  7. Support zooming per mouse wheel in all remaining TSynMemo instances. This was missing in the procedure editor and log panel for instance.

    committed: 17 May 2024 07:34 compiled: 17 May 2024 08:25

    64bit build 22.6 MB

  8. Add CURRENT_TIMESTAMP function, this time missing in the newer generated functions-mysql8.ini. Closes #1951

    committed: 15 May 2024 09:10 compiled: 15 May 2024 09:26

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 41.1 MB

  9. Issue #1763: fix wrong DPI shown in log panel, and too high donate button after DPI change

    committed: 10 May 2024 15:31 compiled: 10 May 2024 16:25

    64bit build 22.6 MB

  10. Mark grid nodes with vsMultiLine, even if asGridRowLineCount option is set to 1. Fixes endlessly received WM_PAINT messages on results with large lines and tabs in it. Fixes issue #1897. See https://www.heidisql.com/forum.php?t=41502

    committed: 09 May 2024 13:03 compiled: 09 May 2024 13:25

    64bit build 22.6 MB

  11. Bump version for v12.7 release

    committed: 05 May 2024 12:05 compiled: 05 May 2024 12:09

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 41.1 MB

  12. Issue #1947: don't change case of detected column names, in CSV parser

    committed: 01 May 2024 16:48 compiled: 01 May 2024 17:25

    64bit build 22.6 MB

  13. Issue #139: move the few lines of code from OnBeforeCellPaint events of 3 remaining host subtabs into HostListBeforeCellPaint

    committed: 01 May 2024 12:22 compiled: 01 May 2024 12:25

    64bit build 22.6 MB

  14. Issue #139: use alternating row background in database tab, and in all sub tabs of the host tab

    committed: 01 May 2024 12:00

  15. Issue #1936: simplify code in TfrmTextEditor.FormClose

    committed: 29 Apr 2024 16:28 compiled: 29 Apr 2024 17:25

    64bit build 22.6 MB

  16. Issue #1936: simplify code, use the reference to TfrmTextEditor only locally in the ButtonClick event

    committed: 29 Apr 2024 16:13 compiled: 29 Apr 2024 16:25

    64bit build 22.6 MB

  17. Issue #1936: Attempt to fix EAbstractError when closing text editor

    committed: 29 Apr 2024 16:04

  18. Issue #139: minor optimization

    committed: 29 Apr 2024 12:08 compiled: 29 Apr 2024 12:25

    64bit build 22.6 MB

  19. Alternating row background colors in table columns list, if activated by user. Closes #139

    committed: 29 Apr 2024 09:24 compiled: 29 Apr 2024 09:25

    64bit build 22.6 MB

  20. Reset sort order of data tab grid as well, when user clicks "Clear data tab filter". Closes #1868

    committed: 29 Apr 2024 07:44 compiled: 29 Apr 2024 08:26

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 41.1 MB

  21. Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8, taken from https://dlm.mariadb.com/browse/c_connector/201/1924/

    committed: 26 Apr 2024 13:55 compiled: 26 Apr 2024 14:26

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 41.1 MB

  22. Issue #1931: retrieve oid of user defined PostgreSQL data type CITEXT dynamically, which is different on each server/database.

    committed: 24 Apr 2024 20:07 compiled: 24 Apr 2024 20:25

    64bit build 22.6 MB

  23. Support CITEXT columns and categorize as text type, so these show up in foreign values pulldown editor of data grid. Closes #1931

    committed: 22 Apr 2024 20:30 compiled: 22 Apr 2024 21:25

    64bit build 22.6 MB

  24. Grid export: implement JSON Lines format. Closes #1930

    committed: 21 Apr 2024 18:08 compiled: 21 Apr 2024 18:25

    64bit build 22.6 MB

  25. Grid export: fix non triggered code for format selection

    committed: 21 Apr 2024 16:14 compiled: 21 Apr 2024 16:25

    64bit build 22.6 MB

  26. Grid export: convert format TComboBox to TComboBoxEx with icons

    committed: 21 Apr 2024 16:08

  27. Reorder components in grid export dialog, and convert format radio buttons to combobox. Makes the dialog more wide than high, creating space for wider labels and more format options.

    committed: 20 Apr 2024 10:50 compiled: 20 Apr 2024 11:25

    64bit build 22.6 MB

  28. Set DbTree.DefaultNodeHeight in FormShow rather than in FormCreate, to respect DPI settings. Closes #1943

    committed: 18 Apr 2024 10:24 compiled: 18 Apr 2024 10:25

    64bit build 22.6 MB

  29. Reset FClipboardHasNull marker before pasting text which was copied outside the application. Closes #1942

    committed: 17 Apr 2024 15:01 compiled: 17 Apr 2024 15:25

    64bit build 22.6 MB

  30. Update plink executables to v0.81

    committed: 17 Apr 2024 11:28 compiled: 17 Apr 2024 12:26

    32bit build: 16.5 MB 64bit build 22.6 MB 32+64bit installer 40.8 MB

  31. In TSecureShellCmd.Connect, include parallel happened errors in any success dialog. Also, log errors to the log panel when both pipes have content. Closes #1940

    committed: 17 Apr 2024 11:27

  32. Issue #321: Fix SQL code in TTableKey.SQLCode for PostgreSQL

    committed: 16 Apr 2024 20:15 compiled: 16 Apr 2024 20:25

    64bit build 22.6 MB

  33. Issue #1939: Fix empty CREATE TABLE code and "List index out of bounds" message in log, due to accessing TTableKey.Collations[x] without being initialized

    committed: 16 Apr 2024 20:13

  34. Update VirtualTreeview component code to v8.0.3 from 2024-04-07

    committed: 16 Apr 2024 10:33 compiled: 16 Apr 2024 11:25

    64bit build 22.6 MB

  35. Update SQLite libraries to v3.45.3 from 2024-04-15

    committed: 16 Apr 2024 10:08

  36. Update list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series Closes #1933

    committed: 14 Apr 2024 12:12 compiled: 14 Apr 2024 12:25

    64bit build 22.6 MB

  37. Issue #1934: fix empty column list in completion proposal when user input starts with a quote character

    committed: 14 Apr 2024 11:48

  38. Outsource new line replacements into new StripNewLines() function

    committed: 12 Apr 2024 06:59 compiled: 12 Apr 2024 07:25

    64bit build 22.6 MB

  39. Fix too greedy expression for finding result name. See https://www.heidisql.com/forum.php?t=10493

    committed: 11 Apr 2024 19:18

  40. Issue #1586: include "COLLATE xyz" clause when applying collation and user checked the "Convert data" option, so the columns do not get the default collation of the new charset

    committed: 10 Apr 2024 12:13 compiled: 10 Apr 2024 12:25

    64bit build 22.6 MB

  41. Support naming result tabs per "-- name: xyz" comment. See https://www.heidisql.com/forum.php?t=10493

    committed: 08 Apr 2024 14:32 compiled: 08 Apr 2024 15:25

    64bit build 22.6 MB

  42. Fix invalid SQL code for dropping foreign key constraint in PostgreSQL mode. Closes #1247

    committed: 28 Mar 2024 19:33 compiled: 28 Mar 2024 20:25

    64bit build 22.6 MB

  43. Issue #1927: display column comments in completion proposal, give that third column more space to the left and italic style

    committed: 28 Mar 2024 17:18 compiled: 28 Mar 2024 17:25

    64bit build 22.6 MB

  44. Scale controls on TSetEditorLink DPI aware. See pm from HW

    committed: 25 Mar 2024 14:14 compiled: 25 Mar 2024 14:25

    64bit build 22.6 MB

  45. Add functions-mysql8.ini with some newer functions in it, and search for version specific ini file when connecting. See https://www.heidisql.com/forum.php?t=41892

    committed: 20 Mar 2024 15:55 compiled: 20 Mar 2024 16:26

    32bit build: 16.4 MB 64bit build 22.6 MB 32+64bit installer 40.8 MB

  46. Fix non-working scrolling with a horizontal mouse wheel in grids, by preferring TWMScroll.Pos over TScrollInfo.nTrackPos (always 0). Closes #355

    committed: 20 Mar 2024 10:30 compiled: 20 Mar 2024 11:25

    64bit build 22.6 MB

  47. Fix completion proposal not showing columns of a table alias when table name contains the word "join". Closes #1923

    committed: 17 Mar 2024 09:38 compiled: 17 Mar 2024 10:25

    64bit build 22.6 MB

  48. Hopefully fix slow loading tabs. Related to commit 1d1d1a493892eba9152a868bc303a11c1826af74.

    committed: 13 Mar 2024 15:37 compiled: 13 Mar 2024 16:25

    64bit build 22.6 MB

  49. Host tab: use session name as tab caption, and show host name as mouse-over hint. See https://www.heidisql.com/forum.php?t=41399

    committed: 09 Mar 2024 16:48 compiled: 09 Mar 2024 17:25

    64bit build 22.6 MB

  50. Issue #1917: use existing Charset, Id and Default column names in GetCollationTable

    committed: 03 Mar 2024 19:43 compiled: 03 Mar 2024 20:25

    64bit build 22.6 MB