Download HeidiSQL 10.1

Release date: 26 Jan 2019.

Donate

Compatibility notes

Ads:

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. Detect MS SQL data type DATETIMEOFFSET as such, not as UNKNOWN. Closes #496 and closes #98

    Gravatar image committed: 22 Apr 2019 13:59 compiled: 22 Apr 2019 14:25

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  2. Fix crash while casting Sender to TAction for debugging purposes

    Gravatar image committed: 22 Apr 2019 13:57 compiled: 22 Apr 2019 14:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  3. Issue #496: show UNKNOWN data type in table editor for MSSQL and MySQL, as already for PG. Avoids casting its values to int for the data grid, and at least does not show the data type from the prior column in the table editor.

    Gravatar image committed: 22 Apr 2019 13:47 compiled: 22 Apr 2019 13:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  4. Find and replace dialogs in grid popup text editor:
    * Cancel dialog when user presses Cancel, regardless of which dialog has focus.
    * Show selection when dialog found some text, without having to focus the memo.

    Gravatar image committed: 22 Apr 2019 10:03 compiled: 22 Apr 2019 10:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  5. Issue #140: Flag query editor as modified after pasting text

    Gravatar image committed: 21 Apr 2019 20:27 compiled: 21 Apr 2019 20:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  6. Issue #74: attempt to support all kinds of expressions in column DEFAULT + ON UPDATE clauses

    Gravatar image committed: 21 Apr 2019 15:40 compiled: 21 Apr 2019 15:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  7. Fix TDBConnection.ParseViewStructure so it orders the result from IS.COLUMNS by their ordinal/natural position. Closes #617.

    Gravatar image committed: 19 Apr 2019 12:08 compiled: 19 Apr 2019 12:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  8. Add preference option for custom web search url, used in error dialogs. Closes #411

    Gravatar image committed: 17 Apr 2019 21:29 compiled: 17 Apr 2019 21:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  9. Add new menu item "Duplicate row with keys" to grid context menu, and rename "Duplicate row" to "Duplicate row without keys". Closes #396

    Gravatar image committed: 17 Apr 2019 08:24 compiled: 17 Apr 2019 08:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  10. Cheat when calculating percentage of done work, when exporting tables and data, so we never get more than 100%. Closes #180

    Gravatar image committed: 17 Apr 2019 07:57 compiled: 17 Apr 2019 08:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  11. Exchange icon index of "Check all" button on CSV import dialog, to make it more intuitive (?). Closes #612

    Gravatar image committed: 16 Apr 2019 19:50 compiled: 16 Apr 2019 19:59

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  12. Add some developer notes to unclear translation strings

    Gravatar image committed: 16 Apr 2019 19:43 compiled: 16 Apr 2019 19:57

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  13. Don't prompt to save an empty query tab. Closes #614.

    Gravatar image committed: 16 Apr 2019 19:36 compiled: 16 Apr 2019 19:55

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  14. Add new log category lcScript, for queries from large scripts and import operations. By default disabled, which should speed up importing large files.

    Gravatar image committed: 16 Apr 2019 07:19 compiled: 16 Apr 2019 07:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  15. Issue #521: make debug output more readable

    Gravatar image committed: 16 Apr 2019 06:38 compiled: 16 Apr 2019 06:56

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  16. Issue #521: increase waiting time after PLink output, from 1s to 2s, for slow connections.

    Gravatar image committed: 16 Apr 2019 06:32 compiled: 16 Apr 2019 06:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  17. Issue #521: disable verbosity of plink again, due to weird extra dialogs appearing now

    Gravatar image committed: 15 Apr 2019 20:15 compiled: 15 Apr 2019 20:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  18. Issue #515: Handle encoding errors in apphelpers.ReadTextfileChunk according to how Delphi 10.3 raises exceptions. And probably fix the issue by increasing the new chunk size by 1M instead of only 4B.

    Gravatar image committed: 14 Apr 2019 19:44 compiled: 14 Apr 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  19. Issue #521: add -ssh and -v arguments again to plink.exe command, as proposed in https://github.com/HeidiSQL/HeidiSQL/issues/521#issuecomment-482897896

    Gravatar image committed: 14 Apr 2019 14:05 compiled: 14 Apr 2019 14:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  20. Attempt to fully support UTF8 encoding without BOM, as TEncoding.UTF8 has a non-empty preamble/bom. See https://forums.embarcadero.com/thread.jspa?threadID=112112 . Probably related to encoding issue #515

    Gravatar image committed: 13 Apr 2019 10:52 compiled: 13 Apr 2019 11:25

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

  21. Issue #140: Store application process id in each tabs.ini section, and don't restore tabs from other running processes. If the process no longer runs, restore such tab sections again, so nothing gets lost with multiple running application instances.

    Gravatar image committed: 13 Apr 2019 10:43 compiled: 13 Apr 2019 11:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  22. Issue #140:
    * store tab setup when application exits, as the TimerStoreTabs interval may not yet be reached
    * remember startup value of asRestoreTabs option, which may change while the application runs, which in turn may cause problems when RestoreTabs wasn't called

    Gravatar image committed: 13 Apr 2019 09:32 compiled: 13 Apr 2019 09:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  23. Issue #521: use -batch instead of -ssh parameter for plink, to prevent creating a shell and to reduce interactive prompts

    Gravatar image committed: 13 Apr 2019 08:38 compiled: 13 Apr 2019 08:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  24. Issue #140: Move code for all remaining common directory paths settings to TAppSettings (UserAppData, UserDocuments, Snippets)

    Gravatar image committed: 11 Apr 2019 21:47 compiled: 11 Apr 2019 21:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  25. Issue #140: Use local tabs.ini and Backups directory in portable mode

    Gravatar image committed: 11 Apr 2019 21:21 compiled: 11 Apr 2019 21:25

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

  26. Issue #140: Avoid writing the tabs.ini file through WriteString if nothing was effectively changed

    Gravatar image committed: 10 Apr 2019 16:51 compiled: 10 Apr 2019 18:57

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  27. Issue #140: Add some more missing translation strings. Shame on me, I am always forgetting these.

    Gravatar image committed: 10 Apr 2019 15:06 compiled: 10 Apr 2019 18:55

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  28. Issue #140: remove a tab section from tabs.ini within RestoreTabs(), if its file does not exist

    Gravatar image committed: 10 Apr 2019 12:41 compiled: 10 Apr 2019 13:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  29. Issue #140: make auto-backup/restore feature stable against running multiple application instances:
    * use unique date/time with milliseconds as ini sections
    * open ini file for each read + write, separately, don't keep it open all the time

    Gravatar image committed: 10 Apr 2019 12:19 compiled: 10 Apr 2019 12:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  30. Issue #140:
    * fix: very last tab backup was not yet done
    * tell user about activated auto-restore feature in very last question dialog for saving tab
    * add missing translation strings

    Gravatar image committed: 08 Apr 2019 20:51 compiled: 08 Apr 2019 21:25

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  31. Issue #140: Do not auto backup unsaved tab contents if it's larger than 10MB

    Gravatar image committed: 07 Apr 2019 13:47 compiled: 07 Apr 2019 13:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  32. Issue #140: Auto-backup unsaved query tab contents to C:\Users\<username>\AppData\Roaming\HeidiSQL\Backups\*.sql, and tab setup in C:\Users\<username>\AppData\Roaming\HeidiSQL\tabs.ini

    Gravatar image committed: 07 Apr 2019 13:14 compiled: 07 Apr 2019 13:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  33. Put a new filter box above query helpers tree, for quickly finding snippet or function

    Gravatar image committed: 07 Apr 2019 11:13 compiled: 07 Apr 2019 11:24

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

  34. Support selecting wrong cased columns in MariaDB 10.4, so the user manager shows up. Closes #599.

    Gravatar image committed: 04 Apr 2019 20:35 compiled: 04 Apr 2019 20:55

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  35. Issue #360: remove no longer used translation string, and add a new one, for the new background color label

    Gravatar image committed: 30 Mar 2019 09:57 compiled: 30 Mar 2019 10:26

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  36. Move tree background color setting from File menu to the Advanced tab of the session manager. Closes #360

    Gravatar image committed: 30 Mar 2019 09:52 compiled: 30 Mar 2019 10:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  37. Silence EAccessViolation in PQfinish() of 32bit libpq.dll . Closes #37

    Gravatar image committed: 30 Mar 2019 09:26 compiled: 30 Mar 2019 09:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  38. Issue #577: skip informational error output from new plink version

    Gravatar image committed: 28 Mar 2019 20:04 compiled: 28 Mar 2019 20:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

  39. Show full filter in data tab's recent filter drop down, make it higher to show more items, plus optimize incremental searching when it has focus. See https://stackoverflow.com/questions/37477244/tcombobox-autocloseup-property-what-does-it-do

    Gravatar image committed: 28 Mar 2019 17:06 compiled: 28 Mar 2019 17:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  40. Pause after compiling resources, so user has a chance to read the (error) output

    Gravatar image committed: 18 Mar 2019 21:50 compiled: pretty soon, be patient...

  41. Sort encoding names in CSV import dialog alphabetically. Closes #579.

    Gravatar image committed: 18 Mar 2019 20:22 compiled: 18 Mar 2019 20:55

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  42. Issue #140: add "Files" tab to preferences dialog, move "Prompt for file save" checkbox there, and introduce two new checkboxes for restoring opened and unsaved query tab contents (both new yet without functionality in their back)

    Gravatar image committed: 17 Mar 2019 11:57 compiled: 17 Mar 2019 12:23

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  43. Simplify language selector populating: extract potentially existing lang name from long string, rather than holding a complex list

    Gravatar image committed: 17 Mar 2019 09:06 compiled: 17 Mar 2019 09:25

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  44. Reveal yet hidden languages in language selector on preferences dialog. Reveals hr_HR Croatian, which was present on Transifex but missing in hardcoded language list from dxgettext/languagecodes.pas

    Gravatar image committed: 17 Mar 2019 08:45 compiled: 17 Mar 2019 09:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  45. Add missing zh_CN "Chinese (China)" to language selector. Closes #498.

    Gravatar image committed: 15 Mar 2019 19:48 compiled: 15 Mar 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  46. Issue #498: Update gettext unit to r124 from https://sourceforge.net/p/dxgettext/code/HEAD/tree/trunk/dxgettext/sample/gnugettext.pas

    Gravatar image committed: 15 Mar 2019 07:55 compiled: 15 Mar 2019 08:10

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  47. Issue #433: Additional line break after SQL export comments for skipping data

    Gravatar image committed: 15 Mar 2019 07:44 compiled: 15 Mar 2019 07:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  48. Issue #498: Display current locale abbreviation in "Auto detect" item of language selector

    Gravatar image committed: 14 Mar 2019 21:11 compiled: 14 Mar 2019 21:21

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  49. Prevent sporadic crash on startup

    Gravatar image committed: 14 Mar 2019 20:22 compiled: 14 Mar 2019 21:18

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

  50. Protect from crash when pressing ctrl+tab before main form is displayed. Closes #574

    Gravatar image committed: 14 Mar 2019 20:21 compiled: 14 Mar 2019 21:16

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)