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 10.3

Release date: 11 Dec 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 #12: remove "database." part from reference table in foreign key code, as this throws an error: near ".": syntax error. Makes "Create table copy" dialog compatible to SQLite, except for indexes yet

    Gravatar image committed: 19 Jan 2020 20:45 compiled: 19 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  2. Prefer CREATE code from SHOW CREATE TABLE in MySQL again, which includes table options which are yet unsupported in the generic TDBConnection.GetCreateCode .

    Gravatar image committed: 19 Jan 2020 13:48 compiled: 19 Jan 2020 13:56

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

  3. Issue #12: clear internal cache when closing an SQLite connection

    Gravatar image committed: 19 Jan 2020 13:26

  4. Finally, remove ParseTableStructure method, and use a text format of TTableColumn in the remaining caller "Paste columns"

    Gravatar image committed: 19 Jan 2020 13:25

  5. Issue #12: Support "find text on server" tool with compatible queries in SQLite

    Gravatar image committed: 19 Jan 2020 08:04 compiled: 19 Jan 2020 08:26

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  6. Issue #12: SQLite allows any column type declaration, even custom types.
    * support those declarations which are commonly used in other database systems, and for which Heidi has a fitting grid editor
    * move UNIQUEIDENTIFIER from text group to binary group
    * remove useless native type ids and empty descriptions

    Gravatar image committed: 19 Jan 2020 07:26 compiled: 19 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  7. Issue #12: detect UNIQUEIDENTIFIER column type, and sort that into the text type group

    Gravatar image committed: 18 Jan 2020 18:18 compiled: 18 Jan 2020 18:27

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

  8. Add missing CHAR datatype to SQLite column detection. Closes #858

    Gravatar image committed: 18 Jan 2020 08:19 compiled: 18 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  9. MSSQL: Fix not displayed column names of current table in data grid filter proposal, due to .QuotedName adding the Schema and detecting that as the database name

    Gravatar image committed: 18 Jan 2020 08:09

  10. Assign table columns and keys from the connection's database cache. Reduces internal queries to the minimum per table. Closes #852.

    Gravatar image committed: 17 Jan 2020 08:07 compiled: 17 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  11. Unify name and case of information_schema, per connection. Finally. Closes #855

    Gravatar image committed: 16 Jan 2020 08:03 compiled: 16 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  12. Issue #852: Implement Assign method on TTableColumnList and friends, TDBObject.LoadDetails and .UnloadDetails, and cross fingers that assigning details to Mainform.FActiveDbObj reduces the number of internal queries

    Gravatar image committed: 16 Jan 2020 07:40 compiled: 16 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  13. Issue #12: detect SQLite data type TEXT on result columns without rows. sqlite3_column_decltype() and sqlite3_column_type() already failed in such cases.

    Gravatar image committed: 16 Jan 2020 06:27 compiled: 16 Jan 2020 06:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  14. Issue #12: detect SQLite data type of non-table result columns, using sqlite3_column_type(). See https://stackoverflow.com/questions/59749418/sqlite-c-api-equivalent-to-typeofcol

    Gravatar image committed: 15 Jan 2020 22:48 compiled: 15 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  15. Issue #852: Return copy of once queried columns, keys and foreign keys object lists in TDBObject, instead of re-querying from database each time.

    Gravatar image committed: 15 Jan 2020 21:17 compiled: 15 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  16. Sort column names in data grid by their ordinal position. Closes #854

    Gravatar image committed: 15 Jan 2020 19:55 compiled: 15 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  17. Detect SQLite BOOL columns as TINYINT

    Gravatar image committed: 14 Jan 2020 21:15 compiled: 14 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  18. Separate join in TDBConnection.GetTableForeignKeys into two separate and faster queries. Closes #852

    Gravatar image committed: 14 Jan 2020 20:59

  19. Issue #12: Add support for foreign key dropdown in SQLite grid fields. Note that SQLite does not support LEFT(), while MSSQL does not support SUBSTR(), so here's a template per network type: spFuncLeft.

    Gravatar image committed: 13 Jan 2020 21:56 compiled: 13 Jan 2020 22:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  20. Fix some crashes, where the caller frees the result of GetTableColumns/Keys/ForeignKeys. Probably fixes #849 and #848

    Gravatar image committed: 13 Jan 2020 19:44 compiled: 13 Jan 2020 19:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  21. Detect static date/time values as text type, not expression. See https://www.heidisql.com/forum.php?t=35370

    Gravatar image committed: 13 Jan 2020 14:27

  22. Fix crash in suggest popup without table or view. Closes #848

    Gravatar image committed: 13 Jan 2020 14:13

  23. Issue #12: detect foreign keys of SQLite tables

    Gravatar image committed: 13 Jan 2020 12:17 compiled: 13 Jan 2020 12:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  24. Detect empty string without quotes as text default type. See https://www.heidisql.com/forum.php?t=35365

    Gravatar image committed: 13 Jan 2020 11:53 compiled: 13 Jan 2020 11:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  25. Issue #12: Implement TDBConnection.GetTableForeignKeys, failing on all db systems except MySQL. Closes #845

    Gravatar image committed: 12 Jan 2020 19:56 compiled: 12 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  26. Add sqlite file extension to database selector

    Gravatar image committed: 10 Jan 2020 20:30 compiled: 10 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  27. Issue #12: Implement TPgConnection.GetTableKeys, and now call GetTableColumns and GetTableKeys from GetCreateCode. TMySQLConnection should also use that, at least for tables.

    Gravatar image committed: 10 Jan 2020 08:11 compiled: 10 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  28. Issue #12: Get column comments in MSSQL back. See http://www.heidisql.com/forum.php?t=19576

    Gravatar image committed: 09 Jan 2020 21:27 compiled: 09 Jan 2020 21:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  29. Issue #12: restore compatibility to MySQL pre-5.0 servers, which have no IS.columns table

    Gravatar image committed: 09 Jan 2020 20:50 compiled: 09 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  30. Issue #12: restore compatibility to MySQL pre-5.5 servers, which have no "Index_comment" column in IS.columns

    Gravatar image committed: 09 Jan 2020 20:19 compiled: 09 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  31. Issue #12: Implement TDBConnection.GetTableColumns and .GetTableKeys (todo: .GetTableForeignKeys), as a replacement for the error prone ParseTableStructure. SQLite columns and keys should be parsed correctly now, MS SQL and PostgreSQL may now have some glitches to fix.

    Gravatar image committed: 08 Jan 2020 15:28 compiled: 08 Jan 2020 15:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  32. Restore previous logic: Allow empty result in TableName(Column), which is the case for data tab TEXT columns with LEFT(..) clause. Other columns may have a table name in that case. Closes #837

    Gravatar image committed: 03 Jan 2020 18:45 compiled: 03 Jan 2020 18:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  33. Do not set DataTypeCompatibility=80 in ADO connection string with old SQLOLEDB driver. Probably solves some connection issues, see https://www.heidisql.com/forum.php?t=35208

    Gravatar image committed: 03 Jan 2020 16:32 compiled: 03 Jan 2020 16:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  34. Issue #12: Proper implementation of TSQLiteQuery.ColIsPrimaryKeyPart()

    Gravatar image committed: 01 Jan 2020 19:12 compiled: 01 Jan 2020 19:27

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)

  35. Overload TDBQuery.TableName with TableName(Column), for future usage in ColIsPrimaryKeyPart and friends

    Gravatar image committed: 01 Jan 2020 18:51

  36. Issue #12: Call sqlite3_total_changes() after at least one call to sqlite3_step(), otherwise SQLite does not seem to execute a non-result query. Should make updates in data and query grid working now.

    Gravatar image committed: 01 Jan 2020 17:40 compiled: 01 Jan 2020 17:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  37. Add two newer header constants for MySQL/SSL, yet unused by HeidiSQL

    Gravatar image committed: 01 Jan 2020 11:59 compiled: 01 Jan 2020 12:28

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)

  38. Issue #12: Detect more granular data types on SQLite, which we need for the table designer and other things

    Gravatar image committed: 01 Jan 2020 11:56

  39. Issue #12: Fix TDBConnection.ApplyLimitClause for SQLite, which does not support a LIMIT clause in UPDATE/DELETE statements

    Gravatar image committed: 01 Jan 2020 11:53

  40. Issue #12: Get TDBConnection.GetSessionVariables running for SQLite, with an empty list of variables for now

    Gravatar image committed: 01 Jan 2020 11:52

  41. Issue #12: Implement TSQLiteConnection.GetCreateCode, and support square brackets for identifier quoting

    Gravatar image committed: 01 Jan 2020 11:50

  42. Move TDBConnection.FRegClasses one down in class hierarchy, where it belongs

    Gravatar image committed: 01 Jan 2020 11:44

  43. Issue #12: Simplify code in Tconnform.ValidateControls

    Gravatar image committed: 01 Jan 2020 11:42

  44. Issue #12: Support query batch fired in one go, and get multiple results per query running. Using pzTail out parameter of sqlite_prepare_v3(), not sqllite_next_stmt(), which returns statements from previously fired queries.

    Gravatar image committed: 29 Dec 2019 09:52 compiled: 29 Dec 2019 09:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  45. Make TDBConnection.GetLastResults generic for all network types, and only override it for MSSQL with a manual query-separator, so we have less code

    Gravatar image committed: 28 Dec 2019 09:35

  46. Issue #12: Clean up code, attempt to get multiple SQLite results per query working, move FStatementNum from TDBConnection to the only caller TMySQLConnection

    Gravatar image committed: 28 Dec 2019 09:29

  47. Issue #12: Provide file pick icon in SQLite database file edit box. Database file is created by sqlite3_open() silently if it does not yet exist. Show a confirmation message in such cases.

    Gravatar image committed: 27 Dec 2019 17:53 compiled: 27 Dec 2019 18:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

  48. Session manager: populate library dropdown when user selects a different net type

    Gravatar image committed: 27 Dec 2019 17:19

  49. Introduce function TDBConnection.ResultCount and use that instead of syncing FResultCount variable in many places

    Gravatar image committed: 27 Dec 2019 09:05

  50. Issue #12: Get real/origin names of columns in a SQLite result into FColumnOrgNames list, and remove Columns list from TGridRows now that we can use the statement pointer later

    Gravatar image committed: 27 Dec 2019 08:53 compiled: 27 Dec 2019 08:58

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)