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

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

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

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

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

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

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

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

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

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

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

    Gravatar image committed: 14 Jan 2020 20:59

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

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

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

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

    Gravatar image committed: 13 Jan 2020 14:13

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

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

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

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

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

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

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

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

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

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

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

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

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

    Gravatar image committed: 01 Jan 2020 18:51

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

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

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

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

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

    Gravatar image committed: 01 Jan 2020 11:52

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

    Gravatar image committed: 01 Jan 2020 11:50

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

    Gravatar image committed: 01 Jan 2020 11:44

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

    Gravatar image committed: 01 Jan 2020 11:42

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

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

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

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

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

    Gravatar image committed: 27 Dec 2019 17:19

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

    Gravatar image committed: 27 Dec 2019 09:05

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

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

  45. Issue #12: On "Host" tab, prefer visible filename over visible file path

    Gravatar image committed: 25 Dec 2019 12:58 compiled: 25 Dec 2019 13:27

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

  46. Issue #12:
    * define and use SQLite column datatypes, at least the few groups (int, text, real, blob, date)
    * TSQLiteConnection.GetThreadId now returns the application process id, as there is no connection pid in SQLite

    Gravatar image committed: 25 Dec 2019 12:34 compiled: 25 Dec 2019 12:57

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

  47. Introduce experimental implementation of SQLite support, alias "Jingle Bells v2", for issue #12

    Gravatar image committed: 24 Dec 2019 14:32 compiled: 24 Dec 2019 14:40

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

  48. Revert a part of commit:7ed97b3fe2f989b19bd282ae00c64de8e7b4871d which should have fixed a resizing bug on the query helpers box. See https://www.heidisql.com/forum.php?t=35096

    Gravatar image committed: 19 Dec 2019 21:25 compiled: 19 Dec 2019 21:57

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

  49. Use the newer KNOWNFOLDERID TGUID constants from Winapi.KnownFolders instead of CSLID integer constants. Probably fixes wrong FOLDERID_RoamingAppData folder for #815

    Gravatar image committed: 18 Dec 2019 21:36 compiled: 18 Dec 2019 21:57

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

  50. Make TDBObject.IsSameAs more crash stable, in case the second object is nil. See https://www.heidisql.com/forum.php?t=35109

    Gravatar image committed: 16 Dec 2019 08:11 compiled: 16 Dec 2019 08:28

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