HeidiSQL Files

Get it from the download page

3rd party updates: * Issue [#1946]: update C connector / libmariadb.dll and plugin libraries to latest v3.3.10

New stuff: * Issue [#1284]: add support for encrypted SQLite databases, using the C API from utelle/SQLite3MultipleCiphers * Issue [#1964]: support MariaDB's INET4 and INET6 data types * Issue [#1604]: support creating table indexes on SQLite * Issue [#1604]: support adding primary key to new tables, which needs to be done inside the CREATE TABLE code * Issue [#1605]: support dropping table indexes on SQLite * Issue [#1965]: show warnings from custom queries in the bottom log panel, right when they occur, not at the very end of a batch * Issue [#1428]: debug logging of query time and network time after each result-query * Issue [#1972]: Add new security option to verify SSL certificate, in MySQL and MariaDB * Get query result tab caption list from "-- names:" comment, similar to "-- name:" in a single query

Bugfixes and enhancements:

• Issue [#1768] and issue [#1426]: fix wrong mysql_options() constants for libmysql v8+, to fix SSL connections to servers with OpenSSL 3.x, throwing a SEC_E_ALGORITHM_MISMATCH error. Thanks a lot to Justin Fiedler and Gurianoff for helping out.
• Issue [#1330]: Use custom tab width and tabs-to-spaces setting uniquely in all places where we generate code.
• Issue [#1956]: Fix retrieval of PG foreign keys on table names which exist in multiple schemata.
• Support zooming per mouse wheel in the procedure editor and log panel
• Issue [#1951]: Add CURRENT_TIMESTAMP function, this time missing in the newer generated functions-mysql8.ini.
• Issue [#1763]: fix wrong DPI shown in log panel, and too high donate button after DPI change
• Issue [#1897]: Mark grid nodes with vsMultiLine, even if asGridRowLineCount option is set to 1. Fixes endlessly received WM_PAINT messages on results with large lines and tabs in it.
• Issue [#1948]: hide menu item for Sequal Suggest dialog.
• Issue [#634]: fix HTML in message dialog text containing URLs with trailing double quote
• Issue [#1959]: fix shrinking/repositioned edit boxes in options tab of table editor, when opening a second table.
• Fix and improve exporting in PHP format (@mlocati)
• Quote restart command in scheduled task item generated by auto-updater
• Issue [#1962]: reset width and height of completion proposal when user clicks "Reset panel dimensions"
• Issue [#1149]: reset bottom filter box after switching tables
• Issue [#1952]: change log level in TDBQuery.IsEditable from debug to info, when user tries to edit a read-only grid result, so the reason and background is more visible for most users.
• Issue [#1963]: fix doubled DPI factor of proposal width and height, due to its own scaling
• Table editor: disallow editing direction/collation of index node level
• Issue [#1604]: fix crash when showing index tab due to uninitialized SubParts and Collations in SQLite and PostgreSQL
• Silence sporadic crash in TAdoDBConnection.Destroy, found in uploaded crash reports
• Issue [#1967]: fix doubled height of donate button with certain fonts, for instance "Microsoft YaHei UI"
• Enhance TConnectionParameters.IsMySQL, to turn "MySQL or MariaDB 8.0" into "MySQL 8.0" in status bar
• Issue [#1971]: downsize VARCHAR length to 1 for temporary MySQL tables for views, to work around "Row size too large" error
• Issue [#1935]: indicate unaccepted drop target when dragging folder or session over its current folder