HeidiSQL Files

Get it from the download page

3rd party updates: * Upgrade to Delphi 12.1 compiler * PostgreSQL: Add libpq-17.dll v17.0.2 * Issue [#2022]: Update libpq-15.dll to v15.0.10 * Issue [#2022]: Update OpenSSL libraries used by libpq-15.dll to v3.4.0 (64 bit only), taken from https://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries * Issue [#2022]: PostgreSQL: update OpenSSL libraries to v1.1.1s, taken from https://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries * Update SQLite libraries to v3.48.0.0, and SQLite multiple cipher libraries to v2.0.2.0 * Update libmariadb and plugins to current GA release v3.4.3 * Issue [#2036]: update vcl-styles-utils code to their current master branch state * Update style file from Delphi 12.1. Related to https://www.heidisql.com/forum.php?t=43616

New stuff: * Show editor hints for string literals, revealing their character length * Show editor hints for routine tokens, with routine parameters, comment and body * Show table columns with datatype in table token hint (screenshot) * Issue [#872]: add support for creating and altering INVISIBLE columns in table editor with MariaDB 10.3.3 and MySQL 8.0.23 (screenshot) * Issue [#2066]: support MSOLEDBSQL ADO providers with version postfix for MS SQL (screenshot) * Issue [#1975]: add preference option to skip dialog for selecting the SQL reformatter (screenshot) * Issue [#1777]: basic support for function key parts in MySQL 8.0+ (screenshot) * Show editor hints for SQL functions, data types, tables and procedures when mouse hovers a token * Show function description text in hint panel when using the completion proposal * Issue [#2046]: support 4 different SSL verification levels on PostgreSQL * Issue [#2035]: support new REPLICA MONITOR admin privilege on MariaDB 10.5.9+ * Issue [#2009]: basic implementation of a data generation tool, in table tools dialog (screenshot) * Issue [#2004]: load and display SQLite triggers in database tree and tab * Issue [#619]: support spatial columns with an SRID in table editor, on MySQL 8.0+ (screenshot) * CSV import: add checkbox option for keeping dialog open after successful import, so the user may process multiple files with less clicks (screenshot)

Bugfixes and enhancements: * Fix incompatible parameters for OnDragDrop event on some VirtualTree's * Code readability: use named constants for column indexes on table editor * Issue [#1777]: indicate functional key part in table editor with a different icon * Issue [#2071]: * drop 32bit mode from installer * update copyright year in license file * [#1296]: remove VC redistributable package (will be replaced by a note on the download page) * Issue [#2071]: provide 3 new languages by InnoSetup installer * Fix non-painted pasted columns in table editor * Issue [#2063] and [#2002]: repaint database tree after filtering * Issue [#2035]: rename REPLICA MONITOR privilege to SLAVE MONITOR, which seems to be the preferred name in MariaDB * Issue [#2003]: set no column for auto-sizing, in foreign key list * Issue [#2038]: fix empty preview panel on first click in image blob * Issue [#2050]: Add new line at end to support comments at the end of a view definition * Issue [#2058]: create a more complete functions-postgresql.ini from the documentation on postgresql.org * Put key icons besides column names in completion proposal * Issue [#2051]: fix unused column default value when creating a new grid row, if that default value is a simple integer expression * Issue [#2024]: fix slow grid export * TMySQLConnection.SetOption: find defined name of option constant per RTTI and show it in error message (when setting failed) * Issue [#1426] and issue [#1768]: minor: do not try to set MARIADB_OPT_TLS_VERSION option with libmysql * Issue [#1426] and issue [#1768]: * fix value of MYSQL_OPT_SSL_VERIFY_SERVER_CERT constant, hopefully fixing SEC_E_ALGORITHM_MISMATCH with libmariadb * disable MYSQL_OPT_SSL_VERIFY_SERVER_CERT if SSL checkbox is not checked, required since libmariadb C Connector 3.4.0 * show colored warnings in log panel for each failing mysql_options() call * Issue [#2041]: categorize PostgreSQL's MONEY type from floats into text types, to fix exports and editing localized values including a currency symbol * Issue [#1253]: minor code simplification and inline documentation * Issue [#2040]: fix new crash through accessing non existent ActiveGrid * Issue [#1253]: fix queries for dropping primary or unique key in PG tables * Issue [#2040]: when closing a query tab, cancel cell editor if active, preventing crash * Table editor: fix crash happening through clear indexes button * Issue [#1981]: increase contrast for colored text in privilege tree with dark styles * Attempt to fix DLL hijacking issue with DWrite.dll per manifest * Issue [#2036]: disable clickable anchors in message dialogs when current style is dark, to work around unreadable text * Issue [#1992]: Escape ampersand in caption of menus and tabs, preventing underlined hotkey generation for names of session, database and tables * Issue [#2031]: Cast MySQL's JSON type columns to literals in WHERE clause of grid UPDATEs and DELETEs. Similar to PostgreSQL's colName::text / issue [#769] * Issue [#922]: remove milliseconds from exported date/time values in Excel mode * Issue [#278]: prevent connection activity through hovering status bar while a query is running * Issue [#1965]: remove unused variable * Issue [#321]: leave away name of indexes when creating a table on PostgreSQL * Issue [#2000]: disable multiline feature in grids, even when setting "Lines of text in grid rows" is larger than 1. Aims to fix laggy performance in grid with large contents. * Enable loading first part of JSON columns in grid, enhancing scroll performance * Issue [#2014]: code refactor: move ParseSSLSettings into TUser class * Issue [#2014]: user manager: parse SSL settings from SHOW CREATE USER, but also keep parsing SHOW GRANTS for backward compatibility * Issue [#2011]: pre-select a reasonable collation if the servers default collation is not set or not yet supported by Heidi * Issue [#1907]: fix missing assignments in TDBObject.Assign, causing a default AvgRowLen of -1 which slows down the SQL export * Code cleanup: Make use of TDBConnection.Has(TFeatureOrRequirement) in more MySQL related code * Issue [#2007] and issue [#1965]: use the previous RowsAffected value after ShowWarnings in grid update * Issue [#2006]: enhance foreign key combo editor in grid for long item text, so the items show a hint in mouse-over * About box: show Delphi version behind compiled date * Issue [#1998]: fix non-scaled title text font in completion proposal * Issue [#1991]: check if left part of table name up to a dot lives in the database list. If not, assume it is part of the table name. * CSV import: set default folder and filename in open-file-dialog to the one of the selected file * Issue [#1984]: fix undefined and wrong result of TMySQLQuery.TableName when using a table alias * Move mostly empty log message to debug level * Issue [#2000]: restore partly disabled support for multi lined grid rows * Issue [#2070]: clear grid selection when jumping to next search result * Issue [#1874]: fix using "UnknownTable" when copying PostgreSQL rows in data tab * Set hint font from underlying SQL editor, to apply a better formatting * Issue [#2053]: add debug log lines in all places where a sorting is created or restored * Issue [#2063] and [#2002]: repaint database tree after filtering * Fix Delphi error message saying SynEdit's OnDropFiles declaration has an incompatible parameter list