distal-attribute
distal-attribute
distal-attribute
distal-attribute

Download HeidiSQL 8.3 (25 Jan 2014)

Donate

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.

Link to latest build   RSS Feed Changes Feed

  1. Switch character set from utf8 to the fixed one called utf8mb4 in MySQL. Attempt to still use utf8 when that newer charset does not exist in the client library. At the same time, update libmysql to v2.0 from https://downloads.mariadb.org/client-native/2.0.0/ . See http://www.heidisql.com/forum.php?t=16425

  2. Quote schema and table name in TPGConnection.FetchDbObjects. Fixes empty tables list. See http://www.heidisql.com/forum.php?t=16429

    • 3 days ago (Sat, 27 Sep 14 16:00)
    • Changelog
  3. Fix division by zero crash when SQL server reports an empty string from SELECT SERVERPROPERTY('ProductVersion'). See http://www.heidisql.com/forum.php?t=16369

    • 2 weeks ago (Thu, 18 Sep 14 17:55)
    • Changelog
  4. Ask user to confirm unsafe UPDATEs/DELETEs in query tab before executing. See http://www.heidisql.com/forum.php?t=16315
    TODO: Add checkbox option to turn this on again once having silenced the message box.

    • 2 weeks ago (Tue, 16 Sep 14 21:16)
    • Changelog
  5. Fix displaying "20.14" server version on SQL Server 2014. Try to get more exact version with SELECT SERVERPROPERTY('ProductVersion') on 2008 and newer servers. See http://msdn.microsoft.com/de-de/library/ms174396.aspx .

    • 2 weeks ago (Sat, 13 Sep 14 13:15)
    • Changelog
  6. Fix EStackOverflow in TSynHashEntry.AddEntry when adding too many table names. See http://www.heidisql.com/forum.php?t=16307

    • 3 weeks ago (Wed, 10 Sep 14 20:35)
    • Changelog
  7. Support renaming tables and views on PostgreSQL. See http://www.heidisql.com/forum.php?t=16305

    • 3 weeks ago (Wed, 10 Sep 14 20:20)
    • Changelog
  8. Restrict regular expression in TDBConnection.GetDatatypeByName to very left characters, so it does not detect "ENUM('text','...') DEFAULT 'text'" columns as TEXT type. See http://www.heidisql.com/forum.php?t=16271

    • 4 weeks ago (Thu, 04 Sep 14 18:11)
    • Changelog
  9. Introduce a UNKNOWN data type in PostgreSQL, so we don't fall into a SQL error when opening the data grid with a SUBSTR() call on a non-text column, for example USER-DEFINED/GEOMETRY(POINT).

    • 4 weeks ago (Sun, 31 Aug 14 11:25)
    • Changelog
  10. Fix unsupported AFTER/FIRST clause in ALTER TABLE ADD COLUMN... query on PostgreSQL

    • 1 month ago (Sat, 30 Aug 14 16:30)
    • Changelog
  11. Add support for BOOLEAN column data type in PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16204

    • 1 month ago (Sat, 30 Aug 14 16:15)
    • Changelog
  12. PostgreSQL does not need a LIKE clause tail like MSSQL does.

    • 1 month ago (Tue, 26 Aug 14 20:06)
    • Changelog
  13. Fix UPDATE + DELETE queries in data grid for PostgreSQL, which do not support a LIMIT clause.

    • 1 month ago (Tue, 26 Aug 14 20:04)
    • Changelog
  14. Add support for geometry data types in PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16198

    • 1 month ago (Tue, 26 Aug 14 19:45)
    • Changelog
  15. Introduce TPgConnection.GetCharsetTable, forgotten to implement yet. Fixes a crash in text import dialog.
    * User report: http://www.heidisql.com/forum.php?t=16181
    * Ticket at 2ndquadrant: https://support.2ndquadrant.com/rt/SelfService/Display.html?id=37948

    • 1 month ago (Mon, 25 Aug 14 19:33)
    • Changelog
  16. Support BIT and BIT VARYING data types in PostgreSQL without SQL errors in Data tab. See http://www.heidisql.com/forum.php?t=16072#p16180

    • 1 month ago (Sun, 24 Aug 14 19:24)
    • Changelog
  17. Fix duplicated tables in database view on PostgreSQL. See http://www.heidisql.com/forum.php?t=16179#p16179

    • 1 month ago (Fri, 22 Aug 14 16:56)
    • Changelog
  18. Support data types with spaces in them, for example "DOUBLE PRECISION" on PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16169

    • 1 month ago (Thu, 21 Aug 14 20:14)
    • Changelog
  19. Use SUBSTR() alternative to LEFT() on PostgreSQL table data selection. See http://www.heidisql.com/forum.php?t=16072

    • 1 month ago (Wed, 20 Aug 14 19:26)
    • Changelog
  20. Remove unused variables

    • 1 month ago (Sun, 17 Aug 14 17:08)
    • Changelog
  21. Support older PostgreSQL servers in TPGConnection.FetchDbObjects. See http://www.heidisql.com/forum.php?t=16072#p16138

    • 1 month ago (Sun, 17 Aug 14 12:09)
    • Changelog
  22. Restrict disabling foreign keys to MySQL when dropping objects. See http://www.heidisql.com/forum.php?t=7025#p16142

    • 1 month ago (Sun, 17 Aug 14 12:00)
    • Changelog
  23. * Do not use the "Databases" setting for the db tree, just use it to set the single db name in PostgreSQL mode.
    * Use "postgres" as default db (was "template1")
    * Turn checkable dropdown menu items into radio items in PostgreSQL mode
    See issue #3190 and http://www.heidisql.com/forum.php?t=16072

    • 2 months ago (Sun, 10 Aug 14 18:08)
    • Changelog
  24. Enable foreign keys editor on NDB cluster >= 7.3.x. See http://www.heidisql.com/forum.php?t=16059

    • 2 months ago (Sat, 26 Jul 14 16:29)
    • Changelog
  25. Catch date/time conversion errors in GetDateTimeValue, which happen e.g. when passing an empty date.

    • 2 months ago (Sat, 26 Jul 14 16:14)
    • Changelog
  26. Call GetDateTimeValue for all temporal types on all server versions.

    • 2 months ago (Sat, 26 Jul 14 16:13)
    • Changelog
  27. MSSQL: Return date/time string value as expected by server. See http://www.heidisql.com/forum.php?t=15925

    • 3 months ago (Sat, 12 Jul 14 14:25)
    • Changelog
  28. Avoid inclusion of keys, foreign keys, partition clauses and whatever as additional columns in ParseTableStructure. See http://www.heidisql.com/forum.php?t=15960

    • 3 months ago (Sun, 06 Jul 14 17:06)
    • Changelog
  29. PQPing() is not made to ping an existing connection. Send an empty query instead. Fixes issue #3570.

    • 3 months ago (Sat, 05 Jul 14 11:36)
    • Changelog
  30. Fix detection of column name identifier in ParseTableStructure. Fixes issue #3585.

    • 3 months ago (Sat, 05 Jul 14 11:09)
    • Changelog
  31. Fix SQL error when using "Quick filter" > "More values" in MSSQL and PostgreSQL. Fixes issue #3575.

    • 3 months ago (Thu, 19 Jun 14 07:21)
    • Changelog
  32. Use prettier "Consolas" as default font for TSynMemo editors, when available, as an alternative to the old-stylish "Courier New".

    • 3 months ago (Tue, 17 Jun 14 06:41)
    • Changelog
  33. Last required addition to the double minus comment bugfix. http://www.heidisql.com/forum.php?t=15621

    • 3 months ago (Mon, 16 Jun 14 20:23)
    • Changelog
  34. Try to fix SynEdit's double minus comment bug. http://www.heidisql.com/forum.php?t=15621

    • 3 months ago (Mon, 16 Jun 14 20:13)
    • Changelog
  35. Rename "Cancel" button on update check dialog to "Skip" when displayed right after application start. Fixes issue #3584.

    • 3 months ago (Mon, 16 Jun 14 18:57)
    • Changelog
  36. Add error message when PostgreSQL library procedure was not found.

    • 4 months ago (Sun, 15 Jun 14 20:07)
    • Changelog
  37. Fix truncation of routine body to 4000 characters, as a limitation of nvarchar(4000). See http://www.heidisql.com/forum.php?t=12495 . Fixes issue #3503.

    • 4 months ago (Sun, 15 Jun 14 19:57)
    • Changelog
  38. Fix detection of column names with backticks in them. Should have already been fixed in r4559. Fixes issue #2292, again.

    • 4 months ago (Sat, 14 Jun 14 08:54)
    • Changelog
  39. Solve all missing and wrong DLL issues for 32/64 bit PostgreSQL mode. Fixes issue #3543.

    • 4 months ago (Sun, 08 Jun 14 07:55)
    • Changelog
  40. Optimize previous commit. Filtering the grid causes quite a bit CPU load, so we're now only doing the second search pass for unformatted numbers if the text to find is detected as an unformatted number.

    • 4 months ago (Fri, 06 Jun 14 19:29)
    • Changelog
  41. Support searching for unformatted integers and floats in filter panel. Fixes issue #3574.

    • 4 months ago (Fri, 06 Jun 14 18:03)
    • Changelog
  42. Add a 32bit-only installer, for users who want the 32bit version on a 64bit Windows. See http://www.heidisql.com/forum.php?t=15800

    • 4 months ago (Thu, 05 Jun 14 21:22)
    • Changelog
  43. Increase maximum port number from 2^16-1 (65535) to 2^31-1 (2147483647). Fixes issue #3567.

    • 4 months ago (Tue, 03 Jun 14 08:50)
    • Changelog
  44. Revert accidental changes included in previous commit.

    • 4 months ago (Tue, 27 May 14 15:57)
    • Changelog
  45. mysql_get_server_info() returns "5.5.5-10.0.10-MariaDB". Override that with the "version" server variable, which is more exact here.

    • 4 months ago (Tue, 27 May 14 15:55)
    • Changelog
  46. Detect DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP in column definitions. See http://www.heidisql.com/forum.php?t=15768

    • 4 months ago (Tue, 27 May 14 15:44)
    • Changelog
  47. Rearrange list of contributors

    • 4 months ago (Tue, 27 May 14 15:05)
    • Changelog
  48. Work around access violation in "Fetch database items" when active database is processed. Fixes issue #3559.

    • 4 months ago (Thu, 22 May 14 11:17)
    • Changelog
  49. Activate "Select all" action when it appears in a valid popup menu.

    • 4 months ago (Mon, 19 May 14 15:59)
    • Changelog
  50. Apply treeHelpers.OnChecking event on user created query tabs. Fixes issue #3546.

    • 4 months ago (Mon, 19 May 14 15:41)
    • Changelog
  51. Make SynMemo.OnChange and Timer.OnTimer events of TQueryTab members of it, instead of TMainForm, so we know which tab/memo was analyzed for parameters. Could fix some AV bugs.

    • 4 months ago (Mon, 19 May 14 15:30)
    • Changelog
  52. Run ValidateControls() even when it was executed shortly before, otherwise some actions ("run sql" after query execution for example) won't update. See http://www.heidisql.com/forum.php?t=15651

    • 5 months ago (Sat, 10 May 14 06:16)
    • Changelog
  53. Add "Save as textfile" action, and include that in routine editor > "CREATE code" tab > context menu. Fixes issue #3486.

    • 5 months ago (Thu, 08 May 14 06:50)
    • Changelog
  54. Add "PostgreSQL" to the installer image.

    • 5 months ago (Sun, 04 May 14 07:33)
    • Changelog
  55. Support query timeout on MSSQL and PostgreSQL. Make customizable per up/down scroller in "Advanced" tab of session manager. Fixes issue #3507.

    • 5 months ago (Sun, 04 May 14 07:01)
    • Changelog
  56. Remove "experimental" from MSSQL net types.

    • 5 months ago (Sat, 03 May 14 06:16)
    • Changelog
  57. Revert accidental changes in previous commit

    • 5 months ago (Wed, 23 Apr 14 20:13)
    • Changelog
  58. Fix wrong restored query memo height after restart, due to automatic reduction in FormResize.

    • 5 months ago (Wed, 23 Apr 14 07:12)
    • Changelog
  59. Add call to Query() in SetDatabase() after removing it accidentally in previous commit. See http://www.heidisql.com/forum.php?t=15536

    • 5 months ago (Tue, 22 Apr 14 19:14)
    • Changelog
  60. Make detection of USE query more reliable, and implement it once for all descendants of TDBConnection. See also http://www.heidisql.com/forum.php?t=15530

    • 5 months ago (Tue, 22 Apr 14 16:49)
    • Changelog
  61. Issue #1325: Apply Adriens patch from March 20, modified for code style reasons. Introduces a checkbox in front of the "Bind parameters" node, which makes the detection optional, as it requires quite a bit CPU load.

    • 5 months ago (Tue, 22 Apr 14 06:46)
    • Changelog
  62. Fix missing table alias on MSSQL2K. See http://www.heidisql.com/forum.php?t=15506

    • 5 months ago (Sat, 19 Apr 14 12:24)
    • Changelog
  63. Remove schema prefix from PostgreSQL tables in tree

    • 5 months ago (Sat, 19 Apr 14 08:10)
    • Changelog
  64. Support PostgreSQL in "Find text on server" dialog

    • 5 months ago (Fri, 18 Apr 14 20:55)
    • Changelog
  65. Include required file for PostgreSQL connections in setup routine. Taken from http://slproweb.com/download/Win32OpenSSL_Light-1_0_1g.exe

    • 5 months ago (Thu, 17 Apr 14 15:36)
    • Changelog
  66. Display schemata instead of databases in db tree. See http://code.google.com/p/heidisql/issues/detail?id=3190#c32

    • 5 months ago (Thu, 17 Apr 14 08:29)
    • Changelog
  67. Use hardcoded "template1" database when connecting. There is no connect method using an empty database name. See http://code.google.com/p/heidisql/issues/detail?id=3190#c30

    • 5 months ago (Thu, 17 Apr 14 07:20)
    • Changelog
  68. Add PostgreSQL server icon

    • 6 months ago (Tue, 15 Apr 14 17:46)
    • Changelog
  69. Fix query for getting database names on PostgreSQL

    • 6 months ago (Tue, 15 Apr 14 11:13)
    • Changelog
  70. Add experimental PostgreSQL support, issue #3190. Include 32bit and 64bit dll's in installer.

    • 6 months ago (Tue, 15 Apr 14 08:17)
    • Changelog
  71. Remove debug output, overseen in previous commit

    • 6 months ago (Sun, 06 Apr 14 21:33)
    • Changelog
  72. Fix unsafe try/except logic in TMainform.InitConnection, which relied on Connection.Active being correctly set, where it possibly only throws an exception.

    • 6 months ago (Sun, 06 Apr 14 11:04)
    • Changelog
  73. Disable UNSIGNED and ZEROFILL checkboxes for BIT type columns. See http://www.heidisql.com/forum.php?t=15354

    • 6 months ago (Wed, 02 Apr 14 06:42)
    • Changelog
  74. Remove text from plink message dialog which says one should press "y" or "n", where we have buttons already.

    • 6 months ago (Mon, 31 Mar 14 06:05)
    • Changelog
  75. Remove translation strings which were in deleted plinkremote unit

    • 6 months ago (Sun, 30 Mar 14 07:49)
    • Changelog
  76. Overtake username and hashed password from old user when cloning a user. See http://www.heidisql.com/forum.php?t=8943

    • 6 months ago (Sun, 30 Mar 14 07:31)
    • Changelog
  77. Rewrite plink.exe process handling: Create our own class TPlink, which needs to be called with a .Connect method and raises an exception when some error occurs. Fixes issue #2902. See also: http://www.heidisql.com/forum.php?t=15224

    • 6 months ago (Sat, 29 Mar 14 07:57)
    • Changelog
  78. Fix forced lowercase in case sensitive search on MSSQL

    • 6 months ago (Fri, 28 Mar 14 10:18)
    • Changelog
  79. Make search on server more compatible to MSSQL: Remove LOWER() call, which fails on TEXT fields and is not even required. And add an equivalent to MySQL's BINARY search. See http://www.heidisql.com/forum.php?t=14950

    • 6 months ago (Fri, 28 Mar 14 07:02)
    • Changelog
  80. Support "Find text on server" dialog on MSSQL. See http://www.heidisql.com/forum.php?t=14950

    • 6 months ago (Thu, 27 Mar 14 05:41)
    • Changelog
  81. Fix compiler warnings due to usage of deprecated AnsiStrings functions

    • 6 months ago (Tue, 25 Mar 14 11:19)
    • Changelog
  82. Fix compiler error from previous commit.

    • 6 months ago (Tue, 25 Mar 14 11:16)
    • Changelog
  83. Localize messages in PlinkRemote unit.

    • 6 months ago (Tue, 25 Mar 14 11:13)
    • Changelog
  84. Add Plinkremote unit as a preparation for a better integration of plink.exe into our SSH tunnel.
    See
    * http://www.delphipraxis.net/70989-komponente-fuer-ssh-verbindung-6.html
    * http://www.heidisql.com/forum.php?t=15206
    * issue #2902

    • 6 months ago (Tue, 25 Mar 14 10:43)
    • Changelog
  85. Get path to cmd.exe via COMSPEC environment variable. See http://www.heidisql.com/forum.php?t=15206

    • 6 months ago (Sun, 23 Mar 14 16:37)
    • Changelog
  86. Do not show hint with same text as on tab caption. See issue #3528.

    • 6 months ago (Sun, 23 Mar 14 06:33)
    • Changelog
  87. Try to automatically pipe a "y" to plink.exe, to auto accept unknown host keys. See http://www.heidisql.com/forum.php?t=15224

    • 6 months ago (Sat, 22 Mar 14 06:35)
    • Changelog
  88. Support disabling SQL hints on result tabs, in Tools > Preferences > Data appearance. Fixes issue #3528.

    • 6 months ago (Fri, 21 Mar 14 05:59)
    • Changelog
  89. Support changing active result tab per shortcut, Alt+Left and Alt+Right. See http://www.heidisql.com/forum.php?t=7609

    • 6 months ago (Wed, 19 Mar 14 11:27)
    • Changelog
  90. Migrate email address to @heidisql.com

    • 7 months ago (Sat, 15 Mar 14 17:03)
    • Changelog
  91. Display filename with path in query tab hint. Fixes issue #3527.

    • 7 months ago (Sat, 15 Mar 14 07:36)
    • Changelog
  92. Uncheck unwanted databases on databases drop down menu when text was manually edited. Fixes checked items which should be unchecked.

    • 7 months ago (Sat, 15 Mar 14 06:13)
    • Changelog
  93. Clear partitions tab when creating new table.

    • 7 months ago (Thu, 13 Mar 14 19:35)
    • Changelog
  94. Move new partitions tab to the left of "Create code"

    • 7 months ago (Thu, 13 Mar 14 19:32)
    • Changelog
  95. Add a read-only tab for a potentially existing PARTITION clause of the table. Fixes issue #1692.

    • 7 months ago (Thu, 13 Mar 14 05:58)
    • Changelog
  96. Windows.GetCommandLine provides two spaces between exename and first parameter, only on Win7, but not on WinXP. The two on Win7 were cut to one, and the one on XP was cut to 0, where the regex required a mandatory space. See http://www.heidisql.com/forum.php?t=15082

    • 7 months ago (Tue, 11 Mar 14 05:00)
    • Changelog
  97. Auto-uppercase data types of routine parameters. Fixes issue #3497.

    • 7 months ago (Mon, 10 Mar 14 05:01)
    • Changelog
  98. Fix crash after tabbing from the last node on "Database" tab in edit mode. Fixes issue #3526.

    • 7 months ago (Sun, 09 Mar 14 21:22)
    • Changelog
  99. Move code from helpers.GetColumnDefaultClause into dbconnection.TTableColumn.SQLCode. Support microseconds part in DEFAULT CURRENT_TIMESTAMP clause. Fixes issue #3506.

    • 7 months ago (Sun, 09 Mar 14 05:08)
    • Changelog
  100. Allow disabling the creation of start menu icons in the installer. Fixes issue #3510.

    • 7 months ago (Sat, 08 Mar 14 05:03)
    • Changelog