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

Download HeidiSQL 9.1 (11 Nov 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.

  1. * Fix microseconds in MSSQL date/time data types, hidden in data and query grids.
    * Add support for microsecond precision of MSSQL date/time types in table editor, show these in "Length/Set" column
    * See http://www.heidisql.com/forum.php?t=17728

    Committed: 1 day ago (Sun, 01 Mar 15 19:21)

  2. Use ISO 8601 date/time format on MSSQL. See http://www.heidisql.com/forum.php?t=17728

    Committed: 3 days ago (Sat, 28 Feb 15 11:52)

  3. Add a help button to the quite non-intuitive controls on the export dialog.

    Committed: 1 week ago (Mon, 23 Feb 15 20:59)

  4. PostgreSQL: Fix wrong order of columns shown in indexes, and show normal indexes also. See http://www.heidisql.com/forum.php?t=17865

    Committed: 1 week ago (Mon, 23 Feb 15 20:43)

  5. Only make first part of data type to uppercase, not the part in parentheses. See http://www.heidisql.com/forum.php?t=17845

    Committed: 1 week ago (Sun, 22 Feb 15 18:06)

  6. Missing translation for update button on main toolbar

    Committed: 2 weeks ago (Mon, 16 Feb 15 20:06)

  7. Fix crash when right-clicking a database, following by a click on "Drop". See http://www.heidisql.com/forum.php?t=13004

    Committed: 2 weeks ago (Sun, 15 Feb 15 20:12)

  8. Version conditional disabling for menu items in MySQL mode only. See http://www.heidisql.com/forum.php?t=17794

    Committed: 2 weeks ago (Sat, 14 Feb 15 13:30)

  9. TEXT data type has a maximum length of 65k for MySQL only. Introduce other values for MSSQL and PostgreSQL. See http://www.heidisql.com/forum.php?t=17747

    Committed: 3 weeks ago (Wed, 11 Feb 15 20:29)

  10. Support JSON data type on PostgreSQL. See http://www.heidisql.com/forum.php?t=17584

    Committed: 4 weeks ago (Thu, 05 Feb 15 20:18)

  11. Revert previous commit. Disabling foreign key checks while deleting rows leaves orphaned rows in foreign tables. Other solution to be discussed.

    Committed: 1 month ago (Fri, 30 Jan 15 15:39)

  12. Disable foreign key checks while truncating tables. See http://www.heidisql.com/forum.php?t=17587

    Committed: 1 month ago (Thu, 29 Jan 15 20:41)

  13. Increase various default values for window dimensions, for reasonable look and feel for new users.

    Committed: 1 month ago (Wed, 28 Jan 15 20:12)

  14. Add support for MSSQL data type HIERARCHYID. See http://www.heidisql.com/forum.php?t=17575

    Committed: 1 month ago (Wed, 28 Jan 15 19:56)

  15. Add "Rename" context menu item in session tree. See http://www.heidisql.com/forum.php?t=17557

    Committed: 1 month ago (Sun, 25 Jan 15 12:38)

  16. Use local number formatting in grids by default

    Committed: 1 month ago (Sat, 17 Jan 15 17:41)

  17. Use transparent background for NULL cells by default

    Committed: 1 month ago (Sat, 17 Jan 15 17:41)

  18. Fix memory leak in TfrmTableTools.SaveSettings

    Committed: 2 months ago (Fri, 09 Jan 15 11:25)

  19. ExtractLiteral deletes required characters from input string. Don't delete more from a regex detection. Broken in r4893. See http://www.heidisql.com/forum.php?t=17399

    Committed: 2 months ago (Thu, 08 Jan 15 15:05)

  20. Add edit box + updown buttons for limiting the size of INSERT queries in bytes. See http://www.heidisql.com/forum.php?t=17345

    Committed: 2 months ago (Mon, 05 Jan 15 20:32)

  21. Support columns with a string literal as default value plus an ON UPDATE CURRENT_TIMESTAMP clause. See http://www.heidisql.com/forum.php?t=17323

    Committed: 2 months ago (Mon, 05 Jan 15 19:51)

  22. MSSQL: More compatibility when getting procedure body. See http://www.heidisql.com/forum.php?t=17314

    Committed: 2 months ago (Sun, 04 Jan 15 17:13)

  23. Display creation time, last alter time, comment and start time of scheduled events. See http://www.heidisql.com/forum.php?t=17321

    Committed: 2 months ago (Fri, 02 Jan 15 18:47)

  24. Remove duplicates from recent file list pulldown. See http://www.heidisql.com/forum.php?t=17331

    Committed: 2 months ago (Fri, 02 Jan 15 18:25)

  25. Translate connected/disconnected words in status bar

    Committed: 2 months ago (Fri, 02 Jan 15 11:40)

  26. Add component name to image link

    Committed: 2 months ago (Thu, 01 Jan 15 19:03)

  27. Set focus on filter box when SQL help dialog opens. See http://www.heidisql.com/forum.php?t=17294

    Committed: 2 months ago (Thu, 01 Jan 15 18:41)

  28. Update gettext unit to r71 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas

    Committed: 2 months ago (Mon, 29 Dec 14 20:02)

  29. Fix some compiler hints

    Committed: 2 months ago (Mon, 29 Dec 14 19:54)

  30. Make search/replace dialog resizable

    Committed: 2 months ago (Sat, 27 Dec 14 19:39)

  31. Activate "Clear filter" button after applying text to filter memo. See http://www.heidisql.com/forum.php?t=17154

    Committed: 2 months ago (Thu, 18 Dec 14 11:01)

  32. Gracefully remove superfluous WHERE keyword from data grid filter, so other places like the previously modified "More filters" menu do not add a second WHERE.

    Committed: 3 months ago (Mon, 01 Dec 14 20:26)

  33. Use existing data grid WHERE filter to filter values from quick filter > "More values". See http://www.heidisql.com/forum.php?t=17086

    Committed: 3 months ago (Mon, 01 Dec 14 20:16)

  34. PostgreSQL: Let longer data type matches win over shorter ones, in TDBConnection.GetDatatypeByName. Important e.g. for CHARACTER and CHARACTER VARYING. See http://www.heidisql.com/forum.php?t=17061

    Committed: 3 months ago (Sun, 23 Nov 14 14:40)

  35. Add missing Idle event in main unit

    Committed: 3 months ago (Sat, 22 Nov 14 20:52)

  36. Fix missing Idle event in ApplicationEvents module

    Committed: 3 months ago (Sat, 22 Nov 14 20:48)

  37. Change button caption from time to time

    Committed: 3 months ago (Sat, 22 Nov 14 20:29)

  38. PostgreSQL: Make TPGConnection.FetchDbObjects compatible to pre-9.0 servers. See http://www.heidisql.com/forum.php?t=16996

    Committed: 3 months ago (Mon, 17 Nov 14 19:01)

  39. Remove outdated details in readme file, and redirect to official help page instead.

    Committed: 4 months ago (Fri, 14 Nov 14 21:33)

  40. Fix non working addition of new columns in MySQL. See http://www.heidisql.com/forum.php?t=16948
    PostgreSQL: Detect all array style types as unknown type, e.g. TEXT[].

    Committed: 4 months ago (Fri, 14 Nov 14 18:09)

  41. PostgreSQL:
    * Detect xid type (oid 28) as integer.
    * Detect character type (oid 1042) as char, not varchar.
    * Detect aclitem[] type (oid 1034) as unknown, not text.

    Committed: 4 months ago (Thu, 13 Nov 14 19:55)

  42. PostgreSQL: Log oid of table columns in TDBConnection.GetCreateCode.

    Committed: 4 months ago (Thu, 13 Nov 14 19:47)

  43. Pass column or argument name to NativeToNamedColumnType(), as a hint for the user.

    Committed: 4 months ago (Thu, 13 Nov 14 19:41)

  44. PostgreSQL: Support quoted datatypes in TDBConnection.GetDatatypeByName, coming from TDBConnection.ParseTableStructure.

    Committed: 4 months ago (Thu, 13 Nov 14 19:06)

  45. Fix detection of PostgreSQL data type INTERVAL as VARCHAR. See http://www.heidisql.com/forum.php?t=16760

    Committed: 4 months ago (Thu, 13 Nov 14 18:21)

  46. Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...). See http://www.heidisql.com/forum.php?t=16891

    Committed: 4 months ago (Tue, 11 Nov 14 21:53)

  47. Prepare upcoming 9.1 release

    Committed: 4 months ago (Tue, 11 Nov 14 20:35)

  48. Downgrade libmysql to the one from MySQL 5.6.6, in order to have the secure_auth option disabled by default. I can't get MYSQL_SECURE_AUTH disabled for some reason. See http://www.heidisql.com/forum.php?t=16858#p16893 . However, we have still utf8mb4 support (since 5.5.3)

    Committed: 4 months ago (Tue, 11 Nov 14 20:35)

  49. Prepare upcoming 9.0 release

    Committed: 4 months ago (Mon, 10 Nov 14 17:53)

  50. Update logo in about dialog with shadow

    Committed: 4 months ago (Mon, 10 Nov 14 17:43)

  51. Add a 128px version in the main icon.

    Committed: 4 months ago (Sun, 09 Nov 14 18:35)

  52. Open new help page on "Help" buttons of the various object editors.

    Committed: 4 months ago (Sun, 09 Nov 14 13:00)

  53. Add 64px and 256px versions to main icon. See http://www.heidisql.com/forum.php?t=16814

    Committed: 4 months ago (Sun, 09 Nov 14 11:29)

  54. Add "view changelog" button to updatecheck dialog.

    Committed: 4 months ago (Sat, 08 Nov 14 16:07)

  55. Also display download page when clicking the "download release" button in update dialog.

    Committed: 4 months ago (Sat, 08 Nov 14 15:57)

  56. Add "check/uncheck all" button to column selector in textfile import dialog. See http://www.heidisql.com/forum.php?t=13566

    Committed: 4 months ago (Sat, 08 Nov 14 15:28)

  57. Fix detection of DEFAULT value in CREATE TABLE code of MS SQL tables, which is wrapped in parentheses. See http://www.heidisql.com/forum.php?t=16748

    Committed: 4 months ago (Sun, 02 Nov 14 19:55)

  58. Allow applying CURRENT_TIMESTAMP to DATETIME columns. See http://www.heidisql.com/forum.php?t=16715

    Committed: 4 months ago (Sun, 02 Nov 14 14:33)

  59. Sort columns by attnum. Fixes wrong order of column names in data grid. See http://www.heidisql.com/forum.php?t=16747

    Committed: 4 months ago (Sun, 02 Nov 14 13:55)

  60. Fix sql error(2007) Malformed packet, happening on MariaDB-versions of libmysql. Prefer MySQL 5.6.21 versions now. See http://www.heidisql.com/forum.php?t=13454

    Committed: 4 months ago (Sat, 01 Nov 14 13:53)

  61. Remove unused variable

    Committed: 4 months ago (Sat, 01 Nov 14 13:10)

  62. Bugfix: Remember currently checked items when clicking "Sort alphabetically", or when filter is active

    Committed: 4 months ago (Fri, 31 Oct 14 17:55)

  63. Remove obsolete readme file, now online at http://www.heidisql.com/help.php

    Committed: 4 months ago (Tue, 28 Oct 14 20:34)

  64. Add missing TDBConnection.IsPostgreSQL method, used in previous commit.

    Committed: 4 months ago (Mon, 27 Oct 14 20:49)

  65. PostgreSQL, table editor: Retrieve columns from pg_attribute, to get the column comments. Also support applying a comment on new and existing columns.

    Committed: 4 months ago (Mon, 27 Oct 14 20:42)

  66. Add support for MSSQL datetime2 column type. See http://www.heidisql.com/forum.php?t=16708

    Committed: 4 months ago (Sun, 26 Oct 14 12:38)

  67. Detect PostgreSQL column types #26 (oid) and #28 (xid) as integers

    Committed: 4 months ago (Sun, 26 Oct 14 12:00)

  68. Introduce handling of stored functions in PostgreSQL: Displays functions in database browser, enables function editor and "run routine" button with argument handling.

    Committed: 4 months ago (Sun, 26 Oct 14 11:39)

  69. PostgreSQL: Query pg_constraint + pg_attribute instead of IS.TABLE_CONSTRAINTS + IS.KEY_COLUMN_USAGE for keys and their column names. See http://www.heidisql.com/forum.php?t=16213

    Committed: 4 months ago (Fri, 24 Oct 14 19:53)

  70. Prefer pg_catalog tables in TDBConnection.GetCreateCode. See http://www.heidisql.com/forum.php?t=16213#p16685

    Committed: 4 months ago (Tue, 21 Oct 14 20:23)

  71. MSSQL: Return float values as expected by server. See http://www.heidisql.com/forum.php?t=16661

    Committed: 4 months ago (Sun, 19 Oct 14 13:00)

  72. Keep compatibility with older MySQL servers when getting a trigger's CREATE CODE. See here: http://www.heidisql.com/forum.php?t=16662

    Committed: 4 months ago (Sun, 19 Oct 14 12:07)

  73. Fix typos

    Committed: 4 months ago (Sun, 19 Oct 14 11:45)

  74. Query pg_namespace table for getting all schemata instead of is.schemata. See http://www.heidisql.com/forum.php?t=16213

    Committed: 4 months ago (Fri, 17 Oct 14 09:51)

  75. Support DEFAULT clause in PostgreSQL table structure. See http://www.heidisql.com/forum.php?t=16622

    Committed: 5 months ago (Thu, 16 Oct 14 20:51)

  76. Make overloaded TDBConnection.IsNull(String) case insensitive for column names. Important for IS queries, which have uppercase column names in MySQL, and lowercase names in PostgreSQL.

    Committed: 5 months ago (Thu, 16 Oct 14 20:50)

  77. Restrict column reordering to MySQL only. Not supported by MSSQL and PostgreSQL. See http://www.heidisql.com/forum.php?t=16328

    Committed: 5 months ago (Thu, 16 Oct 14 20:09)

  78. Call more useful online help by "Help" button on table editor

    Committed: 5 months ago (Thu, 16 Oct 14 14:27)

  79. Unify help calls in helpers.Help(), and pass sending control for "place" parameter in help url.

    Committed: 5 months ago (Thu, 16 Oct 14 10:02)

  80. Update year of copyright

    Committed: 5 months ago (Tue, 14 Oct 14 19:58)

  81. Turn readme.txt into a more comprehensive online help document

    Committed: 5 months ago (Mon, 13 Oct 14 20:49)

  82. Remove unused variable

    Committed: 5 months ago (Thu, 09 Oct 14 19:18)

  83. Add filter textbox to column selector in "Data" tab

    Committed: 5 months ago (Thu, 09 Oct 14 19:14)

  84. Enhance translation hints

    Committed: 5 months ago (Wed, 08 Oct 14 21:49)

  85. Fix wrong comment

    Committed: 5 months ago (Mon, 06 Oct 14 18:59)

  86. Include SQL_TABLE_VALUED_FUNCTION's in MSSQL object browsing. See http://www.heidisql.com/forum.php?t=16493

    Committed: 5 months ago (Mon, 06 Oct 14 18:58)

  87. Update libmysql again to those from the MariaDB 10.0.14 package. Probably fixes a connection latency, described in http://www.heidisql.com/forum.php?t=16425

    Committed: 5 months ago (Sat, 04 Oct 14 18:10)

  88. Overseen file for previous commit

    Committed: 5 months ago (Fri, 03 Oct 14 14:40)

  89. Get trigger code from SHOW CREATE TRIGGER instead of using SHOW TRIGGERS, to fix a single quote escaping bug. See http://www.heidisql.com/forum.php?t=16501

    Committed: 5 months ago (Fri, 03 Oct 14 14:22)

  90. Enhance translation hint

    Committed: 5 months ago (Fri, 03 Oct 14 12:00)

  91. Support query cancel button on PostgreSQL. See http://www.heidisql.com/forum.php?t=16402

    Committed: 5 months ago (Thu, 02 Oct 14 20:13)

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

    Committed: 5 months ago (Mon, 29 Sep 14 20:48)

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

    Committed: 5 months ago (Sat, 27 Sep 14 16:00)

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

    Committed: 5 months ago (Thu, 18 Sep 14 17:55)

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

    Committed: 5 months ago (Tue, 16 Sep 14 21:16)

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

    Committed: 6 months ago (Sat, 13 Sep 14 13:15)

  97. Fix EStackOverflow in TSynHashEntry.AddEntry when adding too many table names. See http://www.heidisql.com/forum.php?t=16307

    Committed: 6 months ago (Wed, 10 Sep 14 20:35)

  98. Support renaming tables and views on PostgreSQL. See http://www.heidisql.com/forum.php?t=16305

    Committed: 6 months ago (Wed, 10 Sep 14 20:20)

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

    Committed: 6 months ago (Thu, 04 Sep 14 18:11)

  100. 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).

    Committed: 6 months ago (Sun, 31 Aug 14 11:25)