HeidiSQL/HeidiSQL 9.5

on GitHub

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 "" 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