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. Activate "Clear filter" button after applying text to filter memo. See http://www.heidisql.com/forum.php?t=17154

    Committed: 10 hours ago (Thu, 18 Dec 14 11:01)

  2. 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: 2 weeks ago (Mon, 01 Dec 14 20:26)

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

    Committed: 2 weeks ago (Mon, 01 Dec 14 20:16)

  4. 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: 4 weeks ago (Sun, 23 Nov 14 14:40)

  5. Add missing Idle event in main unit

    Committed: 4 weeks ago (Sat, 22 Nov 14 20:52)

  6. Fix missing Idle event in ApplicationEvents module

    Committed: 4 weeks ago (Sat, 22 Nov 14 20:48)

  7. Change button caption from time to time

    Committed: 4 weeks ago (Sat, 22 Nov 14 20:29)

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

    Committed: 1 month ago (Mon, 17 Nov 14 19:01)

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

    Committed: 1 month ago (Fri, 14 Nov 14 21:33)

  10. 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: 1 month ago (Fri, 14 Nov 14 18:09)

  11. 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: 1 month ago (Thu, 13 Nov 14 19:55)

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

    Committed: 1 month ago (Thu, 13 Nov 14 19:47)

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

    Committed: 1 month ago (Thu, 13 Nov 14 19:41)

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

    Committed: 1 month ago (Thu, 13 Nov 14 19:06)

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

    Committed: 1 month ago (Thu, 13 Nov 14 18:21)

  16. 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: 1 month ago (Tue, 11 Nov 14 21:53)

  17. Prepare upcoming 9.1 release

    Committed: 1 month ago (Tue, 11 Nov 14 20:35)

  18. 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: 1 month ago (Tue, 11 Nov 14 20:35)

  19. Prepare upcoming 9.0 release

    Committed: 1 month ago (Mon, 10 Nov 14 17:53)

  20. Update logo in about dialog with shadow

    Committed: 1 month ago (Mon, 10 Nov 14 17:43)

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

    Committed: 1 month ago (Sun, 09 Nov 14 18:35)

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

    Committed: 1 month ago (Sun, 09 Nov 14 13:00)

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

    Committed: 1 month ago (Sun, 09 Nov 14 11:29)

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

    Committed: 1 month ago (Sat, 08 Nov 14 16:07)

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

    Committed: 1 month ago (Sat, 08 Nov 14 15:57)

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

    Committed: 1 month ago (Sat, 08 Nov 14 15:28)

  27. 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: 2 months ago (Sun, 02 Nov 14 19:55)

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

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

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

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

  30. 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: 2 months ago (Sat, 01 Nov 14 13:53)

  31. Remove unused variable

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  39. 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: 2 months ago (Fri, 24 Oct 14 19:53)

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

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

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

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

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

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

  43. Fix typos

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

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

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

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

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

  46. 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: 2 months ago (Thu, 16 Oct 14 20:50)

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

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

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

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

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

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

  50. Update year of copyright

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

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

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

  52. Remove unused variable

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

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

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

  54. Enhance translation hints

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

  55. Fix wrong comment

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

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

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

  57. 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: 2 months ago (Sat, 04 Oct 14 18:10)

  58. Overseen file for previous commit

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

  59. 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: 3 months ago (Fri, 03 Oct 14 14:22)

  60. Enhance translation hint

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

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

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

  62. 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: 3 months ago (Mon, 29 Sep 14 20:48)

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

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

  64. 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: 3 months ago (Thu, 18 Sep 14 17:55)

  65. 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: 3 months ago (Tue, 16 Sep 14 21:16)

  66. 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: 3 months ago (Sat, 13 Sep 14 13:15)

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

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

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

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

  69. 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: 3 months ago (Thu, 04 Sep 14 18:11)

  70. 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: 4 months ago (Sun, 31 Aug 14 11:25)

  71. Fix unsupported AFTER/FIRST clause in ALTER TABLE ADD COLUMN... query on PostgreSQL

    Committed: 4 months ago (Sat, 30 Aug 14 16:30)

  72. Add support for BOOLEAN column data type in PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16204

    Committed: 4 months ago (Sat, 30 Aug 14 16:15)

  73. PostgreSQL does not need a LIKE clause tail like MSSQL does.

    Committed: 4 months ago (Tue, 26 Aug 14 20:06)

  74. Fix UPDATE + DELETE queries in data grid for PostgreSQL, which do not support a LIMIT clause.

    Committed: 4 months ago (Tue, 26 Aug 14 20:04)

  75. Add support for geometry data types in PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16198

    Committed: 4 months ago (Tue, 26 Aug 14 19:45)

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

    Committed: 4 months ago (Mon, 25 Aug 14 19:33)

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

    Committed: 4 months ago (Sun, 24 Aug 14 19:24)

  78. Fix duplicated tables in database view on PostgreSQL. See http://www.heidisql.com/forum.php?t=16179#p16179

    Committed: 4 months ago (Fri, 22 Aug 14 16:56)

  79. Support data types with spaces in them, for example "DOUBLE PRECISION" on PostgreSQL. See http://www.heidisql.com/forum.php?t=16072#p16169

    Committed: 4 months ago (Thu, 21 Aug 14 20:14)

  80. Use SUBSTR() alternative to LEFT() on PostgreSQL table data selection. See http://www.heidisql.com/forum.php?t=16072

    Committed: 4 months ago (Wed, 20 Aug 14 19:26)

  81. Remove unused variables

    Committed: 4 months ago (Sun, 17 Aug 14 17:08)

  82. Support older PostgreSQL servers in TPGConnection.FetchDbObjects. See http://www.heidisql.com/forum.php?t=16072#p16138

    Committed: 4 months ago (Sun, 17 Aug 14 12:09)

  83. Restrict disabling foreign keys to MySQL when dropping objects. See http://www.heidisql.com/forum.php?t=7025#p16142

    Committed: 4 months ago (Sun, 17 Aug 14 12:00)

  84. * 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

    Committed: 4 months ago (Sun, 10 Aug 14 18:08)

  85. Enable foreign keys editor on NDB cluster >= 7.3.x. See http://www.heidisql.com/forum.php?t=16059

    Committed: 5 months ago (Sat, 26 Jul 14 16:29)

  86. Catch date/time conversion errors in GetDateTimeValue, which happen e.g. when passing an empty date.

    Committed: 5 months ago (Sat, 26 Jul 14 16:14)

  87. Call GetDateTimeValue for all temporal types on all server versions.

    Committed: 5 months ago (Sat, 26 Jul 14 16:13)

  88. MSSQL: Return date/time string value as expected by server. See http://www.heidisql.com/forum.php?t=15925

    Committed: 5 months ago (Sat, 12 Jul 14 14:25)

  89. Avoid inclusion of keys, foreign keys, partition clauses and whatever as additional columns in ParseTableStructure. See http://www.heidisql.com/forum.php?t=15960

    Committed: 5 months ago (Sun, 06 Jul 14 17:06)

  90. PQPing() is not made to ping an existing connection. Send an empty query instead. Fixes issue #3570.

    Committed: 5 months ago (Sat, 05 Jul 14 11:36)

  91. Fix detection of column name identifier in ParseTableStructure. Fixes issue #3585.

    Committed: 5 months ago (Sat, 05 Jul 14 11:09)

  92. Fix SQL error when using "Quick filter" > "More values" in MSSQL and PostgreSQL. Fixes issue #3575.

    Committed: 6 months ago (Thu, 19 Jun 14 07:21)

  93. Use prettier "Consolas" as default font for TSynMemo editors, when available, as an alternative to the old-stylish "Courier New".

    Committed: 6 months ago (Tue, 17 Jun 14 06:41)

  94. Last required addition to the double minus comment bugfix. http://www.heidisql.com/forum.php?t=15621

    Committed: 6 months ago (Mon, 16 Jun 14 20:23)

  95. Try to fix SynEdit's double minus comment bug. http://www.heidisql.com/forum.php?t=15621

    Committed: 6 months ago (Mon, 16 Jun 14 20:13)

  96. Rename "Cancel" button on update check dialog to "Skip" when displayed right after application start. Fixes issue #3584.

    Committed: 6 months ago (Mon, 16 Jun 14 18:57)

  97. Add error message when PostgreSQL library procedure was not found.

    Committed: 6 months ago (Sun, 15 Jun 14 20:07)

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

    Committed: 6 months ago (Sun, 15 Jun 14 19:57)

  99. Fix detection of column names with backticks in them. Should have already been fixed in r4559. Fixes issue #2292, again.

    Committed: 6 months ago (Sat, 14 Jun 14 08:54)

  100. Solve all missing and wrong DLL issues for 32/64 bit PostgreSQL mode. Fixes issue #3543.

    Committed: 6 months ago (Sun, 08 Jun 14 07:55)