HeidiSQL 9.5 released

This is a bugfix release with a few new features and enhancements.

Grab it from the download page

• New features:

• Expect regular expression in filter text on right panel, not a simple string. Keep searching case insensitive, as in prior logic. Add text hint to filter box so the user knows he can enter a regular expression here. Closes #45.

• Add new TAction for clearing query log, and assign it to the rightclick menu item of it. Give this new action the hotkey Ctrl+Q. Closes #25.

• Add custom setting for number of days to keep queries in the query history. See https://www.heidisql.com/forum.php?t=23530

• Use the grid export dialog for setting values for copy-to-clipboard clicks on grids. Adds a new button in the lower left on that dialog. See https://www.heidisql.com/forum.php?t=23190

• Support grouping by tree node type in "check xyz" menu items on table tools dialog. See https://www.heidisql.com/forum.php?t=23351

• Include ADO connection string in status bar connection details, shorten the lines reasonably and show the full lines in a message box when clicking on it. See http://www.heidisql.com/forum.php?t=23049

• Support SQL security setting in view editor via drop down menu. See http://www.heidisql.com/forum.php?t=21740

• Use the right SQL commands for killing a process on PostgreSQL. See http://www.heidisql.com/forum.php?t=21760

• Bugfixes:

• Prevent accessing non existing string list item in TMainForm.ListDatabasesGetText, to fix a sporadic crash after dropping a database. Closes #33

• Temporarily disable local number formatting in data grid while the search dialog is open. Closes #30.

• Prevent TMainForm.DisplayRowCountStats from crashing due to no current table/view/...

• Don't export data for virtual columns. Fixes #5.

• Simplify regular expression for extracting column details in ParseTableStructure(), so it does not barf on huge length/set. Fixes issue #2.

• New attempt to fix menu and buttons flicker on Win10, this time by with the help of Delphi Detours library. See https://www.heidisql.com/forum.php?t=19141

• fix exception in early stage of table editor initialization

• Fix detection of column types with DEFAULT CURRENT_TIMESTAMP(123). See https://www.heidisql.com/forum.php?t=17585

• Reduce flicker on Windows 10. See https://www.heidisql.com/forum.php?t=19141

• Silence dumb exceptions from mysql_ping() call. See https://www.heidisql.com/forum.php?t=23483

• Fix typos in encoding of xml exports. See https://www.heidisql.com/forum.php?t=23421

• Prevent inserting cell text ellipsis in query tab. See https://www.heidisql.com/forum.php?t=23353

• Work around access violation in highlighter, which raises after a successful reconnect. See http://www.heidisql.com/forum.php?t=23009

• Fix sloppy regular expression in TDBConnection.DetectUSEQuery which removes too much of trailing quotes in a database name. See http://www.heidisql.com/forum.php?t=22743

• Escape quotes and stuff in JSON keys and values. See http://www.heidisql.com/forum.php?t=22747

• PostgreSQL: query timeout is set in milliseconds, not seconds. See http://www.heidisql.com/forum.php?t=22645

• Inject a line break after the data grid WHERE filter and before a potential ORDER BY and/or LIMIT clause. This way the filter may end with a comment without breaking the rest of it.

• Fix compiler warning

• Fix crash when taskbar button interface is not available for some reason. See http://www.heidisql.com/forum.php?t=22451

• Enhancements:

• Support quote chars other than the relevant one within identifiers. For example "mycolumn" or "mycolumn" ... or even worse: "``mycolumn". Closes #44.

• Send donators’ e-mail addresses encrypted

• Update url to issue tracker and copyright year

• SynEdit's SQL highlighter provides a sample source text. Display that text in the preferences editor panel for SQL colors.

• Update gettext binaries, from http://svn.code.sf.net/p/dxgettext/code/trunk/buildtools . The old msgfmt.exe creates endless processes on Win10, not so this one.

• Remove debug code. See https://www.heidisql.com/forum.php?t=24400

• Extend TMySQLOption enumeration with newer items

• unify context menu of various sql editors, by supporting all contained editors instead of searching for one with the name "SynMemoBody"

• Trigger OnChange event on TSynMemo after toggling comment, so a save button gets enabled. See https://www.heidisql.com/forum.php?t=23834

• Save session tree color when creating a copy of a session. See https://www.heidisql.com/forum.php?t=23796

• Use new copy-columns icon in main image list

• Create a nicer icon for "Copy selected columns/rows"

• Create a new menu item for copying rows to clipboard, and assign Ctr+Shift+C to it. See https://www.heidisql.com/forum.php?t=23190#p23490

• Support auto_increment flag on indexes other than primary or unique, on copy table dialog. If that still fails, give the user a hint to select the right index. See https://www.heidisql.com/forum.php?t=23383

• Add "<server default>" to the engine drop down on the table editor, and make that the new default, so we leave the ENGINE=.. clause away. See https://www.heidisql.com/forum.php?t=23363

• Use HTTPS for all web requests on heidisql.com

• Update SynEdit component code to v2.0.9 beta from https://github.com/SynEdit/SynEdit/releases/tag/SynEdit-2.0.9-beta . Just a few additional highlighter keywords and one code change for background coloring included.

• Attempt to add an error string which Windows provides after a failed call to LoadLibrary. See http://www.heidisql.com/forum.php?t=22514

• Make Markdown export code compatible to the parser on gitlab.com, by using 3 dashes instead of 1, below header columns. See http://www.heidisql.com/forum.php?t=22991

• Increase width of "name" field on view editor to the same value as it's on the procedure editor.

• Reasonably increase and unify design time dimensions of object editors to 700x500 pixels

• Remove per-row comment in PHP array grid export, which blows up the result. See http://www.heidisql.com/forum.php?t=22749#p22798

• Don't encode html entities but escape quotes in JSON grid export. See http://www.heidisql.com/forum.php?t=22747#p22783

• Use double quotes for PHP values when exporting a PHP array from a grid. See http://www.heidisql.com/forum.php?t=22749

• Try to load libpq.dll with explicit file path if the path-less did not succeed. See http://www.heidisql.com/forum.php?t=22514

• Cast unknown data type columns as text when generating a multi column filter from user input. See http://www.heidisql.com/forum.php?t=22562

• Remove quirky logic from TMySQLQuery.Execute when distinguishing between text and binary data types. See http://www.heidisql.com/forum.php?t=22441