(packaging) Create .rpm package through Makefile, plus let GH action run that step in release mode - (fc728cf)
Create checkbox in advanced session setting for new ForceUnicode setting - (75a0f7f)
Create opt-out setting "ForceUnicode", for sessions which shall not force Unicode communication - (ed9a94f)
Enable connection port visible in a column of the session tree - (7cfdb97)
Display auth plugin in a new column of the user listing tree - (3e4f562)
Support authentication plugin selection in user manager - (07112a0)
Grid export option for exporting the focused grid column only - (d896680)
Bypass automatic foreign key lookup in data grid editing through new menu item - (a5ae04b)
Add a separate menu item "copy formatted text", using the old code for copying SynEdit-highlighted text as HTML - (84c63c6)
Filter edit box for shortcuts in preferences - (fb243fc)
Create CLI app for adding PE security flags to heidisql.exe - (3e797e2)
Rename snippet per right-click on query helpers tree - (7171e48)
Name columns in SELECT when exporting table with invisible columns - (1799b0d)
Support invisible indexes on MySQL 8.0+ and ignored indexes on MariaDB 10.6+ - (b3fa484)
Support assigning a default role to a user - (96d2aef)
Support assigning roles to a user or role - (96717cd)
Do not require MySQL's RELOAD privilege just for opening the user manager - (f79d9a5)
When nodes are filtered, change "Check all" action to "Change all visible" - (ebd60b3)
Disable role rename, add menu item for creating a role, support role deletion - (83472c5)
Prevent editing contents of generated columns in data grid - (9ecdff0)
Basic support for MariaDB user roles, loaded without SQL error and shown with a different icon - (3249401)
Add context menu item for deleting a single query from the history - (0035d5e)
Reset a table's current auto_increment value in "delete + insert data" mode - (0422bb3)
Support cancelling server login dialog - (e5b9574)
Keep EXPLAIN output format traditional, on newer MySQL servers - (90f9937)
Make HTML export dark/light mode aware - (dc046e9)
Allow setting database to in PostgreSQL connections, and show and in the pulldown selector - (950e2ca)
🚀 Enhancements
Disable plugin selector as long as no user was selected - (54dd7d8)
Do not copy default type and value from previous column when adding columns to a table - (42a061d)
Suppress dialog for saving modified SQL on app close, when tabs get auto-restored - (4ca01d9)
Remove FLUSH PRIVILEGES from the user managers FormShow handler. If a click on a non-flushed user in the tree produces an exception, that is caught and shown as a normal error message. - (fe7a5ef)
50% black grid lines, should fit on both light and dark theme - (1872916)
Increase supported table size and row limit for quick filter menu showing distinct values - (48eca57)
🐛 Bug Fixes
(ui) Filter away vertical writing fonts with an @ prefix - (1814ee9)
(ui) Size and margin of buttons on SQL help dialog - (61bc258)
(ui) Apply the same larger tree node height on Linux - (c770406)
(ui) Remove default "add user" event from add button, turn it into a pure dropdown button - (d7910c1)
Copy table dialog crashes when none of dbtree and listtables has Focused=True - (9216061)
Prefer SHOW KEYS over SHOW INDEXES, which are synonyms, while very old servers only accept the one with KEYS - (b97122c)
Prevent grid queries from doing "WHERE intcol::text = 1", due to "1" being incompatible to the text value on the left - (bcea889)
Create SQL export option for wrapping DML commands in a BEGIN/COMMIT transaction - (5560454)
Display approximate row count of tables in database tab on MS SQL - (146044f)
Support full table status option in SQLite, showing "Rows" from COUNT(*) for each table - (422935a)
Add security policy for supported versions and reporting - (7ce4a23)
Prefer KILL QUERY over KILL on MySQL and MariaDB, when using the "Kill process" menu item in Host > processlist - (b3743d8)
New attempt to leave the main window invisible behind the session manager - (be5322c)
Show virtual, stored and hidden columns in SQLite - (0a87a73)
🚀 Enhancements
Move color scheme submenu from Tools to Display menu - (f7f90e8)
Export tables which are hidden through the table filter - (42e5277)
🐛 Bug Fixes
Crash on macOS, due to running Connection.ShowWarnings directly in the TQueryThread - (d62807a)
Less aggressive debug compile mode, made the app unresponsive when trying to close - (8d48099)
Two more exception causes found in uploaded reports - (e33ea1d)
Sporadic "no database selected" when updating grid header with row details - (c9eb765)
Wrong use of Copy(), which is one-based not zero-based, and remove translated appendix to snipped log message which may use critical chars and confuse SynEdit - (e3fc3f5)
Various crash causes, reported in uploaded bug reports - (6215d19)
Missing required package LazControls for TSpinEditEx - (519a84a)
Remove default keystrokes from query editor: 2x ecRedo and 1x ecDeleteLine - (2bc9d78)
Wrong SQL on MS SQL when renaming table per table editor - (a763fd1)
Use default brew path to sshpass on macOS - (b7c3d07)
Status bar text gets written into the panel right besides the current one, on Linux/macOS - (dfb86d5)
Several crash causes Host subtabs when connection is lost externally - (1029657)
Non stored global setting for "sort alphabetically" checkbox in column selection - (0ccb1ac)
High CPU load and unresponsiveness through SynEdit highlighter when starting to edit large text in popup editor - (676fcd7)
Crash when enabling TShellListView.MultiSelect in OnFormShow, now sets options per setter method, before FormShow - (2acce35)
Crash on right-click in empty area of query result grid - (6309305)
Data grid context menu not opening after click in empty area - (10fc117)
Repaint columns list after move up/down a column - (6a0cbe3)
Out-of-memory error in call to sqlite3_open() on a non-existent SQLite database file - (e93924f)
Font bold + italic setting not stored in settings - (cc5b811)
Potentially crashing typecast in LoadRecentFilter - (da07591)
Initial FK names assigned in TfrmTableEditor.listForeignKeysNewText() were lacking the referencing table's table name in case the referencing table was not created yet (pr from Jochen Neubeck) - (d8cd61c)
Wrong schema queries in SQLite, always shows columns and indexes of first database file - (7072986)
BIT values in MS SQL grid queries prefixed with MySQL b'' style - (7456c38)
Random crash in dodgy typecast TEdit/TEditButton - (37add0f)
Crash when moving added column to very bottom - (b739799)
Load any foreign keys, anyway if the user owns them, on PostgreSQL - (dbab4cb)
Wrong captions on quick filter actions shown in preferences > shortcuts - (3e0bf91)
Crash in OpenTextFile, for a 0-bytes file - override the encoding to one without BOM - (27e26a6)
Keep column default value in table editor, when user changes its datatype to one in the same category as before (int => bigint) - (3c518ad)
Trim away spaces around name of routine parameter silently - (b681ebf)
Re-enable dropping sql files on main form - (314db47)
Missing translations, and rephrase the "themes not supported" text - (7dfad02)
TDBQuery.TableName always returned an empty string on MS SQL - (520a90c)
TDBQuery.Col() crashes with "Column not available" on certain locales - (a01acd1)
Reset DesignTimePPI in all forms from 120 to the default 96, let the IDE scale controls down and move or add some defaults like LCLVersion. - (e635ae5)
Allow $$ as delimiter again on non-PostgreSQL connections, and ` on non-MySQL connections - (71bb25b)
🚜 Refactor
Migration from Array[TSQLSpecifityId] to TSqlProvider - (31ba8bf)
Make grid-highlight-same-text-color part of the predefined color schemes - (7854157)
Switch color scheme from Tools main menu - (c8c3b23)
Introduce global AppColorSchemes for managing SQL and grid colors, and sync both with the app's dark mode (still only on Windows) - (d313a59)
Sync active line color and brace highlight with the app's dark or light mode - (3510728)
Auto-switch to dark or light SQL colors in sync with the app's dark mode - (8a08e77)
Support dark mode, using MetaDarkStyle from OPM, and provide the 3 known custom settings: automatic, light and dark - (3f9e867)
Re-enable dropping files from file manager to "insert files to BLOB" dialog - (23fc9c0)
Upgrade DPI awareness to Per-Monitor v2, add TMainForm.FormChangeBounds as a replacement for the missing OnAfter/OnBeforeMonitorDpiChanged events - (9eab28e)
Re-enable menu item on list header context menu: "Toggle visibility of all columns" - (41169f7)
Support European umlauts/accents as \w (word char) in some regular expression areas - (304cd26)
Auto-uppercase keywords, data types and functions - (62cda84)
Recreate previous state of trigger after realizing the user edited code has errors - (e7e5e11)
Create a TSynEditMarkup descendant and use it for highlighting selected text occurrences - (8a667f2)
Create custom setting so the user may define a terminal app himself, and auto-detect terminal app if the setting is yet empty - (613e207)
Enable InnoSetup script for creating Windows installer - (317edcd)
Re-enable codepage => charset mapping using GetACP from DelphiCompat unit - (79e4654)
Re-enable ValidFilename function with platform specific lists of disallowed characters - (f3a0594)
Re-enable support for hyperlinks in message dialogues, and use TTaskDialog again for simple messages on Windows - (15eb52b)
Support portable mode with a portable.lock file in the app folder - (c528c5d)
ERangeError when editing text grid values which allow more than 2^31 chars, e.g. LONGTEXT - (42b5d52)
Set default value for ThemeIsDark for cases where AppleInterfaceStyle does not exist (= light mode) - (26ca75e)
Reload color scheme after auto-apply, reintroduce ThemeIsDark with a detection for Windows and macOS, use MetaDarkStyle units only on Windows - (b4afc3a)
Invalid typecast in List.Add(BaseForm.Components[i]), when running debug builds - (38faf57)
Wrong length of text detected (always 0) - (930a815)
Crash in data grid when switching to an empty table on ArchLinux - (e9b6835)
Next attempt to fix ERangeError crash in TBaseVirtualTree.UpdateVerticalRange - (c8e8bed)
Wrong ModalResult on "Replace all" button - (2367ac6)
Create SQL export option for wrapping DML commands in a BEGIN/COMMIT transaction - (5560454)
Display approximate row count of tables in database tab on MS SQL - (146044f)
Support full table status option in SQLite, showing "Rows" from COUNT(*) for each table - (422935a)
Add security policy for supported versions and reporting - (7ce4a23)
Prefer KILL QUERY over KILL on MySQL and MariaDB, when using the "Kill process" menu item in Host > processlist - (b3743d8)
New attempt to leave the main window invisible behind the session manager - (be5322c)
Show virtual, stored and hidden columns in SQLite - (0a87a73)
🚀 Enhancements
Move color scheme submenu from Tools to Display menu - (f7f90e8)
Export tables which are hidden through the table filter - (42e5277)
🐛 Bug Fixes
Crash on macOS, due to running Connection.ShowWarnings directly in the TQueryThread - (d62807a)
Less aggressive debug compile mode, made the app unresponsive when trying to close - (8d48099)
Two more exception causes found in uploaded reports - (e33ea1d)
Sporadic "no database selected" when updating grid header with row details - (c9eb765)
Wrong use of Copy(), which is one-based not zero-based, and remove translated appendix to snipped log message which may use critical chars and confuse SynEdit - (e3fc3f5)
Various crash causes, reported in uploaded bug reports - (6215d19)
Missing required package LazControls for TSpinEditEx - (519a84a)
Remove default keystrokes from query editor: 2x ecRedo and 1x ecDeleteLine - (2bc9d78)
Wrong SQL on MS SQL when renaming table per table editor - (a763fd1)
Use default brew path to sshpass on macOS - (b7c3d07)
Status bar text gets written into the panel right besides the current one, on Linux/macOS - (dfb86d5)
Several crash causes Host subtabs when connection is lost externally - (1029657)
Non stored global setting for "sort alphabetically" checkbox in column selection - (0ccb1ac)
High CPU load and unresponsiveness through SynEdit highlighter when starting to edit large text in popup editor - (676fcd7)
Crash when enabling TShellListView.MultiSelect in OnFormShow, now sets options per setter method, before FormShow - (2acce35)
Crash on right-click in empty area of query result grid - (6309305)
Data grid context menu not opening after click in empty area - (10fc117)
Repaint columns list after move up/down a column - (6a0cbe3)
Out-of-memory error in call to sqlite3_open() on a non-existent SQLite database file - (e93924f)
Font bold + italic setting not stored in settings - (cc5b811)
Potentially crashing typecast in LoadRecentFilter - (da07591)
Initial FK names assigned in TfrmTableEditor.listForeignKeysNewText() were lacking the referencing table's table name in case the referencing table was not created yet (pr from Jochen Neubeck) - (d8cd61c)
Wrong schema queries in SQLite, always shows columns and indexes of first database file - (7072986)
BIT values in MS SQL grid queries prefixed with MySQL b'' style - (7456c38)
Random crash in dodgy typecast TEdit/TEditButton - (37add0f)
Crash when moving added column to very bottom - (b739799)
Load any foreign keys, anyway if the user owns them, on PostgreSQL - (dbab4cb)
Wrong captions on quick filter actions shown in preferences > shortcuts - (3e0bf91)
Crash in OpenTextFile, for a 0-bytes file - override the encoding to one without BOM - (27e26a6)
Keep column default value in table editor, when user changes its datatype to one in the same category as before (int => bigint) - (3c518ad)
Trim away spaces around name of routine parameter silently - (b681ebf)
Re-enable dropping sql files on main form - (314db47)
Missing translations, and rephrase the "themes not supported" text - (7dfad02)
TDBQuery.TableName always returned an empty string on MS SQL - (520a90c)
TDBQuery.Col() crashes with "Column not available" on certain locales - (a01acd1)
Reset DesignTimePPI in all forms from 120 to the default 96, let the IDE scale controls down and move or add some defaults like LCLVersion. - (e635ae5)
Allow $$ as delimiter again on non-PostgreSQL connections, and ` on non-MySQL connections - (71bb25b)
🚜 Refactor
Migration from Array[TSQLSpecifityId] to TSqlProvider - (31ba8bf)
Make grid-highlight-same-text-color part of the predefined color schemes - (7854157)
Switch color scheme from Tools main menu - (c8c3b23)
Introduce global AppColorSchemes for managing SQL and grid colors, and sync both with the app's dark mode (still only on Windows) - (d313a59)
Sync active line color and brace highlight with the app's dark or light mode - (3510728)
Auto-switch to dark or light SQL colors in sync with the app's dark mode - (8a08e77)
Support dark mode, using MetaDarkStyle from OPM, and provide the 3 known custom settings: automatic, light and dark - (3f9e867)
Re-enable dropping files from file manager to "insert files to BLOB" dialog - (23fc9c0)
Upgrade DPI awareness to Per-Monitor v2, add TMainForm.FormChangeBounds as a replacement for the missing OnAfter/OnBeforeMonitorDpiChanged events - (9eab28e)
Re-enable menu item on list header context menu: "Toggle visibility of all columns" - (41169f7)
Support European umlauts/accents as \w (word char) in some regular expression areas - (304cd26)
Auto-uppercase keywords, data types and functions - (62cda84)
Recreate previous state of trigger after realizing the user edited code has errors - (e7e5e11)
Create a TSynEditMarkup descendant and use it for highlighting selected text occurrences - (8a667f2)
Create custom setting so the user may define a terminal app himself, and auto-detect terminal app if the setting is yet empty - (613e207)
Enable InnoSetup script for creating Windows installer - (317edcd)
Re-enable codepage => charset mapping using GetACP from DelphiCompat unit - (79e4654)
Re-enable ValidFilename function with platform specific lists of disallowed characters - (f3a0594)
Re-enable support for hyperlinks in message dialogues, and use TTaskDialog again for simple messages on Windows - (15eb52b)
Support portable mode with a portable.lock file in the app folder - (c528c5d)
ERangeError when editing text grid values which allow more than 2^31 chars, e.g. LONGTEXT - (42b5d52)
Set default value for ThemeIsDark for cases where AppleInterfaceStyle does not exist (= light mode) - (26ca75e)
Reload color scheme after auto-apply, reintroduce ThemeIsDark with a detection for Windows and macOS, use MetaDarkStyle units only on Windows - (b4afc3a)
Invalid typecast in List.Add(BaseForm.Components[i]), when running debug builds - (38faf57)
Wrong length of text detected (always 0) - (930a815)
Crash in data grid when switching to an empty table on ArchLinux - (e9b6835)
Next attempt to fix ERangeError crash in TBaseVirtualTree.UpdateVerticalRange - (c8e8bed)
Wrong ModalResult on "Replace all" button - (2367ac6)
For a list of all the changes up to date, please read CHANGELOG.md.
Tip
This version has problems loading libmariadb library. The issue will be fixed in the next release. To work around in this release you may switch to libmysqlclient instead. If the library drop-down does not show libmysqlclient, install it via sudo apt install libmysqlclient-dev.
Log in
