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. Support wildcard options in "Find text on server" dialog in a new drop down box, to provide a possibility to find exact matches. See http://www.heidisql.com/forum.php?t=21388

    Committed: 4 days ago (Wed, 25 May 16 20:53)

  2. Fix EArgumentOutOfRangeException in TDBConnection.PrefetchResults when SQL batch could not be separated correctly. Should be a rare case, but happened, see http://www.heidisql.com/forum.php?t=21380

    Committed: 5 days ago (Tue, 24 May 16 18:14)

  3. Display number of selected besides available columns on "Columns" button in "Data" tab.

    Committed: 5 days ago (Tue, 24 May 16 18:06)

  4. Display number of sorted columns on "Sorting" button. See http://www.heidisql.com/forum.php?t=17463#p21386

    Committed: 5 days ago (Tue, 24 May 16 17:58)

  5. Fix wrong FLOAT data type mapping between DB.TFieldType and TDBDatatypeIndex, in TAdoDBQuery.Execute. See http://www.heidisql.com/forum.php?t=21306

    Committed: 6 days ago (Mon, 23 May 16 20:55)

  6. Attempt to fix high DPI awareness. See http://www.heidisql.com/forum.php?t=21287

    Committed: 2 weeks ago (Mon, 16 May 16 12:44)

  7. Missing file for r5073: BIT column syntax. See http://www.heidisql.com/forum.php?t=20333

    Committed: 3 weeks ago (Fri, 06 May 16 18:01)

  8. Fix "Database(s)" string split by space characters. Allow semicolon only. See http://www.heidisql.com/forum.php?t=21080

    Committed: 3 weeks ago (Fri, 06 May 16 17:56)

  9. Wrap grid export code in a try/except block, so we can catch a potential "Cannot determine name of table" error, occurring while trying to get the WHERE clause for DELETEs. See http://www.heidisql.com/forum.php?t=21168

    Committed: 1 month ago (Thu, 28 Apr 16 20:13)

  10. Set each procedure parameter on its own line, and remove some tabs. See http://www.heidisql.com/forum.php?t=21166

    Committed: 1 month ago (Wed, 27 Apr 16 20:08)

  11. Use b'' format only for BIT columns in MySQL only. See http://www.heidisql.com/forum.php?t=20333

    Committed: 1 month ago (Wed, 27 Apr 16 19:55)

  12. Overcome 4000 character limit in IS.VIEW_DEFINITION. See http://www.heidisql.com/forum.php?t=21097

    Committed: 1 month ago (Sun, 17 Apr 16 15:31)

  13. Add splitter on procedure editor. See http://www.heidisql.com/forum.php?t=21106

    Committed: 2 months ago (Wed, 13 Apr 16 19:27)

  14. Fill SSL command line parameters only if not empty in HeidiSQL session. See http://www.heidisql.com/forum.php?t=21024

    Committed: 2 months ago (Mon, 11 Apr 16 19:39)

  15. Display the version of libpq.dll in the status bar's balloon hint with server details, using PQlibVersion().

    Committed: 2 months ago (Sun, 10 Apr 16 12:27)

  16. Update all PostgreSQL libraries, add missing libiconv-2.dll, unify filename of 32bit version of libintl.dll (=> libintl-8.dll), and finally revert the previous 3 commits, which hopefully are not required with these updates. See http://www.heidisql.com/forum.php?t=21039

    Committed: 2 months ago (Fri, 08 Apr 16 18:26)

  17. Load libpq.dll after just checking if it exists. Do not check what LoadLibrary returns. This is quite risky, but there seem to be cases where LoadLibrary returns 0 although libpq.dll was loaded. See http://www.heidisql.com/forum.php?t=21039

    Committed: 2 months ago (Wed, 06 Apr 16 07:03)

  18. Attempt to add a helpful error message to the error dialog when libpq.dll was not loaded. http://www.heidisql.com/forum.php?t=21039

    Committed: 2 months ago (Tue, 05 Apr 16 07:04)

  19. Load libpq.dll with full path, so the LoadLibrary does not accidentally take a different (probably wrong) one from somewhere else than the current directory. See http://www.heidisql.com/forum.php?t=21039

    Committed: 2 months ago (Mon, 04 Apr 16 20:18)

  20. MSSQL: Work around multiple results from a single query, in case of a stored procedure for example. See http://www.heidisql.com/forum.php?t=21036

    Committed: 2 months ago (Mon, 04 Apr 16 19:25)

  21. Add "SQL DELETEs/INSERTs" to grid export formats. See http://www.heidisql.com/forum.php?t=20929

    Committed: 2 months ago (Sun, 03 Apr 16 11:45)

  22. Fix multi column filter concatenated without OR after linebreak. See http://www.heidisql.com/forum.php?t=21005 and http://www.heidisql.com/forum.php?t=21007

    Committed: 2 months ago (Wed, 30 Mar 16 20:08)

  23. Use an exact comparison for PostgreSQL's BOOLEAN datatype. See http://www.heidisql.com/forum.php?t=20953

    Committed: 2 months ago (Wed, 30 Mar 16 20:00)

  24. Display UTC date/time in 5th status bar panel. See http://www.heidisql.com/forum.php?t=20999

    Committed: 2 months ago (Tue, 29 Mar 16 20:21)

  25. MSSQL table names: Revert previous change in TAdoDBQuery.TableName and assign separate SQL strings earlier, in TAdoDBConnection.GetLastResults. Fixes wrong table name in "Send queries in one go" mode. See http://www.heidisql.com/forum.php?t=20979

    Committed: 2 months ago (Fri, 25 Mar 16 20:11)

  26. Fix bug in TAdoDBQuery.TableName when multiple queries were executed. See http://www.heidisql.com/forum.php?t=20979

    Committed: 2 months ago (Fri, 25 Mar 16 11:08)

  27. Use an exact comparison in multi-column filters for some PostgreSQL data types to overcome SQL errors, e.g. UUID, INT etc. Also, prevent other errors by matching the value against a certain regular expression. If it does not match, leave this column away. Introduces the new TDataType.ValueMustMatch property. See http://www.heidisql.com/forum.php?t=20953

    Committed: 2 months ago (Wed, 23 Mar 16 18:09)

  28. Remember selected encoding in several file-open-dialogs. See http://www.heidisql.com/forum.php?t=20868

    Committed: 2 months ago (Sun, 20 Mar 16 14:34)

  29. Do not check existence of IS.routines before querying it. See http://www.heidisql.com/forum.php?t=20456#p20487

    Committed: 3 months ago (Sun, 13 Mar 16 11:29)

  30. Support searching in procedures and functions on MSSQL and PostgreSQL mode too.

    Committed: 3 months ago (Sun, 13 Mar 16 11:22)

  31. Warn if export output filename contains illegal characters, which TFileStream.Create does not catch for some reason. See http://www.heidisql.com/forum.php?t=20873

    Committed: 3 months ago (Sat, 12 Mar 16 14:55)

  32. Make keep-alive-interval customizable in "Advanced" tab on session manager. See http://www.heidisql.com/forum.php?t=20829

    Committed: 3 months ago (Sat, 05 Mar 16 19:36)

  33. Use a better fitting icon for the browse-file button in SQL export dialog. See http://www.heidisql.com/forum.php?t=20717

    Committed: 3 months ago (Sun, 21 Feb 16 11:32)

  34. Bump copyright year in license file

    Committed: 3 months ago (Wed, 17 Feb 16 20:42)

  35. Again, try to tweak the width of the size column on the database tree, as there is still an ellipsis in some cases.

    Committed: 4 months ago (Mon, 08 Feb 16 20:17)

  36. 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: 4 months ago (Sun, 07 Feb 16 12:44)

  37. 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: 4 months ago (Sun, 07 Feb 16 12:42)

  38. 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: 4 months ago (Sun, 31 Jan 16 19:20)

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

    Committed: 4 months ago (Wed, 27 Jan 16 19:31)

  40. 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: 4 months ago (Sat, 23 Jan 16 10:56)

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

    Committed: 4 months ago (Wed, 20 Jan 16 20:36)

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

    Committed: 4 months ago (Thu, 14 Jan 16 21:33)

  43. 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: 5 months ago (Wed, 13 Jan 16 20:22)

  44. 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: 5 months ago (Mon, 11 Jan 16 21:59)

  45. 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: 5 months ago (Sun, 10 Jan 16 18:48)

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

    Committed: 5 months ago (Tue, 05 Jan 16 21:34)

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

    Committed: 5 months ago (Mon, 04 Jan 16 19:35)

  48. 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: 5 months ago (Wed, 23 Dec 15 17:17)

  49. 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: 5 months ago (Tue, 22 Dec 15 20:33)

  50. 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: 5 months ago (Tue, 22 Dec 15 12:31)

  51. 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: 5 months ago (Sun, 20 Dec 15 12:38)

  52. 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: 5 months ago (Sun, 20 Dec 15 12:03)

  53. Remove unused variables

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

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

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

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

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

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

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

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

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

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

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

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

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

  60. 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: 6 months ago (Mon, 07 Dec 15 19:08)

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

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

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

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

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

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

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

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

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

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

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

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

  67. 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: 6 months ago (Mon, 30 Nov 15 11:25)

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

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

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

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

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

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

  71. 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: 6 months ago (Fri, 20 Nov 15 17:43)

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

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

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

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

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

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

  75. 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: 7 months ago (Thu, 12 Nov 15 18:09)

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

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

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

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

  78. 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: 7 months ago (Tue, 10 Nov 15 20:15)

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

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

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

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

  81. Revert accidentally committed file from previous commit.

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

  82. 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: 7 months ago (Tue, 03 Nov 15 07:28)

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

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

  84. 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: 7 months ago (Fri, 30 Oct 15 19:41)

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

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

  86. 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: 8 months ago (Tue, 13 Oct 15 20:07)

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

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

  88. 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: 8 months ago (Tue, 06 Oct 15 20:46)

  89. 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: 8 months ago (Fri, 02 Oct 15 19:40)

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

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

  91. 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: 8 months ago (Sun, 20 Sep 15 20:03)

  92. 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: 8 months ago (Thu, 17 Sep 15 19:43)

  93. 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: 8 months ago (Wed, 16 Sep 15 07:49)

  94. 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: 8 months ago (Tue, 15 Sep 15 22:23)

  95. 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: 9 months ago (Tue, 01 Sep 15 10:00)

  96. 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: 9 months ago (Mon, 31 Aug 15 15:56)

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

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

  98. 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: 9 months ago (Mon, 31 Aug 15 09:15)

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

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

  100. Prepare upcoming v9.3 release

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