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. Outsource RowCount into TDBObject which calls TDBConnection.GetRowCount with a server and version specific query. Introduce SELECT COUNT(*) for MSSQL 2000.
    See
    * http://www.heidisql.com/forum.php?t=18158
    * http://www.heidisql.com/forum.php?t=15438

    Committed: 3 days ago (Sat, 18 Apr 15 10:12)

  2. Azure support:
    * Add text from @@VERSION value into FServerVersionUntouched so TConnectionParameters.IsAzure can see "Azure" in it.
    * Do not bypass required (!) USE query when IsAzure was detected
    * Display a special MS Azure icon in the tree and in the status bar

    Committed: 2 weeks ago (Tue, 07 Apr 15 18:37)

  3. Basic implementation of Markdown Here grid export option. See http://www.heidisql.com/forum.php?t=16483

    Committed: 2 weeks ago (Mon, 06 Apr 15 22:00)

  4. Attempt to add support for MS SQL Azure, by a) passing the database name(s) into the ADO connection string, and b) bypassing the USE <dbname> query in TDBConnection.SetDatabase(). See http://www.heidisql.com/forum.php?t=17999

    Committed: 2 weeks ago (Sat, 04 Apr 15 18:56)

  5. Fix glitch in variable value editor dialog

    Committed: 2 weeks ago (Sat, 04 Apr 15 15:20)

  6. Phrasing enhancement: "Enable completion proposal" => "Enable autocompletion"

    Committed: 2 weeks ago (Fri, 03 Apr 15 22:00)

  7. Phrasing enhancement:
    * "Data editing" => "Editor configuration"
    * "Remember filters, sorting and column selection across sessions" => "Reuse previous configuration settings on restart"
    * "Drop down values from foreign table in InnoDB rows" => "Show values in foreign key columns"

    Committed: 3 weeks ago (Thu, 02 Apr 15 19:24)

  8. Phrasing enhancement:
    * "Data appearance" => "Text formatting"
    * "Maximum column-width..." => "Maximum column width..."

    Committed: 3 weeks ago (Thu, 02 Apr 15 19:09)

  9. Phrasing enhancement: "User fired SQL queries" => "User-generated SQL queries"

    Committed: 3 weeks ago (Thu, 02 Apr 15 19:00)

  10. Log plink.exe command line as information on SSH tunnel initialization

    Committed: 3 weeks ago (Thu, 02 Apr 15 12:17)

  11. Check whether column can be null, for composing a CREATE TABLE statement. Otherwise, leave away DEFAULT clause. See http://www.heidisql.com/forum.php?t=18055

    Committed: 3 weeks ago (Thu, 02 Apr 15 12:10)

  12. Translate all remaining menu items in Data > "Insert value" submenu

    Committed: 3 weeks ago (Thu, 02 Apr 15 11:54)

  13. Add menu item to insert a GUID without braces. See http://www.heidisql.com/forum.php?t=18058

    Committed: 3 weeks ago (Thu, 02 Apr 15 11:45)

  14. Translation enhancement: Use already translated words in longer sentences which refer to tabs in the preferences dialog.

    Committed: 3 weeks ago (Tue, 31 Mar 15 11:15)

  15. Phrasing enhancement: "Miscellaneous" => "General"

    Committed: 3 weeks ago (Tue, 31 Mar 15 10:59)

  16. Phrasing enhancement: "Factory defaults" => "Restore defaults"

    Committed: 3 weeks ago (Tue, 31 Mar 15 10:43)

  17. Attempt to fix query for detecting table indexes on PostgreSQL. See http://www.heidisql.com/forum.php?t=17747

    Committed: 4 weeks ago (Wed, 25 Mar 15 21:39)

  18. Follow up to previous commit: Use int64 compatible string to integer conversion for data_length and index_length.

    Committed: 4 weeks ago (Wed, 25 Mar 15 21:26)

  19. PostgreSQL: Cast result of pg_table_size() and pg_relation_size() to bigint, so size bars are displayed correctly. See http://www.heidisql.com/forum.php?t=17959

    Committed: 4 weeks ago (Wed, 25 Mar 15 19:50)

  20. SUBSTR() in PostgreSQL seems 1-based, not 0-based. Fixes non-working TDBQuery.EnsureFullRow and TDBQuery.HasFullData. See http://www.heidisql.com/forum.php?t=17747

    Committed: 4 weeks ago (Tue, 24 Mar 15 20:17)

  21. Cast reltuples column to bigint so it does not return a float with an exponent. See http://www.heidisql.com/forum.php?t=17959

    Committed: 1 month ago (Thu, 19 Mar 15 18:47)

  22. Optimize query for getting total row count from PostgreSQL table. See http://www.heidisql.com/forum.php?t=17959

    Committed: 1 month ago (Tue, 17 Mar 15 19:53)

  23. Not sure why this file shows up with a modification, but here we go.

    Committed: 1 month ago (Mon, 16 Mar 15 20:31)

  24. Update webviewer:revision and bugtraq:url properties to point to Sourceforge

    Committed: 1 month ago (Mon, 16 Mar 15 20:20)

  25. Auto-magic modifications on updater project file

    Committed: 1 month ago (Mon, 16 Mar 15 19:57)

  26. Remove defined but unused variable

    Committed: 1 month ago (Sun, 15 Mar 15 16:53)

  27. Update copyright in license file

    Committed: 1 month ago (Sun, 15 Mar 15 16:43)

  28. Move code repository from Google Code back to Sourceforge.

    Committed: 1 month ago (Sun, 15 Mar 15 14:03)

  29. * 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: 2 months ago (Sun, 01 Mar 15 19:21)

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

    Committed: 2 months ago (Sat, 28 Feb 15 11:52)

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

    Committed: 2 months ago (Mon, 23 Feb 15 20:59)

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

    Committed: 2 months ago (Mon, 23 Feb 15 20:43)

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

    Committed: 2 months ago (Sun, 22 Feb 15 18:06)

  34. Missing translation for update button on main toolbar

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

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

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

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

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

  37. 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: 2 months ago (Wed, 11 Feb 15 20:29)

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

    Committed: 2 months ago (Thu, 05 Feb 15 20:18)

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

    Committed: 3 months ago (Fri, 30 Jan 15 15:39)

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

    Committed: 3 months ago (Thu, 29 Jan 15 20:41)

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

    Committed: 3 months ago (Wed, 28 Jan 15 20:12)

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

    Committed: 3 months ago (Wed, 28 Jan 15 19:56)

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

    Committed: 3 months ago (Sun, 25 Jan 15 12:38)

  44. Use local number formatting in grids by default

    Committed: 3 months ago (Sat, 17 Jan 15 17:41)

  45. Use transparent background for NULL cells by default

    Committed: 3 months ago (Sat, 17 Jan 15 17:41)

  46. Fix memory leak in TfrmTableTools.SaveSettings

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

  47. 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: 3 months ago (Thu, 08 Jan 15 15:05)

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

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

  49. 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: 3 months ago (Mon, 05 Jan 15 19:51)

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

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

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

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

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

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

  53. Translate connected/disconnected words in status bar

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

  54. Add component name to image link

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

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

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

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

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

  57. Fix some compiler hints

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

  58. Make search/replace dialog resizable

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

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

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

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

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

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

  62. 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: 5 months ago (Sun, 23 Nov 14 14:40)

  63. Add missing Idle event in main unit

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

  64. Fix missing Idle event in ApplicationEvents module

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

  65. Change button caption from time to time

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

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

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

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

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

  68. 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: 5 months ago (Fri, 14 Nov 14 18:09)

  69. 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: 5 months ago (Thu, 13 Nov 14 19:55)

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

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

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

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

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

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

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

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

  74. 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: 5 months ago (Tue, 11 Nov 14 21:53)

  75. Prepare upcoming 9.1 release

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

  76. 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: 5 months ago (Tue, 11 Nov 14 20:35)

  77. Prepare upcoming 9.0 release

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

  78. Update logo in about dialog with shadow

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  89. Remove unused variable

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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