HeidiSQL

What's new in this version:

3rd party updates:
- Update plink executables to v0.83
- Update MariaDB Connector/C to v3.4.5
- Update SQLite libraries to v3.50.1
- Update SQLite multiple cipher libraries to v2.1.3

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

Bugfixes and enhancements:
- fix index creation on PostgreSQL tables, use separate CREATE INDEX queries
- Fixed EAccessViolation when closing editor while using non-default theme
- Create helper table with the servers' default engine when exporting a view
- fix wrong number of rows shown in grid export dialog when post filter is active
- activate legacy-stdio-prompts mode in plink SSH tunnel, to fix non prompted passphrase since plink 0.82
- sync number of rows to query with the per-page data grid setting
- support multiple tables and views selected on database tab, in new "Select top 1000 rows" feature
- fix wrong comment
- prompt for password again, when connection has timeout or broke
- fix memory leak
- SQLite: export separated table indexes, and export views and triggers
- turn off synchronize_seqscans variable in PostgreSQL mode, to be sure SELECT's show a stable row sorting
- try to fix column definition changes on MS SQL wrt collation quoting and default value
- high DPI fix for painting icons in SQL export target drop-down
- 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
-when refreshing, ask user if he wants to discard modifications in table/view/routine/... editors
- Prefer Boolean over Bool type in owned code
- 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
- revert broken characters and encoding of apphelpers unit
- implementation of Unicode logic for password encryption
- fix crash when saving an sql file previously loaded with auto-detected encoding
- prevent crash in libpq when disconnecting an already disconnected connection
- fix wrong encoding of connection string for PQconnectdb()
- fix reconnect mechanism in TPGConnection.Ping()
- optimize calculation of status bar panel widths
- do not set CLIENT_SSL flag with libmariadb, which seems to cause a "bad handshake" in mysql_real_connect()
- fix latin1 charset used with libmysql v8.x which reports "utf8mb4" by mysql_character_set_name()
- 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
- Simplify and optimize functions generator for MariaDB, and update functions-mariadb.ini with predefined line breaks
- fix wrong/no control characters used when changing format to Excel csv via file-save dialog
- use empty field delimiter and tab separator for new copy-lines feature
- tell TStringStream.Create not to free its TEncoding object after usage, as we use application-lifetime-available encoding instances
- show numeric values in variables tab locally formatted in a tooltip
- Show type of exception happening through AppSettings.ExportSettings
-move prompt for overwriting output file from save-dialog to later when exporting is started, catching cases where the previous filename is used
- 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