HeidiSQL Files

Get it from the download page

3rd party updates: * Update plink executables to v0.83. See https://www.chiark.greenend.org.uk/~sgtatham/putty/ * Update MariaDB Connector/C to v3.4.5. See https://mariadb.com/kb/en/mariadb-connector-c-3-4-5-release-notes/ * Update SQLite libraries to v3.50.1. See https://www.sqlite.org/ * Update SQLite multiple cipher libraries to v2.1.3. See https://github.com/utelle/SQLite3MultipleCiphers/releases/

New stuff: * Issue [#604]: add context menu item "Select top 1000 rows" * Issue [#2175]: if asShowRowId option is enabled, show also the index of columns in their header, through the OnAdvancedHeaderDraw/ownerdraw event * Issue [#2168]: select rows from table to export by its primary key columns, so PostgreSQL does not apply a random sorting * Issue [#2155]: paint session background and icon in session drop-down of SQL export dialog * Issue [#2107]: add "invert check" menu item on table tools tree * Issue [#2068]: support MariaDB's new VECTOR index in table designer, without M and DISTANCE settings yet * Issue [#2068]: support MariaDB's new VECTOR data type in table designer, categorize as binary * Issue [#2083]: add menu item "Copy all lines" for copying visible and initialized nodes from any VirtualTree instance as CSV data * Issue [#1975]: add "keep asking" checkbox to reformat dialog * Issue [#646]: forget setting for "Favorite objects only" on each connection start * Issue [#2064]: support UTF-8 BOM encoding when loading and saving editor files

Bugfixes and enhancements: * Issue [#1253]: fix index creation on PostgreSQL tables, use separate CREATE INDEX queries * Issue [#2187]: Fixed EAccessViolation when closing editor while using non-default theme * Create helper table with the servers' default engine when exporting a view. See https://www.heidisql.com/forum.php?t=44125 * Issue [#2186]: fix wrong number of rows shown in grid export dialog when post filter is active * Issue [#2118]: activate legacy-stdio-prompts mode in plink SSH tunnel, to fix non prompted passphrase since plink 0.82 * Issue [#604]: sync number of rows to query with the per-page data grid setting * Issue [#604]: support multiple tables and views selected on database tab, in new "Select top 1000 rows" feature * Issue [#2172]: fix wrong comment * Issue [#2172]: prompt for password again, when connection has timeout or broke * Issue [#2159]: fix memory leak * Issue [#2159]: SQLite: export separated table indexes, and export views and triggers * Issue [#2168]: turn off synchronize_seqscans variable in PostgreSQL mode, to be sure SELECT's show a stable row sorting. See https://www.postgresql.org/docs/8.3/runtime-config-compatible.html#GUC-SYNCHRONIZE-SEQSCANS * Issue [#1853]: try to fix column definition changes on MS SQL wrt collation quoting and default value * Issue [#2155]: high DPI fix for painting icons in SQL export target drop-down * Issue [#2156]: unescape generated column expression when loading from IS.COLUMNS * Keep retrieving exact row count on data tab header after activated via context menu, until another table has focus * Display number or rows in data tab header for views. See https://www.heidisql.com/forum.php?t=44057 * Issue [#214]: when refreshing, ask user if he wants to discard modifications in table/view/routine/... editors * Prefer Boolean over Bool type in owned code * Issue [#2139]: fix missing AND's in REQUIRE clause, and move REQUIRE clause from GRANT to ALTER USER query, as MySQL does not support that in GRANT since v8.x * Issue [#2133]: revert broken characters and encoding of apphelpers unit * implementation of Unicode logic for password encryption * Issue [#2132]: fix crash when saving an sql file previously loaded with auto-detected encoding * Issue [#2123]: prevent crash in libpq when disconnecting an already disconnected connection * Issue [#2128]: fix wrong encoding of connection string for PQconnectdb() * Issue [#2123]: fix reconnect mechanism in TPGConnection.Ping() * Issue [#2119]: optimize calculation of status bar panel widths * Issue [#1986]: do not set CLIENT_SSL flag with libmariadb, which seems to cause a "bad handshake" in mysql_real_connect() * Issue [#2103]: fix latin1 charset used with libmysql v8.x which reports "utf8mb4" by mysql_character_set_name() * Issue [#2101]: attempt to reactivate progress bar in status bar when running through Wine, now with a safety check for IsWindow() * Update default functions-mysql.ini with predefined line breaks and much more help content * Update functions-mysql8.ini with predefined line breaks and much more help content * Enable padding in multiline tooltips with a derived THintWindow class * Reduce web page openings to once after successful nightly update * Wrap long lines in data type hints. See https://www.heidisql.com/forum.php?t=43881 * Simplify and optimize functions generator for MariaDB, and update functions-mariadb.ini with predefined line breaks * Issue [#2095]: fix wrong/no control characters used when changing format to Excel csv via file-save dialog * Issue [#2083]: use empty field delimiter and tab separator for new copy-lines feature * Issue [#2085]: tell TStringStream.Create not to free its TEncoding object after usage, as we use application-lifetime-available encoding instances * Issue [#2084]: show numeric values in variables tab locally formatted in a tooltip * Show type of exception happening through AppSettings.ExportSettings * Issue [#835]: move prompt for overwriting output file from save-dialog to later when exporting is started, catching cases where the previous filename is used * Issue [#2079]: work with the "default" set of SQLite encryption parameters, not the transient ones * Prevent connection activity through hovering table token while user query is running. Similar to issue [#278]