Download HeidiSQL 10.2

Release date: 15 Jun 2019.

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. Issue #769: append ::text to JSON column names in PostgreSQL WHERE clauses. Fixes "Operator does not exist" errors

    Gravatar image committed: 20 Oct 2019 16:47 compiled: 20 Oct 2019 16:54

  2. Performance: Search libraries on system once per app instance and net type group. Cache these in TConnectionParameters.FLibraries. OLE DB providers take some time to collect.

    Gravatar image committed: 20 Oct 2019 09:47 compiled: 20 Oct 2019 09:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

  3. Issue #144: Prefer emptying selection in TCustomEdit's via EM_REPLACESEL message, which we can prepare to support undo. Unfortunately, not so in TComboBox, which does nothing then.

    Gravatar image committed: 19 Oct 2019 16:59 compiled: 19 Oct 2019 17:26

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  4. Issue #144: New approach for supporting Ctrl+Backspace in edit + combobox controls, now in the ApplicationEvents.OnShortCut event

    Gravatar image committed: 19 Oct 2019 14:07 compiled: 19 Oct 2019 14:26

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  5. Issue #140: Be sure to write tab backup files in UTF8 without BOM

    Gravatar image committed: 15 Oct 2019 07:07 compiled: 15 Oct 2019 07:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  6. Issue #140: Prefer TStreamWriter over TFileStream, in SaveUnicodeFile(). Also, use its own Write() method instead of StreamWrite(), which encodes UTF8 first, so the new approach is probably faster. Probably also helps with non-writable tab backups on some systems.

    Gravatar image committed: 13 Oct 2019 16:38 compiled: 13 Oct 2019 16:56

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  7. Issue #704: detect pre-authentication banner messages as informational (not as error) in plink output

    Gravatar image committed: 13 Oct 2019 14:48 compiled: 13 Oct 2019 14:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  8. Issue #704: check result of "SHOW ssl" for whether SSL is really being used

    Gravatar image committed: 13 Oct 2019 14:35

  9. Issue #704: escape backslashes in SSL certificate files for PostgreSQL connections

    Gravatar image committed: 11 Oct 2019 07:53 compiled: 11 Oct 2019 07:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  10. Remove the SHAutoComplete() call to revert the solution for #144 - this introduces too many new bugs.

    Gravatar image committed: 08 Oct 2019 19:26 compiled: 08 Oct 2019 19:56

    Downloads: 32bit build (7.9 MB)64bit build (8.4 MB)32+64bit installer (20.1 MB)

  11. Update libmariadb.dll and various plugins, add 2 new ones: client_ed25519 and auth_named_pipe. Probably solves #754

    Gravatar image committed: 08 Oct 2019 19:05 compiled: 08 Oct 2019 19:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.1 MB)

  12. Revert 355db1403aff5c7d061962f3ca21c62bcd8001f8 for #144, which makes the Tab key ineffective. Closes #765

    Gravatar image committed: 07 Oct 2019 20:27 compiled: 07 Oct 2019 20:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  13. Issue #762: add informational message when foreign key'd column has too many rows in the connected table, and raise limit from 1000 to 10000.

    Gravatar image committed: 05 Oct 2019 14:09 compiled: 05 Oct 2019 14:26

    Downloads: 32bit build (7.9 MB)64bit build (8.4 MB)32+64bit installer (21.4 MB)

  14. To retrieve a column default value, prefer pg_attrdef.adbin column over pg_attrdef.adsrc. PostgreSQL 12 does not have adsrc. Closes #763

    Gravatar image committed: 05 Oct 2019 12:08 compiled: 05 Oct 2019 12:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (21.4 MB)

  15. Issue #62: distinct between TIMEZONE (without time zone) and TIMEZONETZ (with time zone). And modify GetDatatypeByName() so it deletes the longest detected datatype string PostgreSQLDatatypes.Names . This solves empty/undetected column comments in ParseTableStructure(). See https://www.heidisql.com/forum.php?t=23211#p34709

    Gravatar image committed: 05 Oct 2019 08:04 compiled: 05 Oct 2019 08:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  16. Fix glitch in previous commit for #62: never escape \, and don't overwrite text with escaped joker chars. So we just escape %, _ and ' now in Postgres mode.

    Gravatar image committed: 03 Oct 2019 12:19 compiled: 03 Oct 2019 12:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  17. Remove "E" prefix from escaped strings, which caused an empty result in ExtractLiteral(). Instead, let EscapeString() escape just \, % and _ with backslash, and ' by a second '. Closes #62

    Gravatar image committed: 03 Oct 2019 12:09

  18. Check if (old) grid result is in a valid state before checking for an url. Closes #759

    Gravatar image committed: 01 Oct 2019 19:35 compiled: 01 Oct 2019 19:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  19. Issue #541: apply KeyPress event to all other writable SQL editors, so the auto-uppercase feature is available everywhere

    Gravatar image committed: 30 Sep 2019 20:44 compiled: 30 Sep 2019 20:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  20. Issue #712: final solution for intuitive result tab captions and line/char panel

    Gravatar image committed: 29 Sep 2019 12:34 compiled: 29 Sep 2019 12:58

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  21. Issue #144: TMemo and friends select their text when pressing Enter, when they were manipulated by SHAutoComplete, so fix that by leaving TCustomMemo as they are

    Gravatar image committed: 28 Sep 2019 16:44 compiled: 28 Sep 2019 16:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  22. Issue #719: For message dialog button captions, prefer localized strings from user32.dll over our translation from Transifex

    Gravatar image committed: 26 Sep 2019 20:29 compiled: 26 Sep 2019 20:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (21.4 MB)

  23. Issue #144: Change default keystroke for "delete next word" (ecDeleteWord) from Ctrl+T reasonably to Ctrl+Del

    Gravatar image committed: 26 Sep 2019 19:16 compiled: 26 Sep 2019 19:28

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  24. Issue #144: Let grid editors call TExtForm.FixControls on their MainControl, to support Ctrl+Backspace there.

    Gravatar image committed: 25 Sep 2019 20:39 compiled: 25 Sep 2019 20:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  25. Issue #144: Move some code out of TExtForm.OnCreate into .DoShow, where it works for more instances of TEdit, e.g. the database and table filter. Also, let the object editors call this code, as they don't derive from TExtForm.

    Gravatar image committed: 25 Sep 2019 20:14 compiled: 25 Sep 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (21.4 MB)

  26. Issue #144: make Ctrl+Backspace delete the last word of TEdit and TButtonedEdit in any TExtForm

    Gravatar image committed: 25 Sep 2019 17:40

  27. Issue #423: add DataTypeCompatibility=80 to connection string, hopefully healing these "multiple step" errors on MS SQL

    Gravatar image committed: 22 Sep 2019 19:35 compiled: 22 Sep 2019 19:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  28. Fix broken undo history after applying auto-uppercase. Closes #541. Also support auto-fixing case of known database objects.

    Gravatar image committed: 19 Sep 2019 20:10 compiled: 19 Sep 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  29. Issue #712: insert Unicode arrow characters in query result tabs and status bar panel, and unify order of x + y

    Gravatar image committed: 17 Sep 2019 20:22 compiled: 17 Sep 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  30. Issue #515: give ReadTextfileChunk a BufferPadding of 1 instead of 10M. With 10 attempts, we get a maximum of 10 Bytes which is more than enough to get a complete character in any multibyte encoding. See https://github.com/HeidiSQL/HeidiSQL/issues/515#issuecomment-527858110

    Gravatar image committed: 17 Sep 2019 19:59

  31. Add menu item "Open URL" to grid context menu, enabled only if underlying field text is a HTTP URL. Closes #692

    Gravatar image committed: 16 Sep 2019 20:37 compiled: 16 Sep 2019 21:28

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  32. Issue #746: Call SetString with UTF8String instead of String, as advised on https://stackoverflow.com/q/57951463/4110077 . Hopefully nails the decoding issue.

    Gravatar image committed: 16 Sep 2019 19:41 compiled: 16 Sep 2019 19:50

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  33. Issue #746: prefer AnsiString over Byte data type for buffering http request result.

    Gravatar image committed: 15 Sep 2019 19:08 compiled: 15 Sep 2019 19:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  34. Get schema with the same name as user name in search path. See https://www.heidisql.com/forum.php?t=34558

    Gravatar image committed: 14 Sep 2019 15:27 compiled: 14 Sep 2019 15:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  35. LogSQL: move MainFormCreated flag activation above first wanted debug messages, and include client's time zone offset in log panel

    Gravatar image committed: 13 Sep 2019 17:57 compiled: 13 Sep 2019 18:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  36. Issue #746: log result of donor check in log panel, move http request from FormCreate to AfterFormCreate, and repaint image after show/hide

    Gravatar image committed: 13 Sep 2019 17:52 compiled: 13 Sep 2019 17:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  37. Issue #746: Reset http request timeout from 3s to 10s in donor check. Probably some requests take a bit longer on the new webserver.

    Gravatar image committed: 13 Sep 2019 06:08 compiled: 13 Sep 2019 06:27

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  38. Issue #654: reduce very frequent calls to Application.ProcessMessages while import dialog shows, down from 1 call per command to 1 call per second

    Gravatar image committed: 08 Sep 2019 09:41 compiled: 08 Sep 2019 09:57

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (21.4 MB)

  39. Prevent file read issues: THttpDownload.SendRequest() now stores the response in a string variable if the passed file name is empty.

    Gravatar image committed: 26 Aug 2019 14:00 compiled: 26 Aug 2019 14:08

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

  40. Trim linebreak from right side of detected procedure parameters. See https://www.heidisql.com/forum.php?t=34518

    Gravatar image committed: 26 Aug 2019 07:34 compiled: 26 Aug 2019 07:57

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

  41. Fix InnoSetup warning: Warning: Constant "pf" has been renamed. Use "commonpf" instead or consider using its "auto" form.

    Gravatar image committed: 20 Aug 2019 21:23 compiled: 20 Aug 2019 21:26

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

  42. Fix non applied font name on some link labels

    Gravatar image committed: 20 Aug 2019 21:11

  43. Make installer script ready for Inno Setup 6

    Gravatar image committed: 20 Aug 2019 20:33 compiled: 20 Aug 2019 20:42

    Downloads: 32bit build (5.4 MB)64bit build (6.3 MB)32+64bit installer (20.5 MB)

  44. Leave explain links disabled when SQL in focused process is empty, and only prepend a "USE dbname" if used database is not empty. Closes #738

    Gravatar image committed: 16 Aug 2019 07:13 compiled: 16 Aug 2019 07:24

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

  45. Fix duplicated parentheses on host sub tabs, broken by previous commit. Closes #739

    Gravatar image committed: 16 Aug 2019 06:42 compiled: 16 Aug 2019 06:54

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

  46. Remove FHostTabCaptions list which had untranslated captions since recently. Use a regular expression instead. Closes #730.

    Gravatar image committed: 15 Aug 2019 07:48 compiled: 15 Aug 2019 07:54

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

  47. Issue #513: remove minimize and maximize buttons from theme preview dialog

    Gravatar image committed: 13 Aug 2019 09:30 compiled: 13 Aug 2019 09:54

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

  48. Try to fix missing schema in row counting query. See https://www.heidisql.com/forum.php?t=34331#p34439 and https://www.heidisql.com/uploads/34439-2-bugreport.txt

    Gravatar image committed: 13 Aug 2019 09:12 compiled: 13 Aug 2019 09:24

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

  49. Catch more sorts of exceptions in TMainForm.AnyGridGetText when converting large integers to unix timestamps. Should fix #735

    Gravatar image committed: 13 Aug 2019 08:50 compiled: 13 Aug 2019 08:54

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

  50. Return default net group in TConnectionParameters.GetNetTypeGroup. Raising an exception lets the app die for some reason. Reproduction: click drop-down button on "Database(s)" session setting

    Gravatar image committed: 11 Aug 2019 14:18 compiled: 11 Aug 2019 14:24

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