Download HeidiSQL 9.3 (08 Aug 2015)


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. Now that 1023 MiB are formatted as 0.9 GiB, we need to adjust the auto-calculated width of the size column on the database tree.

    Committed: 14 hours ago (Sun, 07 Feb 16 12:44)

  2. Format byte numbers so that we never get a thousands separator in it. Prevents us from running into a conversion bug in helpers.CleanupNumber(). See http://www.heidisql.com/forum.php?t=20612

    Committed: 14 hours ago (Sun, 07 Feb 16 12:42)

  3. Try to show tooltip when columns in database tree are too narrow to show the full text. See http://www.heidisql.com/forum.php?t=20458

    Committed: 1 week ago (Sun, 31 Jan 16 19:20)

  4. Support inline valued functions on MSSQL. See http://www.heidisql.com/forum.php?t=20186

    Committed: 2 weeks ago (Wed, 27 Jan 16 19:31)

  5. Support procedures and functions in "Find text on server" dialog. MySQL syntax only yet, others are to implement. See http://www.heidisql.com/forum.php?t=20456

    Committed: 2 weeks ago (Sat, 23 Jan 16 10:56)

  6. Fix unquoted and uncleaned numeric values in data grid updates and inserts. See http://www.heidisql.com/forum.php?t=20434

    Committed: 3 weeks ago (Wed, 20 Jan 16 20:36)

  7. Add some new lines in SQL export, especially when "Add comments" is disabled

    Committed: 3 weeks ago (Thu, 14 Jan 16 21:33)

  8. Add new "Options" dropdown button on SQL export dialog, and two new true/false settings: "Add comments" and "Remove auto_increment clauses".
    * see http://www.heidisql.com/forum.php?t=18727#p18729
    * see http://www.heidisql.com/forum.php?t=20363#p20373

    Committed: 4 weeks ago (Wed, 13 Jan 16 20:22)

  9. Revert r5038 - quoting all columns again now. Reserved words like "interval" are not detected in EscapeString(), so this just a source of new bugs. Thanks to Vadim for his hint!

    Committed: 4 weeks ago (Mon, 11 Jan 16 21:59)

  10. Escape and quote binary strings in grid export if "View binary data as text" button is active. See http://www.heidisql.com/forum.php?t=20320

    Committed: 4 weeks ago (Sun, 10 Jan 16 18:48)

  11. Do not quote column names when not required in SELECT query for data grid. See pm from mr.pbishnoi@gmail.com

    Committed: 1 month ago (Tue, 05 Jan 16 21:34)

  12. Fix detection of virtual columns without "GENERATED ALWAYS" clause. See http://www.heidisql.com/forum.php?t=20248

    Committed: 1 month ago (Mon, 04 Jan 16 19:35)

  13. Allow tab after double dash comment in SQL highlighter. See http://www.heidisql.com/forum.php?t=20196 and http://dev.mysql.com/doc/refman/5.7/en/comments.html

    Committed: 2 months ago (Wed, 23 Dec 15 17:17)

  14. Implement TPGQuery.TableName, so exporting grid rows get a table name when needed. E.g. for output format "SQL Inserts". See http://www.heidisql.com/forum.php?t=18946 and issue #3696.

    Committed: 2 months ago (Tue, 22 Dec 15 20:33)

  15. In SQL dumps, make "SET NAMES utf8mb4" a version conditional statement for the minimum MySQL version supporting that charset. See http://www.heidisql.com/forum.php?t=20188

    Committed: 2 months ago (Tue, 22 Dec 15 12:31)

  16. Slightly increase auto-calculated width of size column in database tree, so it does not use ellipses on wider texts, e.g. "1.023 KiB"

    Committed: 2 months ago (Sun, 20 Dec 15 12:38)

  17. Table designer: Do not allow an empty length/set for data types which require one. See http://stackoverflow.com/questions/34315162/how-to-create-table-in-mariadb

    Committed: 2 months ago (Sun, 20 Dec 15 12:03)

  18. Remove unused variables

    Committed: 2 months ago (Wed, 16 Dec 15 19:35)

  19. Ignore surrounding parentheses when detecting table aliases for completion proposal.

    Committed: 2 months ago (Wed, 16 Dec 15 19:31)

  20. Rephrase confirmation message for running unsafe queries. See http://www.heidisql.com/forum.php?t=20139

    Committed: 2 months ago (Wed, 16 Dec 15 19:21)

  21. Remember size of completion proposal between sessions. See http://www.heidisql.com/forum.php?t=20130

    Committed: 2 months ago (Wed, 16 Dec 15 19:17)

  22. Fix crash when opening completion proposal with only views in a database.

    Committed: 2 months ago (Tue, 15 Dec 15 20:08)

  23. Set font size per Ctrl + mousewheel in any grid view.

    Committed: 2 months ago (Sun, 13 Dec 15 22:18)

  24. Update SynEdit component to https://github.com/SynEdit/SynEdit/commit/0470dcbf161c0d154002acbb654f1d6f7494ba91 from Sep 9, 2015

    Committed: 2 months ago (Tue, 08 Dec 15 18:46)

  25. Fix duplication of query tab controls, when it comes to aligning the query helpers tree. See http://www.heidisql.com/forum.php?t=20041

    Committed: 2 months ago (Mon, 07 Dec 15 19:08)

  26. Prevent various problems with alignment of controls. See http://www.heidisql.com/forum.php?t=18924

    Committed: 2 months ago (Thu, 03 Dec 15 20:28)

  27. Increase width of shortcut tree, so new translations have enough room. See http://www.heidisql.com/forum.php?t=20009#p20011

    Committed: 2 months ago (Wed, 02 Dec 15 14:47)

  28. Use a reasonable default height for the query editor, to prevent a splitter problem. See http://www.heidisql.com/forum.php?t=19952

    Committed: 2 months ago (Wed, 02 Dec 15 09:44)

  29. Translate SynEdit shortcut captions. See http://www.heidisql.com/forum.php?t=19401

    Committed: 2 months ago (Tue, 01 Dec 15 14:39)

  30. Missing icon file for "Run SQL file" action

    Committed: 2 months ago (Mon, 30 Nov 15 12:00)

  31. Add menu item "Run SQL file", as a complement to "Load SQL files". See http://www.heidisql.com/forum.php?t=19982

    Committed: 2 months ago (Mon, 30 Nov 15 11:56)

  32. MSSQL: Set textsize to a large value, so the view editor does not load partial code only. See http://www.heidisql.com/forum.php?t=19779#p19981

    Committed: 2 months ago (Mon, 30 Nov 15 11:25)

  33. User manager: Allow double quotes in SHOW GRANTS output, to support ANSI mode. See http://www.heidisql.com/forum.php?t=19757

    Committed: 2 months ago (Fri, 27 Nov 15 19:12)

  34. Fix position of horizontal splitter on second and successive query tabs. See http://www.heidisql.com/forum.php?t=19952

    Committed: 2 months ago (Fri, 27 Nov 15 18:15)

  35. Make brace matching color customizable, via Tools > Preferences > SQL. See http://www.heidisql.com/forum.php?t=19934

    Committed: 2 months ago (Thu, 26 Nov 15 21:28)

  36. Add virtual column syntax for MySQL, which seems to differ slightly from the MariaDB implementation. See http://www.heidisql.com/forum.php?t=19405#p19901

    Committed: 3 months ago (Fri, 20 Nov 15 17:43)

  37. Internally handle MySQL's native column types in an enumeration, not as constants. See mysql.h.pp in the MySQL server code.

    Committed: 3 months ago (Thu, 19 Nov 15 20:54)

  38. Add new MySQL internally used date/time data types. See https://bugs.mysql.com/bug.php?id=67992

    Committed: 3 months ago (Thu, 19 Nov 15 20:32)

  39. Add basic support for MySQL's new JSON data type. See http://www.heidisql.com/forum.php?t=19870

    Committed: 3 months ago (Thu, 19 Nov 15 20:23)

  40. Postpone repaint of the data grid to later, after click on a header column with a bad WHERE filter. Fixes a crash in VirtualTree, when handling the click somewhere. See http://www.heidisql.com/forum.php?t=19832

    Committed: 3 months ago (Thu, 12 Nov 15 18:09)

  41. Fix non-working detection of indexes on PostgreSQL pre-9.0 servers. See http://www.heidisql.com/forum.php?t=18581

    Committed: 3 months ago (Thu, 12 Nov 15 17:58)

  42. Make insertion of node text on double click customizable, per tree style options menu. See http://www.heidisql.com/forum.php?t=16104

    Committed: 3 months ago (Wed, 11 Nov 15 21:27)

  43. Fix order in table column parsing, so that collation is expected before a virtual expression. See http://www.heidisql.com/forum.php?t=19405

    Committed: 3 months ago (Tue, 10 Nov 15 20:15)

  44. Fix endless loop in retrieval of column comments on MSSQL. See http://www.heidisql.com/forum.php?t=19576#p19790

    Committed: 3 months ago (Sat, 07 Nov 15 13:44)

  45. Add a "clear" button to the both db+table filter textboxes.

    Committed: 3 months ago (Thu, 05 Nov 15 07:37)

  46. Revert accidentally committed file from previous commit.

    Committed: 3 months ago (Tue, 03 Nov 15 09:09)

  47. Introduce GUI font preferences setting, so the user can customize the font of all dialogs and forms. Does not work with menus, however. See http://www.heidisql.com/forum.php?t=19666

    Committed: 3 months ago (Tue, 03 Nov 15 07:28)

  48. Display column comments on MSSQL. See http://www.heidisql.com/forum.php?t=19576

    Committed: 3 months ago (Fri, 30 Oct 15 20:23)

  49. A yes/no message dialog may also return mrCancel, when the user clicks the X button to close it. Handle this case as if the user clicked "no", when HeidiSQL detects an unsafe query. See http://www.heidisql.com/forum.php?t=19697

    Committed: 3 months ago (Fri, 30 Oct 15 19:41)

  50. Do not insert database tree node caption in query editor via double click. See http://www.heidisql.com/forum.php?t=16104

    Committed: 3 months ago (Mon, 26 Oct 15 18:48)

  51. MSSQL: Fix broken query for altering column comment via table editor. See
    * here: http://www.heidisql.com/forum.php?t=16947
    * and here: http://www.heidisql.com/forum.php?t=18119

    Committed: 4 months ago (Tue, 13 Oct 15 20:07)

  52. Detect table and its alias when using UPDATE/INSERT IGNORE. See http://www.heidisql.com/forum.php?t=19534

    Committed: 4 months ago (Fri, 09 Oct 15 18:12)

  53. Revert translation of drop down values, which get used as SQL keywords in maintenance dialog. See http://www.heidisql.com/forum.php?t=19510

    Committed: 4 months ago (Tue, 06 Oct 15 20:46)

  54. Do not switch captions of upper right donate button. Potentially fixes a Windows 10 flicker issue, mentioned here: http://www.heidisql.com/forum.php?t=18120

    Committed: 4 months ago (Fri, 02 Oct 15 19:40)

  55. Add various missing translation strings. See http://www.heidisql.com/forum.php?t=19401

    Committed: 4 months ago (Sat, 26 Sep 15 14:21)

  56. Increase size of analyzed text file chunk from 100K to 1M, in DetectEncoding(), so it fails less often to see encoding relevant characters. See http://www.heidisql.com/forum.php?t=19383

    Committed: 5 months ago (Sun, 20 Sep 15 20:03)

  57. Support MSSQL's XML data type, and do not cast it to VARCHAR in data grid. See http://www.heidisql.com/forum.php?t=19372

    Committed: 5 months ago (Thu, 17 Sep 15 19:43)

  58. Use db.func instead of schema.func when schema is empty, on retrieving MSSQL routine structure. See http://www.heidisql.com/forum.php?t=19350#p19360

    Committed: 5 months ago (Wed, 16 Sep 15 07:49)

  59. Introduce query caching in TDBConnection.PrefetchResults() and PrefetchCreateCode(). Read from that cache in TDBConnection.GetResults. This way we can prefetch mass queries fired for each object in a database, like in GetCreateCode() in one single batch query. See http://www.heidisql.com/forum.php?t=19350

    Committed: 5 months ago (Tue, 15 Sep 15 22:23)

  60. Make use of RefreshHelperNode() for bind param node, and display the number of detected params in the node text. Should finally fix the issues here.

    Committed: 5 months ago (Tue, 01 Sep 15 10:00)

  61. Reset bind param tree node after checking its checkbox, so the plus/minus icon appears when the node has previously been expanded. Should fix this issue finally. See http://www.heidisql.com/forum.php?t=19171

    Committed: 5 months ago (Mon, 31 Aug 15 15:56)

  62. Two more attempts to fix non functional bind parameters.

    Committed: 5 months ago (Mon, 31 Aug 15 15:06)

  63. Add some debug messages so we can probably track down the cause of non functional bind parameters. See http://www.heidisql.com/forum.php?t=19171

    Committed: 5 months ago (Mon, 31 Aug 15 09:15)

  64. Attempt to fix non functional bind parameter detection. See http://www.heidisql.com/forum.php?t=19171

    Committed: 5 months ago (Sun, 30 Aug 15 15:49)

  65. Prepare upcoming v9.3 release

    Committed: 6 months ago (Sat, 08 Aug 15 17:40)

  66. Fix two errors due to changed function declarations in recent VirtualTree update.

    Committed: 6 months ago (Sat, 08 Aug 15 16:50)

  67. Update VirtualTree component code to v6.1.0

    Committed: 6 months ago (Sat, 08 Aug 15 16:31)

  68. PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment. See http://www.heidisql.com/forum.php?t=18937

    Committed: 7 months ago (Thu, 16 Jul 15 10:05)

  69. Session manager: Add support for SSL cipher, and add various texthints. See http://www.heidisql.com/forum.php?t=18908

    Committed: 7 months ago (Tue, 14 Jul 15 16:38)

  70. Text import: Use very last value from last row, even if it's not followed by a field or line terminator. See http://www.heidisql.com/forum.php?t=18899#p18911

    Committed: 7 months ago (Tue, 14 Jul 15 11:48)

  71. PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing. See http://www.heidisql.com/forum.php?t=18581#p18905

    Committed: 7 months ago (Tue, 14 Jul 15 11:16)

  72. CSV import: Disable features supported in MySQL only, if active connection is not MySQL. See http://www.heidisql.com/forum.php?t=18899

    Committed: 7 months ago (Mon, 13 Jul 15 19:56)

  73. Update VirtualTree component code to 6.0.0 (r816). Perhaps fixes the issue described here: http://www.heidisql.com/forum.php?t=18873

    Committed: 7 months ago (Fri, 10 Jul 15 11:00)

  74. Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them. See http://www.heidisql.com/forum.php?t=18847

    Committed: 7 months ago (Wed, 08 Jul 15 18:02)

  75. Fix various selection bugs in column selection panel

    Committed: 7 months ago (Sun, 28 Jun 15 15:39)

  76. User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=18650

    Committed: 7 months ago (Sun, 28 Jun 15 12:25)

  77. Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter. See http://www.heidisql.com/forum.php?t=18677

    Committed: 7 months ago (Wed, 24 Jun 15 19:30)

  78. Show line breaks other than Windows style as normal line breaks in text editor. See http://www.heidisql.com/forum.php?t=18769

    Committed: 8 months ago (Sun, 21 Jun 15 16:05)

  79. Prepend 'E' to escaped PostgreSQL strings. See http://www.heidisql.com/forum.php?t=18657

    Committed: 8 months ago (Thu, 18 Jun 15 20:21)

  80. Use server time for data grid > "Insert value" menu items. See http://www.heidisql.com/forum.php?t=18717

    Committed: 8 months ago (Thu, 18 Jun 15 19:55)

  81. Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL. See http://www.heidisql.com/forum.php?t=18581

    Committed: 8 months ago (Thu, 18 Jun 15 19:37)

  82. Fix transparency areas in question icon

    Committed: 8 months ago (Sun, 14 Jun 15 15:29)

  83. Ensure question icon is not the first one in the application, so the exe does not use the question icon any more. See http://stackoverflow.com/questions/15564755/adding-a-res-file-to-project-replaces-the-default-icon-how-to-prevent-it

    Committed: 8 months ago (Sun, 14 Jun 15 15:23)

  84. * Display session name in caption of all message dialogs. See http://www.heidisql.com/forum.php?t=18606
    * Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.

    Committed: 8 months ago (Sun, 14 Jun 15 15:13)

  85. Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use. Fixes connection problems for multiple connected sessions.
    Note: PortOpen() needs ~1 second to finish, so we cannot check thousands of other ports.
    See http://www.heidisql.com/forum.php?t=18601#p18601

    Committed: 8 months ago (Sun, 14 Jun 15 08:53)

  86. Introduce option for setting the line break style in text cells without breaks. See http://www.heidisql.com/forum.php?t=18682

    Committed: 8 months ago (Sat, 13 Jun 15 13:09)

  87. Log debug message in helpers.ShellExec(), so we can check the url which Heidi sends to MariaDB's explain analyzer. See http://www.heidisql.com/forum.php?t=18677

    Committed: 8 months ago (Sat, 13 Jun 15 12:21)

  88. Fix wrong detection of BIT default values. See http://www.heidisql.com/forum.php?t=17862

    Committed: 8 months ago (Sun, 31 May 15 10:53)

  89. MSSQL: Again, try to use some universal date/time format, by injecting a "T" between the date and the time portion. This time with a TRegExpr instead of a TDateTime object. See http://www.heidisql.com/forum.php?t=18441

    Committed: 8 months ago (Sat, 30 May 15 16:11)

  90. MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database. See http://www.heidisql.com/forum.php?t=18559

    Committed: 8 months ago (Sat, 30 May 15 10:26)

  91. Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types. See http://www.heidisql.com/forum.php?t=18466

    Committed: 8 months ago (Thu, 28 May 15 21:10)

  92. Strip folder path from various file settings, including plink.exe location, if it's the application directory. See http://www.heidisql.com/forum.php?t=18494

    Committed: 8 months ago (Tue, 26 May 15 13:03)

  93. Fix compiler warning W1030: "Invalid compiler directive: 'true'". See
    * http://blog.spreendigital.de/2014/03/14/w1030_warning_xe5/
    * http://www.heidisql.com/forum.php?t=18494

    Committed: 8 months ago (Mon, 25 May 15 11:58)

  94. Revert r4954 - "schema.table" does not work in data grid, but require when renaming a table. See http://www.heidisql.com/forum.php?t=18498

    Committed: 8 months ago (Mon, 25 May 15 11:54)

  95. MSSQL: Prefer "schema.table" quoting over "schema"."table". See http://www.heidisql.com/forum.php?t=18476

    Committed: 9 months ago (Fri, 22 May 15 18:37)

  96. Support PostgreSQL data types cidr, inet and macaddr. Grouped in dtcText category, so the grids show the normal text editor, but without applying SUBSTR(). See http://www.heidisql.com/forum.php?t=18442

    Committed: 9 months ago (Tue, 19 May 15 07:41)

  97. Introduce new data type property "LoadPart" (boolean), which says whether such columns can be loaded per SUBSTR or LEFT into the data grid. Set it to false for UUID and JSON. See http://www.heidisql.com/forum.php?t=18442

    Committed: 9 months ago (Mon, 18 May 15 21:41)

  98. Add support for PostgreSQL's UUID data type. See http://www.heidisql.com/forum.php?t=18442

    Committed: 9 months ago (Sat, 16 May 15 11:17)

  99. Change data type of connection thread id from int to int64, to support killing processes on long running servers. See http://www.heidisql.com/forum.php?t=18426

    Committed: 9 months ago (Thu, 14 May 15 15:31)

  100. Raise connection error when local SSH port for plink is already in use. See http://www.heidisql.com/forum.php?t=18395

    Committed: 9 months ago (Mon, 11 May 15 19:51)