HeidiSQL 12.8 with support for encrypted SQLite databases and SSL/MySQL bugfixes

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

Hello Asgard,

First, I wanted to congratulate you on creating the best SQL manager on the internet, without a doubt, the best of them all.

I have been an active user of Heidi for many years. This is the first time I am writing, but I encountered an issue with organization. What are the possibilities of creating folders or groups within the application to make it easier to organize tables, views, and stored procedures? There are projects with a large number of tables, and having them organized would be ideal.