Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Download HeidiSQL 11.1, released on 02 Nov 2020

Donate

Compatibility notes

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. Separate Create > "Stored routine" menu item into two, one for procedures and one for functions. Closes #987

    Gravatar image committed: 17 Jan 2021 14:37 compiled: 17 Jan 2021 14:56

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  2. Simplify more code using the new PopupComponent() function

    Gravatar image committed: 16 Jan 2021 18:36 compiled: 16 Jan 2021 18:55

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  3. Simplify some code which checks where user has clicked, using the new PopupComponent()

    Gravatar image committed: 16 Jan 2021 18:15

  4. Issue #75: pimp up context menu for indexes tab, and assign to foreign keys tab and check constraints tab as well

    Gravatar image committed: 16 Jan 2021 17:19 compiled: 16 Jan 2021 17:26

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  5. Issue #75: get "Add constraint" and "Delete constraint" buttons working, provide function list when editing check clause, and fix some more issues

    Gravatar image committed: 16 Jan 2021 16:29 compiled: 16 Jan 2021 16:56

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  6. Issue #75:
    * detect table names in IS dynamically, on PostgreSQL and MySQL/MariaDB. This prevents me from using too complex version conditionals for detecting whether CHECK_CONSTRAINTS table is there
    * even if CHECK_CONSTRAINTS table is there, the detection might fail due to the missing column TABLE_NAME, on MySQL, MSSQL and PostgreSQL. Catch SQL errors in that query and disable further detection of check constraints.

    Gravatar image committed: 14 Jan 2021 21:09 compiled: 14 Jan 2021 21:26

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  7. Issue #75: CHECK_CONSTRAINTS is there on MSSQL, but does not work due to missing TABLE_NAME column: https://www.heidisql.com/forum.php?t=37462

    Gravatar image committed: 14 Jan 2021 07:56 compiled: 14 Jan 2021 08:26

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  8. Issue #75: create editable list for check constraints in table editor

    Gravatar image committed: 12 Jan 2021 21:41 compiled: 12 Jan 2021 21:56

    Downloads: 32bit build (13.9 MB)64bit build (18.6 MB)32+64bit installer (19.5 MB)

  9. Add menu items for inserting lowercase GUID's into grid cell. Closes #1268

    Gravatar image committed: 08 Jan 2021 16:49 compiled: 08 Jan 2021 16:56

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.5 MB)

  10. Fix crash in SynMemoQueryStatusChange when resizing main window with no active query tab

    Gravatar image committed: 08 Jan 2021 11:00 compiled: 08 Jan 2021 11:26

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  11. Update gnugettext unit to rev 134 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas

    Gravatar image committed: 07 Jan 2021 17:44 compiled: 07 Jan 2021 17:56

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  12. Update sqlite3 libraries from v3.30.1 to v3.34.0 from Dec 01 2020

    Gravatar image committed: 05 Jan 2021 17:40 compiled: 06 Jan 2021 21:43

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.5 MB)

  13. Outsource a local function into TDBObject.SchemaClauseIS, and use it in GetTableColumns

    Gravatar image committed: 04 Jan 2021 19:27

  14. Display number of indexes and foreign keys in caption of their tabs within the table editor. Helpful for knowing the number without having to activate their tab.

    Gravatar image committed: 04 Jan 2021 16:44 compiled: 04 Jan 2021 16:56

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  15. Rename TTableColumn.Expression field to the more unique and clear .GenerationExpression, also for distinction from the upcoming CHECK expression.

    Gravatar image committed: 03 Jan 2021 15:05

  16. Fix scope for FStatus symbol of TTableColumn

    Gravatar image committed: 03 Jan 2021 14:57

  17. Fix access violation in WalkNode.Parent in 32 bit mode. Not sure why but that happens after 67e3dc0a5181b2d053e15b9ce32822cf7a8a6814 . Closes #1270

    Gravatar image committed: 01 Jan 2021 14:08 compiled: 01 Jan 2021 14:26

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  18. Issue #477: Translate controls on CSV layout detector

    Gravatar image committed: 29 Dec 2020 22:20 compiled: 29 Dec 2020 22:26

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  19. Activate AutoSize and disable WordWrap on the replace hint in the search/replace dialog, so the height is auto-adjusted (especially with chars like g), and the words are not tried to be wrapped into a hidden second line.

    Gravatar image committed: 29 Dec 2020 22:17

  20. Fix crash in SetupSynEditors after CSV layout detector was opened and closed once.

    Gravatar image committed: 29 Dec 2020 22:08

  21. Widen status bar panels for big screens

    Gravatar image committed: 28 Dec 2020 17:35 compiled: 28 Dec 2020 17:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  22. Fix non working inheritance of font for completion proposal in trigger editor

    Gravatar image committed: 28 Dec 2020 17:33

  23. Apply data type colors to column names in completion proposal, and move formatting code to new apphelpers.SynCompletionProposalPrettyText()

    Gravatar image committed: 28 Dec 2020 13:18

  24. Rename two forms so these comply to my own code convention: TDataSortingForm=>TfrmDataSorting and TColumnSelectionForm=>TfrmColumnSelection

    Gravatar image committed: 27 Dec 2020 12:56 compiled: 27 Dec 2020 13:26

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  25. Warn the user about potential data loss when loading a (sql) file with encoding set to "auto-detect". That auto-detection has caused several data loss situations already.

    Gravatar image committed: 26 Dec 2020 09:02 compiled: 26 Dec 2020 13:26

    Downloads: 32bit build (13.9 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  26. Call SynUnicode.GetEncoding instead of our own old copied code in apphelpers.DetectEncoding. Probably enhances the "auto-detect encoding" option in file-open dialogs.

    Gravatar image committed: 26 Dec 2020 08:58

  27. Code cleanup: rename options unit to preferences. And follow a naming convention for the form name, which I already have in some of the other forms: TfrmPreferences

    Gravatar image committed: 22 Dec 2020 17:24 compiled: 22 Dec 2020 17:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  28. Issue #744: Suspend action list on mainform while preferences dialog is open, so changes on the Shortcuts tab do not trigger some action, probably even with a crash

    Gravatar image committed: 22 Dec 2020 08:46 compiled: 22 Dec 2020 17:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  29. Issue #744: Shortcut settings: Let user know whether a wanted shortcut is assigned to another action, and prompt for confirmation in such cases.

    Gravatar image committed: 21 Dec 2020 21:12 compiled: 21 Dec 2020 21:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  30. Update bundled plink.exe to v0.74 from https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html . closes #1218

    Gravatar image committed: 19 Dec 2020 10:36 compiled: 19 Dec 2020 10:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  31. Move upper controls on view editor into a first tab of a new page control, and show CREATE code on a second tab. Closes #1135

    Gravatar image committed: 19 Dec 2020 10:26

  32. Add support for JSONB column types in PostgreSQL. Closes #606

    Gravatar image committed: 19 Dec 2020 08:59 compiled: 19 Dec 2020 09:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  33. Auto-create directory path specified in SQL export target filename. Closes #1086

    Gravatar image committed: 19 Dec 2020 08:48 compiled: 19 Dec 2020 08:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  34. Issue #1241: Remove theme selection from installer

    Gravatar image committed: 18 Dec 2020 09:22 compiled: 18 Dec 2020 10:32

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.4 MB)

  35. Catch file creation errors in TQueryTab.SaveContents, when an opened file was removed with its directory, from outside. And auto-create missing folder when user presses Ctrl+S then. Also, if tabs.ini has a tab entry with a no longer existing file, don't watch that non-existent file for changes, which fixes RestoreTabs showing an error on startup.

    Gravatar image committed: 18 Dec 2020 08:28 compiled: 18 Dec 2020 08:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  36. Try to prevent inner exception at the end of TMySQLQuery.Col. Hopefully reveals a more meaningful error message for issue #904

    Gravatar image committed: 17 Dec 2020 12:46 compiled: 17 Dec 2020 12:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  37. Enable cancel button after setting grid cell to NULL. Closes #1146

    Gravatar image committed: 17 Dec 2020 12:20 compiled: 17 Dec 2020 12:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  38. Limit rows per exported INSERT to 1000 for MSSQL. Introduced MaxRowsPerInsert property per connection type. 10000 for all other types. Closes #1189

    Gravatar image committed: 17 Dec 2020 11:43 compiled: 17 Dec 2020 11:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  39. Code cleanup: move some node index constants to TQueryTab, and probably prevent AV in treeQueryHelpersInitChildren

    Gravatar image committed: 16 Dec 2020 18:15 compiled: 16 Dec 2020 18:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  40. Support binary values in "More values" quick filter menu

    Gravatar image committed: 16 Dec 2020 17:24

  41. Support regproc and regprocedure types on PostgreSQL, so these don't use SUBSTR() in data grid

    Gravatar image committed: 15 Dec 2020 17:57 compiled: 15 Dec 2020 18:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  42. Prefer SUBSTR() over LEFT() function in PostgreSQL data grid. Closes #1259

    Gravatar image committed: 15 Dec 2020 17:56

  43. Get rid of hardcoded string default date 2000-01-01 in various places. Introduce apphelpers.DateTimeNever field instead.

    Gravatar image committed: 15 Dec 2020 07:36 compiled: 15 Dec 2020 07:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  44. Fix sporadic crash in Tconnform.TimerStatisticsTimer due to empty session path

    Gravatar image committed: 15 Dec 2020 07:21

  45. Fix sporadic EInvalidOp crash when displaying invalid uptime from server's ConnectionInfo

    Gravatar image committed: 14 Dec 2020 22:26 compiled: 14 Dec 2020 22:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  46. Fix crash when table has an invalid/negative create or update date/time

    Gravatar image committed: 14 Dec 2020 22:16 compiled: 14 Dec 2020 22:26

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  47. Silence crash in TMainForm.AnyGridGetText, when trying to calculate Unix timestamp from an too large or too low number

    Gravatar image committed: 14 Dec 2020 19:56 compiled: 14 Dec 2020 20:25

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  48. Fix crash in TMainForm.treeQueryHelpersGetText

    Gravatar image committed: 14 Dec 2020 19:39 compiled: 14 Dec 2020 19:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  49. Attempt to fix out-of-range error in TMainForm.tabsetQueryMouseMove

    Gravatar image committed: 14 Dec 2020 18:24 compiled: 14 Dec 2020 18:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

  50. Attempt to fix a crash in TMainForm.DBtreeInitNode, probably accessing ParentNode when it's nil

    Gravatar image committed: 14 Dec 2020 17:28 compiled: 14 Dec 2020 17:56

    Downloads: 32bit build (13.8 MB)64bit build (18.5 MB)32+64bit installer (19.3 MB)

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.