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. 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)

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

    Gravatar image committed: 19 Jan 2020 13:26

  3. 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

  4. 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)

  5. 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)

  6. 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)

  7. 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)

  8. 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

  9. 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)

  10. 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)

  11. 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)

  12. 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)

  13. 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)

  14. 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)

  15. 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)

  16. 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)

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

    Gravatar image committed: 14 Jan 2020 20:59

  18. 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)

  19. 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)

  20. 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

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

    Gravatar image committed: 13 Jan 2020 14:13

  22. 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)

  23. 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)

  24. 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)

  25. 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)

  26. 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)

  27. 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)

  28. 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)

  29. 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)

  30. 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)

  31. 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)

  32. 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)

  33. 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)

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

    Gravatar image committed: 01 Jan 2020 18:51

  35. 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)

  36. 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)

  37. 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

  38. 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

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

    Gravatar image committed: 01 Jan 2020 11:52

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

    Gravatar image committed: 01 Jan 2020 11:50

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

    Gravatar image committed: 01 Jan 2020 11:44

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

    Gravatar image committed: 01 Jan 2020 11:42

  43. 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)

  44. 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

  45. 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

  46. 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)

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

    Gravatar image committed: 27 Dec 2019 17:19

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

    Gravatar image committed: 27 Dec 2019 09:05

  49. 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)

  50. Issue #12: Implement TSQLiteQuery.TableName, and
    * free Psqlite3_stmt later, in TSQLiteGridRows.Destroy, not in TSQLiteConnection.Query directly after execution
    * move code from TAdoDBQuery.TableName to TDBQuery.TableName, as this is generic SQL parsing which works for all layers (though not so reliable)

    Gravatar image committed: 27 Dec 2019 08:30