2023-11-27T09:41:32+01:00https://www.heidisql.com/rss.php?c=1,7HeidiSQL.com - Forum postsOfficial Instagram profilehttps://www.heidisql.com/rss.php?c=1,7&p=415452023-11-27T09:41:32+01:00<p>Thanks to my daughter HeidiSQL now has an official Instagram profile:</p>
<p><a rel="ugc"href="https://www.instagram.com/heidisql.official/">https://www.instagram.com/heidisql.official/</a></p>
<p>Mainly used for screenshots of HeidiSQL, especially of certain dialogs which are rather unknown but probably helpful.</p>ansgarHeidiSQL 12.6 with two new SQL formatters and static grid row idhttps://www.heidisql.com/rss.php?c=1,7&p=414192023-11-05T12:29:19+01:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a rel="ugc"href="https://www.heidisql.com/donatebutton.php?place=announcement"><img src="https://www.heidisql.com/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update <a rel="ugc"href="https://madshi.net/">madExcept</a> exception handler to v5.1.3</li>
<li>Upgrading to <a rel="ugc"href="https://www.embarcadero.com/press-releases/rad-studio-11-3-released">Delphi compiler version 11.3</a></li>
<li>Update <a rel="ugc"href="https://github.com/JAM-Software/Virtual-TreeView">VirtualTrees</a> component code to release v7.6.5a</li>
<li>Update <a rel="ugc"href="https://github.com/RRUZ/vcl-styles-utils">vcl-styles-utils</a> from current master branch</li>
<li>Update <a rel="ugc"href="https://sqlite.org/">SQLite libraries</a> to v3.44.0</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1841">Issue #1841</a>: Update <a rel="ugc"href="https://www.openssl.org/">OpenSSL</a> libraries used by libpq-15.dll to v3.1.3</li>
<li>Update <a rel="ugc"href="https://www.chiark.greenend.org.uk/~sgtatham/putty/">plink</a> executables to v0.79</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/861">Issue #861</a>: New static row id column in all result grids. Uses the session background color, and can be hidden. (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=data">see screenshot</a>)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/750">Issue #750</a>: SQL formatting now with 2 new online formatters: (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=reformat-sql">see screenshot</a>)<ul>
<li><a rel="ugc"href="https://github.com/doctrine/sql-formatter">https://github.com/doctrine/sql-formatter</a> - hosted on heidisql.com</li>
<li><a rel="ugc"href="https://sqlformat.org/">https://sqlformat.org/</a> - Thanks to Andi Albrecht!</li>
</ul>
</li>
<li>Add context menu on data grid header with "Query exact row count" item, querying <code><span class="sqlkeyword">SELECT</span> <span class="sqlfunc">COUNT</span>(*)...</code> on the underlying table</li>
<li>Support main tabs in a single line, and support tab-scrolling per mouse wheel</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/940">Issue #940</a>: Support removing shortcuts per button in preferences. (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=shortcut-customizer">see screenshot</a>)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1619">Issue #1619</a>: Use the same hotkey (<code>Ctrl+S</code>) for saving a table/trigger/... as for saving a query file.</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1863">Issue #1863</a>: Fixes compatibility to Wine v8.18 again, and probably to more versions</li>
<li>Grayscale icons on non-active tabs, for a clearer user interface (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=data">see screenshot</a>)</li>
<li>Separate double-click and middle-click options for closing tabs (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=files-and-tabs-preferences">see screenshot</a>)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1795">Issue #1795</a>: remove menu items and code for explain analyzer on <a rel="ugc"href="https://mariadb.org">https://mariadb.org</a>, which is no longer available</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1854">Issue #1854</a>: fixes incorrect table name used in grid updates when comment with valid query exists</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/279">Issue #279</a>: Support serial columns in PosgreSQL, which is different from auto_increment on MySQL</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/872">Issue #872</a>: fix crash when opening a table with columns defined as <code>INVISIBLE</code>, and ensure such columns are selected and visible in the data grid</li>
<li>Translation fixes: remove various unused strings, fix some wrong spelled strings, add some missing strings</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1850">Issue #1850</a>: too short text in popup text editor, when field contains high UTF-8 characters like emojis</li>
<li>Add missing <code>PMYSQL_LENGTHS</code> type, and use this for the result of <code><span class="sqlfunc">mysql_fetch_lengths</span>()</code>. Fixes an issue broken since 2009 (!)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1640">Issue #1640</a>: Fix crash in MouseUp event of query tab close button, by closing/freeing the tab and button through a timer event</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/752">Issue #752</a>: Fix SQL export on MySQL 8, overwriting view helper tables caused "xyz is not view"</li>
<li>Keyboard shortcuts: allow the user to accept duplicate assignments per ignore button. (<a rel="ugc"href="https://www.heidisql.com/screenshots.php?which=shortcut-customizer">see screenshot</a>)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1826">Issue #1826</a>: Fix <code><span class="sqlkeyword">ON</span> <span class="sqlkeyword">UPDATE</span></code> part of <code><span class="sqlkeyword">DEFAULT</span></code> clause with no parentheses on MySQL 8, which are required only for the initial <code><span class="sqlkeyword">DEFAULT</span></code> value.</li>
<li>Fixes numerous different crashes, found in uploaded crash reports. Thanks to all users reporting these:<ul>
<li>Fix crash after following a foreign key value</li>
<li>Fix sporadic crash "Cannot make a visible window modal" in search/replace dialog</li>
<li>Fix crash in various places where we just try to get the current clipboard text</li>
<li>CSV scanner: fix crash when selected filename cannot be opened</li>
<li>Fix sporadic crashes in various calls to [TWinControl].SetFocus, with the new class helper .TrySetFocus</li>
<li>Fix crash in highlighter customizer, as long as no attribute is selected</li>
<li>Silence a popular crash in DBtreeFocusChanged, when trying to detect whether the user clicked into a different session</li>
<li>Fix EAccessViolation in TMainForm.DBtreeFocusChanged:124</li>
<li>Fix crash when trying to stop current query and the helper connection cannot connect for some reason.</li>
<li>Silence sporadic EAccessViolation in DBtreeBeforeCellPaint, when reading DbObj.Connection.Parameters</li>
<li>Fix EAccessViolation in TDBObject.GetImageIndex:6</li>
<li>Fix EAccessViolation in TMainForm.DBtreeGetText:12</li>
<li>Catch different EInOutError exception happening in rare cases of ForceDirectories()</li>
<li>Fix EAccessViolation in TMainForm.AnyGridGetText:5</li>
<li>Fix crash when user clicks Help button on maintenance dialog, in a non-MySQL session</li>
<li>Catch additional EReadError crash in RunQueryFile</li>
<li>Fix crash in printer dialog, when printer is somehow not available</li>
<li>Fix crash after reconnect, when query helpers functions are exapanded</li>
<li>MSSQL: Catch OLE exception when provider names cannot be listed</li>
<li>Fix crash in TMainForm.DBtreeGetText happening while connecting through SSH tunnel</li>
<li>Fix sporadic crash with focused Host tab while connecting to another session</li>
<li>Warn the user about potential data loss when loading a (csv) file with encoding set to "auto-detect".</li>
</ul>
</li>
</ul>ansgarHeidiSQL 12.5 with Sequal integrationhttps://www.heidisql.com/rss.php?c=1,7&p=409432023-05-08T18:32:46+02:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1784">Issue #1784</a>: update OpenSSL libraries used by libpq-15.dll to v3.1.0, taken from <a rel="ugc"href="http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29">http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29</a></li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li>Basic implementation of Sequal Suggest as a dialog, under Tools. For generating SQL queries through natural language. See <a rel="ugc"href="https://sequal.dev/">https://sequal.dev/</a></li>
</ul>
<p><img src="/uploads/paste/2-2023-05-08_18-32-26.png" alt="Description" /></p>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1800">Issue #1800</a>: wrap column default expression in parentheses on MySQL v8.0.13+ when altering a table</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1800">Issue #1800</a>: attempt to distinguish text values from function expressions in a column's default value, for MySQL 8.0.13+ which seems to allow just all functions as default value.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1800">Issue #1800</a>: add missing CURDATE function definition to functions-mysql.ini</li>
<li>Do not cut trailing zeros in scientific values like 2.0e30 => 2.0e3. Closes #1793</li>
<li>Auto detect need to create HTML clipboard header, remove CreateHTMLHeader parameter from StreamToClipboard()</li>
<li>Refactor HTML clipboard code. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=9893">https://www.heidisql.com/forum.php?t=9893</a></li>
<li>Make HTML export format compatible to Google Chrome. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=9893">https://www.heidisql.com/forum.php?t=9893</a></li>
<li>Support ON UPDATE SET DEFAULT and the same for ON DELETE in PostgreSQL foreign keys. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40413">https://www.heidisql.com/forum.php?t=40413</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1771">Issue #1771</a>: add additional sleep time between SSH process checks, so it does not matter when WaitForSingleObject does not really wait (on Wine)</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1771">Issue #1771</a>: prefer a larger SSH process check interval for larger timeouts (timeout:4s => check interval:400ms), and log process exit code each interval.</li>
<li>Auto-set the first SSH executable from the dropdown when user activates SSH tunnel checkbox. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40399">https://www.heidisql.com/forum.php?t=40399</a></li>
<li>Support canceling SQL export before a table's data has been completed. Closes #1516</li>
<li>Ensure max INSERT setting is an Int64, so a huge value does not wrap into a negative value. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40393">https://www.heidisql.com/forum.php?t=40393</a></li>
</ul>ansgarHeidiSQL 12.4 supporting SSH tunnel on MS SQL, and many bugfixeshttps://www.heidisql.com/rss.php?c=1,7&p=403922023-02-26T12:46:46+01:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update DDetours sources to latest (2021-01-01)</li>
<li>Update vcl-styles-utils sources to latest (2021-01-11)</li>
<li>Update gnugettext.pas to rev 148 from <a rel="ugc"href="http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas">http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas</a></li>
<li>PostgreSQL: update OpenSSL libraries to v1.1.1s, taken from <a rel="ugc"href="http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29">http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29</a></li>
<li>PostgreSQL: <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1758">Issue #1758</a>: add libpq-15.dll and its 4 dependent files, all signed with my Authenticode certificate (see #1733)</li>
<li>madExcept 5.1.2, including a fix for ASLR.</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/921">Issue #921</a>: add SSH tunnel support for SQL Server in TCP/IP mode. "SSH tunnel" tab is not hidden any longer for unsupported network types, only the checkbox is disabled then.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1721">Issue #1721</a>: Let the user disable a session's SSH tunnel configuration, similar to the SSL checkbox</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li>Turn crash into error dialog, on search and replace dialog, when regular expression is invalid</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1226">Issue #1226</a>: switch back to TSynHotKey again, after using THotKey in shortcut customizer since b4926f3f579c9d82981dea59a0785dd31c040b01 . Fixes non assignable Enter and Del hotkeys, probably more. This time we don't touch the original TSynHotKey for custom fixes, but through the new TExtSynHotKey.</li>
<li>Restore previous scroll position after saving routine, trigger, event or view. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40291">https://www.heidisql.com/forum.php?t=40291</a></li>
<li>Reduce crash probability in TSecureShellCmd.Connect when user disconnects from session before tunnel is reestablished.</li>
<li>Strip comments from current query before trying to detect a table alias. Closes #1753</li>
<li>Widen import button on very first tab of session manager, so translations fit to it. Closes #1752</li>
<li>Find a better alternative to d262a6acc920083e0728c324a968f83f11f263b7 : set descending column order on first header click when shift key is pressed . See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40243">https://www.heidisql.com/forum.php?t=40243</a></li>
<li>Refactor internal structures for grid/table sorting, prefer TObjectList over Array</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1717">Issue #1717</a>: block too fast and overlapping calls of refresh action, to reduce crash probability</li>
<li>Fix crash due to reset AppSettings.SessionPath through LogSQL()</li>
<li>Attempt to fix a crash, happening in some cases when user focuses a tree node in a different connection</li>
<li>Disable ASLR and the same flag for 64 bit mode through base configuration.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1568">Issue #1568</a> and <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1737">issue #1737</a>: exit OnPaintTransient event handler on interlocked calls</li>
<li>Hide SSL tab when no session is selected</li>
<li>Prefer previously used filename in save-as-snippet dialog. Closes #1747</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1730">Issue #1730</a>: fix wrong vertical position of linebreaks dropdown</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1730">Issue #1730</a>: apply font to mother query grid as well, in ApplyFontToGrids</li>
<li>Degrade category of mostly log messages from grid editors to debug.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1744">Issue #1744</a>: load stored tab file contents always with UTF-8 encoding, to prevent a wrong encoding per auto detection.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1721">Issue #1721</a>: fix now wrong tab order with the new "SSH tunnel" checkbox</li>
<li>TConnectionParameters.GetImageIndex: prefer more specific icon for MySQL on RDS sessions</li>
<li>Update current year in license file</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1730">Issue #1730</a>: add preference option for disabling incremental search through typing in grids</li>
<li>Include some System.Generics.* units without using project's unit scopes or aliases</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1568">Issue #1568</a>: fix ineffective temporary disabling of OnChange handler</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1568">Issue #1568</a>: content in SQL editor is modified in SynMemoQueryKeyPress. Attempt to prevent some endless loop through OnChange event.</li>
<li>Remove unit scopes from project settings, prefer fully qualified unit names in uses clauses. Enhance readability and compiler performance.</li>
<li>Prefer extracted-comments style over translator-comments, which are not displayed on Transifex for some reason. See <a rel="ugc"href="https://www.gnu.org/software/gettext/manual/html_node/PO-Files.html#The-Format-of-PO-Files">https://www.gnu.org/software/gettext/manual/html_node/PO-Files.html#The-Format-of-PO-Files</a></li>
<li>Create project files for Delphi 11.2, with disabled HighEntropyVa setting so the 64bit builds will run without crash.</li>
<li>Add comment to joined short+long hint in translation. See <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/commit/8fc6dba6e3047afeaa93d817cf7424e4acd278b5#r93385116">https://github.com/HeidiSQL/HeidiSQL/commit/8fc6dba6e3047afeaa93d817cf7424e4acd278b5#r93385116</a></li>
<li>Use red background for SQL errors in log panel too. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40110">https://www.heidisql.com/forum.php?t=40110</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1722">Issue #1722</a>: rephrase text hint on filter input so it matches an existing translation string</li>
<li>Automagic modifications to form files, done through updates of IDE and some components. Especially removes no longer published properties OldCreateOrder and PixelsPerInch.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1722">Issue #1722</a>: add missing translation strings to master file</li>
<li>Fix wrong tab order of recent filters pulldown on data grid filter panel</li>
<li>Enhance user query error handling. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40085">https://www.heidisql.com/forum.php?t=40085</a><ul>
<li>try to find error position in 1M of SQL instead of only 1KB</li>
<li>do not reset cursor if position was not found</li>
<li>paint red background on line with error, just until user presses any key</li>
</ul>
</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1724">Issue #1724</a>: silence another exception in MS SQL mode, when checking for IsNull on a field. Seems to be just a different version of the same bug described in #496</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1725">Issue #1725</a>: add history menu pulldown to global filter edit box</li>
<li>Add missing translation string for new header-click option. See <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/commit/7bea342b9f1ca53aac2012387bdc6bb41892ad17#r92151280">https://github.com/HeidiSQL/HeidiSQL/commit/7bea342b9f1ca53aac2012387bdc6bb41892ad17#r92151280</a></li>
<li>Add option to turn off warning dialog for active but unused SSL settings. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40080">https://www.heidisql.com/forum.php?t=40080</a></li>
</ul>
<p><strong>Modifications for installer and updater:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1735">Issue #1735</a>: Experimental support for non administrative install mode, with the default folder C:\Users\xyz\AppData\Local\Programs\HeidiSQL\</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/811">Issue #811</a>: Make installation of example snippets optional, and display the used path.</li>
<li>Increase lzma2 compression from max to ultra64. Take up more memory for creating the installer and for installing, but decreases installers file size from 46M to 39M.</li>
<li>Do not auto-create "c:\Users\Anse\Documents\HeidiSQL\", as we only use it for snippets which can also have a custom path. Closes #1751</li>
<li>Updater: quote name of task to run, making it safe to use white spaces</li>
<li>Use Release configuration to decrease the updaters file size</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">Issue #1616</a>: Close Heidi processes through updater even if the path is different than the current app path, which is the case when running Heidi from a symbolic link folder.</li>
<li>Refactor build updater once again:<ul>
<li>convert to console application without window, so the user sees all status messages in the order of appearance</li>
<li>include SysUtils unit, which increases file size to ~2MB, but enhances maintainability</li>
<li>restrict compilation and resource inclusion to 64bit mode - the build updater is disabled in 32bit mode anyway</li>
</ul>
</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/418">Issue #418</a>: restart via task scheduler after build update, decreasing privileges to the normal user instead of administrator</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1733">Issue #1733</a>: Sign uninstaller within InnoSetup script. This also signs the installer from InnoSetup now, while removing the sign call from the build process.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1733">Issue #1733</a>: sign yet unsigned 3rd party libraries with my own Authenticate certificate</li>
</ul>ansgarHeidiSQL 12.3 with fixed auto-updater and support for MySQL on RDShttps://www.heidisql.com/rss.php?c=1,7&p=400762022-12-05T19:33:13+01:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update plink binaries to latest v0.78. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1430">issue #1430</a></li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li>Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40026">https://www.heidisql.com/forum.php?t=40026</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1705">Issue #1705</a>: Add new network type "MySQL on RDS", to support its different query for killing a process. New icon provided by @Bens-ct.</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">Issue #1616</a>: force update check to overwrite old HeidiSQL_update.exe in temp directory, once through different file size, and by logic when old one is older than 30 days. Fixes still used old updater with bugs.</li>
<li>SQL export: Calculate a reasonable LIMIT clause when "Get full table status" session setting is disabled, causing AvgRowLen lower than 0. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40058">https://www.heidisql.com/forum.php?t=40058</a></li>
<li>Fix too narrow column widths restored with high DPI setting, due to Delphi's Round() function using the nearest <em>even</em> number. Use the better suited "kaufmännisch runden" approach.</li>
<li>Query helpers tree: sync logic behind "Insert at cursor" with what doubleclick does. Enables that menu item for table columns, keywords, functions and snippets. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40022">https://www.heidisql.com/forum.php?t=40022</a></li>
<li>Quote BIT values again, in EscapeString version with data type. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1709">issue #1709</a></li>
<li>Use rds_kill_query procedure on RDS to kill a running query. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1705">issue #1705</a></li>
<li>Revert background color of selected text in Material style to its original, again causing unreadable link text on dialogs described in <a href="https://github.com/HeidiSQL/HeidiSQL/issues/993">issue #993</a>. Readability of selected text seems more important to me. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=40003">https://www.heidisql.com/forum.php?t=40003</a></li>
<li>Include application version and path of selected session in the session manager's window caption</li>
</ul>ansgarHeidiSQL 12.2 with JSON and XML reformatters, and customizable highlightershttps://www.heidisql.com/rss.php?c=1,7&p=399622022-11-15T17:34:02+01:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update SQLite libraries to v3.39.4 from 2022-09-29</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1536">Issue #1536</a>: auto-resize height of data grid filter while user types text in it</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1691">Issue #1691</a>: make timer interval for auto completion proposal configurable, while keeping 500ms as a default value.</li>
<li>Allow integers and floats to be entered in hexadecimal format in grids. Basically means they're not wrapped in quotes now. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39864">https://www.heidisql.com/forum.php?t=39864</a></li>
<li>After restoring query tabs, warn user about tabs which were loading slow</li>
<li>Add preference option for adding timestamp to log messages. Helpful for debugging performance issues.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/136">Issue #136</a>: use VerySimpleXML v3-beta from <a rel="ugc"href="https://github.com/Dennis1000/verysimplexml">https://github.com/Dennis1000/verysimplexml</a> to reformat XML in grid cells. Also, auto-disable slow wordwrap in editor if text is > 1M large</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1659">Issue #1659</a>: create dialog for customizing highlighter colors and style, for use on grid text editor</li>
<li>Highlight occurrences of selected text in grid text editor, same as in query editor</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1669">Issue #1669</a>: turn customize-highlighter button into dropdown button with additional items "Format code once" and "Always format code". Usable for SQL, JSON and XML.</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li>CSV scanner: lowercase name of table and columns, and unify non-word characters to underscore</li>
<li>Fix crash when scanning CSV file with more values in data than in header line. Closes #1698</li>
<li>Fix trailing linebreak counted to last column name in first CSV line</li>
<li>Fix wrong finish message in log result, when doing something different than an export. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39913">https://www.heidisql.com/forum.php?t=39913</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1700">Issue #1700</a>: exactify positions of line breaks in auto-filter on data grid, to prevent sporadically too long lines</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">Issue #1616</a>; Fix broken updater code and binaries, by fixing wrong parameter definition of WindowProc and wrong type cast in a SendMessage() call</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">Issue #1616</a>: revert previous modifications on updater binaries, which now do nothing and don't trigger the WM_SHOWWINDOW message</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1695">Issue #1695</a>: attempt to fix a check for a named session before storing the currently used database name</li>
<li>Prefer CopyFile + DeleteFile over MoveFile, in a second place, where the old binary is backup'd. See <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">issue #1616</a></li>
<li>Add log message after finished export, to make it more noticeable the user has control again. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39913">https://www.heidisql.com/forum.php?t=39913</a></li>
<li>SSH tunnel: process error pipe contents only if std pipe is empty. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39851">https://www.heidisql.com/forum.php?t=39851</a></li>
<li>Allow hex values to have an odd number of digits. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39864">https://www.heidisql.com/forum.php?t=39864</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1673">Issue #1673</a>, #1351 and #1658: use a general approach in TDBQuery.HasFullData for all server types, where we again use Delphi's Length() against a number range of 128..256.</li>
<li>Fix text value in popup editor cut to 256 chars, for all modes other than MySQL. Closes #1673</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1652">Issue #1652</a>: don't add collation clause to a modified or new JSON column</li>
<li>Update readme file: add Interbase/Firebird, require Delphi 11.1, code formatting</li>
<li>Purge cached columns, indexes etc. and reinitialize table editor, when user presses refresh button. Closes #1628</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1669">Issue #1669</a>: turn off always-format setting by default</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1670">Issue #1670</a>: fix text field editing with more than 256 chars on MS SQL</li>
<li>Add missing ini entries for CURRENT_TIMESTAMP function. Closes #1666</li>
<li>Use empty default host/ip for new SQLite sessions, to avoid running into some out-of-memory issue. Closes #1602</li>
<li>Fix previous approach in TDBQuery.HasFullData and StrHasNumChars, which used CharNextW() and stopped at null bytes within binary strings. Again use Length() instead, but let it be longer than GRIDMAXDATA. Closes #1658</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1659">Issue #1659</a>: remove broken sample text box, activate translation on dialog</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1659">Issue #1659</a>: fix exception on closing customize dialog, use empty string when converting clNone to and from web color, instead of #ffffff</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1656">Issue #1656</a>: attempt to give Wine a hint for the right font size, when highlighting selection occurrences</li>
<li>Use NULL in new row for column with timestamp expression, to fix a following UPDATE query using an empty string in its WHERE clause. Closes #1645</li>
<li>Leave away NULL clause for new column which allows NULLs. Closes #1642</li>
</ul>
<p><img src="/uploads/paste/2-2022-11-15_17-33-16.png" alt="Description" /></p>
<p><img src="/uploads/paste/2-2022-11-15_17-33-30.png" alt="Description" /></p>ansgarHeidiSQL 12.1 with views in SQLitehttps://www.heidisql.com/rss.php?c=1,7&p=395812022-08-13T08:22:59+02:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update SQLite libraries to v3.39.0, released on 2022-06-25</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li>Create context menu item "Empty recent filters" on database and table filter above tree view. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39447">https://www.heidisql.com/forum.php?t=39447</a></li>
<li>Add support for MariaDB's new UUID column type. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1545">issue #1545</a></li>
<li>Add basic support for listing and showing views in SQLite mode. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1196">issue #1196</a></li>
<li>Support mouse wheel zoom in grid text editor</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/156">Issue #156</a>: menu item "follow foreign key" in data grid (@dungsaga)</li>
<li>Let user set line break style for saved query tab files. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/892">issue #892</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/892">Issue #892</a>: support custom line break style when saving log panel contents or CREATE code tabs to file, using the existing "LineBreakStyle" option introduced in 59159c7afd8ea875b604d639bded105984b5e2c8.</li>
<li>Support renaming columns in SQLite, and generate separate ALTER TABLE queries for each change. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1256">issue #1256</a></li>
<li>Support COLLATE clause in SQLite when creating tables</li>
<li>Upgrade used compiler to Delphi 11.1</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li>Enable 64 bit support for files > 4gb in zipped SQL export</li>
<li>Support comments on table indexes via table designer. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/128">issue #128</a></li>
<li>Don't add a "WHERE -- foo" when the filter contains comments only. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1537">issue #1537</a></li>
<li>Strip comments from procedure parameters before parsing. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1477">issue #1477</a></li>
<li>Restore maximized state of text editor in OnCreate, not OnShow. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39476">https://www.heidisql.com/forum.php?t=39476</a></li>
<li>Don't reset a main control's window procedure if there is no main control. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1349">issue #1349</a></li>
<li>SSH tunnel: use the shell executable filename in all dialog captions</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/287">Issue #287</a>: v5.1 servers report utf8mb4 from mysql_character_set_name, although it's latin1. Trust the returned charset only on v5.5+ servers, and reset it on older servers.</li>
<li>MoveFile() does not work when target directory is a symlink, so we prefer CopyFile + DeleteFile. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1616">issue #1616</a></li>
<li>Auto-fit result columns when compressing export file has finished. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1617">issue #1617</a></li>
<li>TSHFileOpStruct.pFrom needs a trailing nul char, see <a rel="ugc"href="https://stackoverflow.com/a/1594859/4110077">https://stackoverflow.com/a/1594859/4110077</a> and/or <a rel="ugc"href="https://docs.microsoft.com/de-de/windows/win32/api/shellapi/ns-shellapi-shfileopstructa?redirectedfrom=MSDN#members">https://docs.microsoft.com/de-de/windows/win32/api/shellapi/ns-shellapi-shfileopstructa?redirectedfrom=MSDN#members</a></li>
<li>When deleting tab backup file, delete it to recycle bin, for cases where the user did that by accident. Same for snippet file and overwritten export/zip file. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39355">https://www.heidisql.com/forum.php?t=39355</a></li>
<li>Set title on completion proposal form, to keep the form resizable with only 1 NbLinesInWindow. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39366">https://www.heidisql.com/forum.php?t=39366</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1613">Issue #1613</a>: fix missing detection of spatial keys</li>
<li>mysql_character_set_name() from libmysql.dll reports utf8<em> if in fact it's a latin</em> charset. Force utf8* charset in that case. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39278">https://www.heidisql.com/forum.php?t=39278</a></li>
<li>Don't reapply shortcuts to base editor, but to all others. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1600">issue #1600</a></li>
<li>Fix crash after copying table to other database, when target database is expanded in DBtree and current session has a background color. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1597">issue #1597</a></li>
<li>Optimization: set up a single TSynMemo instance instead of all, e.g. when creating a new query tab</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1351">Issue #1351</a>: optimize StrHasNumChars</li>
<li>Make counting characters in TDBQuery.HasFullData more precise for diacritical characters. Fixes EnsureFullRow not doing its work when a cell contains some emoji. Reported in the forum: <a rel="ugc"href="https://www.heidisql.com/forum.php?t=39239">https://www.heidisql.com/forum.php?t=39239</a></li>
<li>Leave away delimiter at the end of a query batch, in one-go mode. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1583">issue #1583</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1577">Issue #1577</a>: make apphelpers.SelectNode more intelligent, returning true/false to indicate whether it successful went through OnFocusChanging event</li>
<li>Do not auto-close search/replace dialog if no occurrences were found. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/896">issue #896</a></li>
<li>Enable cancel edit button after search/replace. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1579">issue #1579</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1577">Issue #1577</a>: break loop in search/replace on grid if advancing focus on next node is not allowed through OnFocusChanging event</li>
<li>Convert hardcoded MySQL error codes to named constants, taken from include/mysql/server/mysqld_error.h</li>
<li>Refactor: move structures for specific network types out of dbstructures, into their own dbstructures.xxx.pas, and include const.inc in project sources</li>
<li>Set character set and collation of MySQL/MariaDB connections only if current one is not UTF8/16/32. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/287">issue #287</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1256">Issue #1256</a>: restrict altering existing SQLite tables, apart from a few things</li>
<li>Refactor: create and use self explanatory TDBObjectEditor.ObjectExists method</li>
<li>Table editor: force repaint of column list after click on "delete column", which otherwise still displays the deleted columns until the user hovers over it</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/945">Issue #945</a>: give id column in table editor slightly more width to let the text fit in</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1256">Issue #1256</a>: create spRenameColumn template and prefer that in SQLite and Postgres</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1521">Issue #1521</a>: get back partition clause into table editor by fixing the detection for CREATE code without a closing comment at the end</li>
<li>Prevent the last column from being dragged out of any VirtualTree header. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1021">issue #1021</a></li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/993">Issue #993</a>: white is now used as background for selected text, which is light blue and unreadable. Set Material/clHighlight to hex bebebe instead.</li>
<li>Set system color clHighlight in Material theme to bright white (was rgb 32464a), to enhance readability of link colors in dialog footers. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/993">issue #993</a>.</li>
<li>Limit icons on column in table editor to show only one per key type. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/945">issue #945</a></li>
<li>Support custom line breaks in ConfirmTabClear</li>
<li>Set hint on data grid top label, staying readable when screen width is too small to show the label. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/836">issue #836</a></li>
<li>Ask user whether modified text shall be stored when pressing cancel button. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/817">issue #817</a></li>
<li>Set focus on editor when creating new query tab, closing a previously grid editor. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/725">issue #725</a></li>
<li>Auto-refreshing grid or list only if main form is active. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/669">issue #669</a></li>
<li>Update cached object reference with new row count after inserting row, which may enable "Data" option in table copy dialog. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/666">issue #666</a></li>
<li>Disable save and discard buttons of routine editor temporarily while saving changes. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/616">issue #616</a></li>
<li>Display multi-line column headers in query result grid. Closes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/1566">issue #1566</a></li>
<li>Replace redundant ExtractBaseFileName() with TPath.GetFileNameWithoutExtension()</li>
</ul>ansgarHeidiSQL 12.0 with experimental support for high DPI and Interbase/Firebird connectionshttps://www.heidisql.com/rss.php?c=1,7&p=391252022-04-12T20:11:12+02:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update SQLite libraries to v3.38.0</li>
<li>Update VirtualTrees component source to v7.6.1</li>
<li>Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode)</li>
<li>Update libmariadb.dll and plugins to current stable versions</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li>Experimental support for high DPI in default Windows theme/style</li>
<li>Experimental support for Interbase and Firebird connections (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1169">issue #1169</a>)</li>
<li>Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/362">issue #362</a>)</li>
<li>SQL export: add new menu item "Copy mysqldump command line" in "Options"</li>
<li>Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini</li>
<li>Create editor commands for moving line up/down (Alt+Up, Alt+Down, "Edit" menu)</li>
<li>Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285)</li>
<li>New context menu items "Close query tabs to the right", and "Close all query tabs" (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/710">issue #710</a>)</li>
<li>New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360)</li>
<li>New grid export format: SQL UPDATEs (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/125">issue #125</a>)</li>
<li>New grid export format: Jira Textile (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1013">issue #1013</a>)</li>
<li>Empty-tables-confirmation supports disabling foreign key checks (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1491">issue #1491</a>)</li>
<li>Support renaming SQLite tables in database tab (#1427)</li>
<li>Editor highlights all occurrences of selected word, similar to Notepad++ (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/670">issue #670</a>)</li>
</ul>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li>Loading an sql file does not activate its tab, e.g. when loading multiple files. Fix crash happening when active tab is not a query tab in such cases.</li>
<li>Remove closing PHP tag from export as PHP array</li>
<li>Performance enhancement with many opened query tabs</li>
<li>Fix some potential file related exceptions in text file import</li>
<li>Support filenames with accented chars in text file import dialog (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1387">issue #1387</a>)</li>
<li>New query tab uses the same memo height as the current tab</li>
<li>Session background color now used on query result tabs, and in query gutter (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/932">issue #932</a>)</li>
<li>Fix various style/theme related crashes, for instance when closing the grid export dialog</li>
<li>Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns</li>
<li>Fix missing SET TIME_ZONE.. on export target server (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1457">issue #1457</a>)</li>
<li>Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1417">issue #1417</a>)</li>
<li>Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1259">issue #1259</a>)</li>
<li>Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=38150">https://www.heidisql.com/forum.php?t=38150</a></li>
<li>Support UINT columns in SQLite mode (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1453">issue #1453</a>)</li>
<li>Update SynEdit's list with known MySQL keywords, taken from <a rel="ugc"href="https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series">https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series</a> (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1437">issue #1437</a>)</li>
<li>Run current query: Prefer query left to the current one, if current one contains no text (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/603">issue #603</a>)</li>
<li>SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables</li>
<li>Activate auto-suggest option "Find matches in middle of entered text" by default.</li>
<li>Don't clear variable from --description cli parameter. (#1295)</li>
<li>Quote column names for quick filter, when column name matches an SQL function (#1398)</li>
<li>Session manager: Auto-expand session folder when user filter matches a child session</li>
<li>Fixes for handling virtual columns (#1210)</li>
<li>Add option to turn off tab close by doubleclick/middleclick (#1151)</li>
<li>Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1539">issue #1539</a>)</li>
<li>NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/202">issue #202</a>)</li>
<li>Binary values in foreign key pulldown now works with hex code, instead of binary garbage (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1540">issue #1540</a>)</li>
<li>Enhanced foreground/background colors for matching brace in dark themes. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/887">issue #887</a>)</li>
<li>Fix EAbort error when copying text from SynMemo without highlighter</li>
</ul>ansgarHeidiSQL 11.3 with syntax highlighting in grid text editorhttps://www.heidisql.com/rss.php?c=1,7&p=379452021-05-30T07:49:04+02:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p><strong>Still need 32bit support?</strong></p>
<ul>
<li>I am planning to drop the 32bit releases in a future release, for keeping the installer package small, and to decrease deployment efforts. Tell me what you think about it.</li>
</ul>
<p><strong>3rd party updates:</strong></p>
<ul>
<li>Update <a rel="ugc"href="https://github.com/SynEdit/SynEdit">SynEdit component code</a></li>
<li>Update <a rel="ugc"href="https://github.com/JAM-Software/Virtual-TreeView">VirtualTrees component code</a></li>
<li>Include Microsoft Visual C++ 2015-2019 Redistributable in installer, required for some 3rd party libraries (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1296">issue #1296</a>)</li>
<li>Update plink.exe to v0.75</li>
</ul>
<p><strong>New stuff:</strong></p>
<ul>
<li>Log DDL and/or DML queries per session to custom file path (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/397">issue #397</a>)</li>
<li>Grid text editor:<ul>
<li>syntax highlighting for 64 code languages, including JSON and XML (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/136">issue #136</a>)</li>
<li>gutter with line numbers and marks for edited lines</li>
<li>now using search/replace dialog with regular expression support</li>
</ul>
</li>
<li>Enable query timeout setting for MySQL and MariaDB (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1306">issue #1306</a>)</li>
<li>Show check constraints on MySQL, MSSQL and PostgreSQL (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1298">issue #1298</a>)</li>
<li>New menu Query > "Editor commands", revealing available quick actions for SQL editors</li>
<li>Create "Editor commands" menu in "Query" main menu, and populate it with all available editor commands</li>
<li>Add new preference option for displaying hexadecimal content in lowercase</li>
</ul>
<p><img src="https://user-images.githubusercontent.com/7986591/111082222-70488c00-8507-11eb-8812-668a7ea30f33.png" alt="" /></p>
<p><strong>Bugfixes and enhancements:</strong></p>
<ul>
<li>Query tab resizes after minimize (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1113">issue #1113</a>)</li>
<li>Foreign key add issue (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1320">issue #1320</a>)</li>
<li>Cannot update/insert postgres jsonb column from data editor (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1321">issue #1321</a>)</li>
<li>MariaDB 10.5: REPLICATION CLIENT privilege was renamed to BINLOG MONITOR (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1302">issue #1302</a>)</li>
<li>Quoted column default value expression on Percona (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1282">issue #1282</a>)</li>
<li>Cannot delete row in MSSQL (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1294">issue #1294</a>)</li>
<li>Always read portable settings file and imported settings file in UTF8 mode, instead of auto-detecting a potentially wrong encoding. Fixes broken characters loaded from a portable file larger than the examined 16 (?) KB</li>
<li>Database search feature: prefer a normal log line for tables with no matching data type, so the "Found rows" column has a number, to fix wrong sorting</li>
<li>function COALESCE is identified as plain text, not function (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1342">issue #1342</a>)</li>
<li>Non-synchronized checkbox state on privileges in user manager tree (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1352">issue #1352</a>)</li>
<li>Auto-scroll grid when tabbing through cells</li>
<li>Run SQL button disabled after reconnect (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1319">issue #1319</a>)</li>
<li>Don't repeat running prompt to reload a file after multiple external changes (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/821">issue #821</a>)</li>
<li>Fix identifier quoting when creating a foreign key in a database with dots in its name (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1364">issue #1364</a>)</li>
<li>Increase maximum pixel width of status bar panels slightly, so these better fit with a larger font size. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1356">issue #1356</a>)</li>
<li>Get rid of quotes around hex values and integers in quick filters</li>
<li>Fix crash happening when using un/comment action. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1359">issue #1359</a>)</li>
<li>include column names in "copy as" submenu export actions by default (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/1357">issue #1357</a>)</li>
<li>Restore/keep cursor position in filter editor after refresh</li>
<li>Detect pressed shift key before prompting for filter value. (<a href="https://github.com/HeidiSQL/HeidiSQL/issues/588">issue #588</a>)</li>
<li>Fix wrong query duration in log panel after multiple queries in "one-go" mode</li>
<li>Unhide public schema on Redshift</li>
<li>Table tools: auto-fit column widths with each result grid update, and show execution time in main status bar</li>
<li>Enable menu items for <code>EXPLAIN <query></code> on PostgreSQL and SQLite</li>
</ul>ansgarComparison of PostgreSQL GUIshttps://www.heidisql.com/rss.php?c=1,7&p=377662021-03-27T13:56:50+01:00<p>Thanks to Kristi Anderson and Madan Kumar from scalegrid.io for publishing a <a rel="ugc"href="https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2019-comparison/">feature overview of some of the available PostgreSQL clients</a>. The article is from 2019, but HeidiSQL is new in this comparison. As a lightweight tool it compares quite good with the commercial ones.</p>
<p><a rel="ugc"href="https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2019-comparison/"><img src="/images/screenshots/database.png" alt="image description" /></a></p>ansgarHeidiSQL 11.2 with support for check constraints and CSV layout detectionhttps://www.heidisql.com/rss.php?c=1,7&p=375292021-01-24T12:23:44+01:00<p>Get it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>3rd party updates:</p>
<ul>
<li>update <a rel="ugc"href="https://github.com/RRUZ/vcl-styles-utils">VCL Styles Utils</a> code</li>
<li>get latest bugfixes for <a rel="ugc"href="https://github.com/JAM-Software/Virtual-TreeView">VirtualTrees component</a></li>
<li>upgrade installer compilation to <a rel="ugc"href="https://jrsoftware.org/isinfo.php">InnoSetup v6.1.2</a></li>
<li>plink.exe update to v0.74</li>
<li>update sqlite3 libraries from v3.30.1 to v3.34.0</li>
</ul>
<p>New features and enhancements in this version:</p>
<ul>
<li>New CSV layout detection for "Import text file" dialog (select <code><New table></code>)</li>
<li>Support for table level check constraints on MariaDB</li>
<li>New "Rename tab" context menu for query tabs</li>
<li>New "CREATE code" tab in view editor</li>
<li>Tab restore feature:<ul>
<li>Gracefully re-create folder if query tab file and its folder was deleted from outside</li>
<li>restore scroll position</li>
<li>restore active query tab</li>
</ul>
</li>
<li>Grid export:<ul>
<li>Convert "Copy rows" context menu item to a submenu, and provide all export formats, with icons</li>
<li>Support custom hotkeys for each of these grid export actions</li>
</ul>
</li>
<li>SQL export:<ul>
<li>Prevent "Variable 'sql_notes' can't be set to the value of 'NULL'", via <code><span class="sqlfunc">IFNULL</span>()</code> wrap</li>
<li>Speed up data exports of large MS SQL tables, by introducing <code><span class="sqlkeyword">ORDER</span> <span class="sqlkeyword">BY</span> .. OFFSET .. FETCH</code> clauses in SELECT's</li>
<li>Limit rows per exported <code><span class="sqlkeyword">INSERT</span></code> to 1000 for MSSQL.</li>
<li>Auto-create directory path of output file</li>
</ul>
</li>
<li>Support shortcut Ctrl+F for focus on filter edit on session manager</li>
<li>Data grid: Prefer <code><span class="sqlfunc">SUBSTR</span>()</code> over <code><span class="sqlfunc">LEFT</span>()</code> function, unsupported in old PostgreSQL versions</li>
<li>Support regproc and jsonb column types on PostgreSQL</li>
<li>Support binary values in "More values" quick filter menu</li>
<li>Restore minimized main window when user attempts to start a second HeidiSQL process in single-instance mode</li>
<li>Apply data type colors to column names in completion proposal</li>
<li>Widen status bar panels for big screens</li>
<li>Shortcut settings: Prompt user for overwriting an existing shortcut</li>
</ul>
<p>Bugfixes</p>
<ul>
<li>Fix various crash reports uploaded by users via exception dialog</li>
<li>Accept any whitespace after double-minus comment in MySQL/MariaDB mode</li>
<li>Add UTF-8 BOM in Excel output only in file-mode, not in copy-mode.</li>
<li>Fix grid search/replace with scope=selection</li>
<li>Enable MYSQL_OPT_LOCAL_INFILE, seems still required on some systems for importing local CSV files</li>
<li>Fix invalid enabled state of "Explain current query" action</li>
<li>Re-add <code>CURRENT_TIMESTAMP</code> function, removed accidentally in last update</li>
<li>Fix cleared highlighter's TableNames list in irrelevant events</li>
<li>Fix empty library drop-down after changing network type for the first selected session.</li>
<li>Fix wrongly parsed <code><span class="sqlkeyword">ON</span> <span class="sqlkeyword">UPDATE</span></code> clause of columns when information_schema is hidden by session setting</li>
<li>Enable cancel button after setting grid cell to <code>NULL</code></li>
</ul>
<p>Complete change list: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/6?closed=1">https://github.com/HeidiSQL/HeidiSQL/milestone/6?closed=1</a></p>ansgarHeidiSQL 11.1 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=371532020-11-02T18:43:38+01:00<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>3rd party updates:</p>
<ul>
<li>move to new Delphi v10.4 Sydney compiler</li>
<li>ship plink.exe v0.73 by installing HeidiSQL, so users don't have to download it</li>
<li>use smaller libmariadb.dll v10.4.12 without debug symbols</li>
<li>update VCL Styles Utils code</li>
<li>Get latest bugfixes for VirtualTrees component</li>
<li>Sync latest modifications from official SynEdit component sources</li>
</ul>
<p>New features and enhancements in this version:</p>
<ul>
<li>code folding! (using <code>#region</code> and <code>#endregion</code>)</li>
<li>introduce basic support for connecting to ProxySQL Admin servers, via new network type</li>
<li>session paths and names in menus sorted alphabetically</li>
<li>Add new "Query" main menu, and put most of the SQL relevant actions there, including a submenu with some new code folding actions. Closes #1132</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/807">Issue #807</a>: add SQL editor in "Find on server" dialog, to support complex comparisons e.g. on binary values without quotes "=0xaa00"</li>
<li>Set "0" as default port for new MSSQL TCP/IP connections, enabling auto-detection</li>
<li>Set SQL_NOTES to 0 in SQL export, to silence warnings due to unsupported "ALTER TABLE .. DISABLE/ENABLE KEYS" on InnoDB tables. Closes #756</li>
<li>Sort collations alphabetically, in drop-down of column editor in table designer. Closes #828</li>
<li>Allow free typing in collation drop-down for collations in a column. Set to empty string if user typed a non existent item. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=37117">https://www.heidisql.com/forum.php?t=37117</a></li>
<li>Grid export: escape special characters in LaTeX output</li>
<li>Wrap numeric values in LaTeX export with $. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=36530">https://www.heidisql.com/forum.php?t=36530</a></li>
<li>Extract MySQL/MariaDB functions hints out of MariaDB 10.5 help tables</li>
<li>Grid export: No longer force ANSI encoding for Excel output, but silently insert a BOM</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/629">Issue #629</a>: do not limit the second column in the query helpers box to a width of 100 pixels</li>
<li>Provide UTC versions of most date/time menu items, in "Insert value" grid context menu. Closes #936</li>
<li>Provide columns of selected table in completion proposal of query editors, but only if left side strings don't dictate a different table. Closes #9.</li>
<li>use TComboboxEx for network types, with icons and ProxySQL sorted after the regular MySQL types</li>
<li>Activate hoAutoResizeInclCaption option on all VirtualTree headers, so auto-resizing per double click takes the column captions into account. Closes #906</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/957">Issue #957</a>: give labels on preferences dialog more horizontal space, for longer translations, synchronize space over all tabs, and fix some tab orders</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/957">Issue #957</a>: give labels on session manager more horizontal space, for longer translations</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/618">Issue #618</a>: implement an owner-draw approach for column headers in data grid, and paint sort icons as text, including a superscript number of its index</li>
<li>Convert TSynHotKey's to standard VCL THotKey's. And finally remove code extension in SynEditMiscClasses which I accidentally overwrote on updates several times.</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/120">Issue #120</a>: Allow unsupported ADODB providers per registry hack</li>
<li>Play "Error" sound when executed file(s) had errors. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=12800">https://www.heidisql.com/forum.php?t=12800</a> . Also, cancel execution of further files when user presses the cancel button</li>
<li>Add informative message in log panel after running SQL files, and play a short "OK" sound. This should probably be an "Error" sound when the file(s) had errors. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=12800">https://www.heidisql.com/forum.php?t=12800</a></li>
<li>Show tree lines in database tree, which may be helpful for a better overview</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/293">Issue #293</a>: make warning threshold for number of grid rows customizable, in preferences dialog, on grid formatting tab</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/293">Issue #293</a>: prevent long sort operation on header click in large query results</li>
<li>Remove nearly unused style packages, and keep the 9 used by more than 100 users last month. Reduces executable size by ~2.5M, and speeds up start up time significantly.</li>
<li>Optimize SQL query in TDBConnection.GetTableForeignKeys. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=36212">https://www.heidisql.com/forum.php?t=36212</a></li>
<li>Extend exception message with useful folder variable, in TAppSettings.PrepareRegistry, which I saw several times now in user reports, last time here: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/issues/1028#issuecomment-628131074">https://github.com/HeidiSQL/HeidiSQL/issues/1028#issuecomment-628131074</a></li>
</ul>
<p>Bugfixes:</p>
<ul>
<li>MS SQL: Support UPDATEs and DELETEs with key column values containing international characters</li>
<li>SSH tunnel: support very slow connections</li>
<li>Prevent access violation in DBTree.GetImageIndex, with no connection on connection root node</li>
<li>Format decimal point with milliseconds in date/time values in locale format for Excel</li>
<li>fix endless recursion happening on some systems when starting HeidiSQL</li>
<li>Overwrite data filter with newly generated one, by click on "Apply filter". Closes #829</li>
<li>Limit number of rows per extended INSERT to 1000 in CSV import dialog. Closes #326</li>
<li>Rename "IS NULL" and "IS NOT NULL" quick filter actions, so they don't prompt the user for an unused value. Closes #1065</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1081">Issue #1081</a>: apply quirk for missing IDENTIFIED BY PASSWORD clause to MySQL 5.7.6+ only (MariaDB still includes it). Will still be an issue for newer MySQL versions.</li>
<li>Allow underscores in IP address wildcards of users, in conjunction with --skip-name-resolve on the server. Closes #1080</li>
<li>Prefer ILIKE over LIKE operator on PostgreSQL servers, for auto-generated queries, to overcome errors with double columns. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=36500">https://www.heidisql.com/forum.php?t=36500</a></li>
<li>Fix wrong row index used in TSQLiteQuery.Col and TSQLiteQuery.IsNull. Fixes loading more rows after first page on large SQLite tables. Closes #1053</li>
<li>Leave numeric precision and scale away from DOUBLE column detection if either of them is empty. Closes #953</li>
<li>Fix alias of PostgreSQL column type TIMESTAMPTZ with missing space. Closes #1071</li>
<li>Use different sets of characters not requiring quotes, per connection type. Use that to force quotes around columns with uppercase characters in PostgreSQL. Closes #1072.</li>
<li>Use ValidateNode to initialize all column nodes early, so they keep their FColumn data after click on Remove button. Closes #245</li>
<li>Set minimum window height of session manager. Closes #1074</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/444">Issue #444</a>: get quick filter items in "More values" working again without crash</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/338">Issue #338</a>: reuse progress animation dialog when running multiple SQL files, and fix several focus stealing issues</li>
<li>Fix non-ghosted icons in database tree, temporarily in VirtualTrees.Utils.pas. The right place for that fix would be in TVirtualImageList.DoDraw. Closes #1045</li>
<li>Safety assignment for connection otherwise created by command line. See <a rel="ugc"href="https://stackoverflow.com/questions/21168998/why-does-assigned-return-true-for-uninitialized-variables">https://stackoverflow.com/questions/21168998/why-does-assigned-return-true-for-uninitialized-variables</a></li>
<li>Try to disable styles for madExcept window. Related to #887</li>
<li>Auto-reset style to default if selected one does not exist</li>
<li>Cast relpages to bigint, preventing out-of-range SQL error in PostgreSQL. Closes #1038</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1028">Issue #1028</a>: Optimize unused code in TDBConnection.GetDbObjects away, which looked for cached object lists which specific OnlyNodeType property, which we don't cache anyway</li>
<li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1028">Issue #1028</a>: Fix one-time recursion in TMySQLConnection.FetchDbObjects, caused by accessing InformationSchemaObjects, which in turn calls GetDBObjects and then again FetchDbObjects. More dramatically, this caused GetTableColumns to do an endless loop with two cache entries for "information_schema". This also fixes many of the v11.0 crashes in TAppSettings.PrepareRegistry, which were just a symptom of that endless loop. Thanks to als2020 on Github for pointing me in this direction.</li>
</ul>
<p>and many more: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/5?closed=1">https://github.com/HeidiSQL/HeidiSQL/milestone/5?closed=1</a></p>ansgar"HeidiSQL - Made with Delphi" webinar availablehttps://www.heidisql.com/rss.php?c=1,7&p=368902020-09-07T18:30:06+02:00<p>Letzten Mittwoch sprach ich mit Matthias Eissing von Embarcadero über Delphi und HeidiSQL.</p>
<p><img src="/uploads/paste/2-2020-09-07_18-27-30.png" alt="Description" /></p>
<p>Agenda:</p>
<ul>
<li>Woher kommt HeidiSQL?</li>
<li>Warum Delphi?</li>
<li>Features</li>
<li>Pläne für die Zukunft</li>
<li>"dies und das"</li>
</ul>
<p>Und hier die Aufnahme des Webinars:
<a rel="ugc"href="https://www.youtube.com/watch?v=SbB9yd1oM8o">https://www.youtube.com/watch?v=SbB9yd1oM8o</a></p>ansgarHeidiSQL 11.0 with SQLite supporthttps://www.heidisql.com/rss.php?c=1,7&p=358072020-03-17T19:23:36+01:00<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>New features and enhancements in this version:</p>
<ul>
<li>Support connecting to SQLite database files</li>
<li>drop schema support for PostgreSQL</li>
<li>support foreign keys in PostgreSQL</li>
<li>support foreign keys in MS SQL</li>
<li>read-only mode for grid cell editors, if underlying query or table does not allow updates</li>
<li>support scram-sha-256 authentication on PostgreSQL</li>
<li>enhanced readability of release notes</li>
<li>enhanced readability of help links with dark themes</li>
<li>support column comments of PostgreSQL</li>
<li>support disabling "Full table status" on PostgreSQL</li>
<li>new filter edit box on session manager, for filtering sessions using regular expressions</li>
<li>close query tabs via middle mouse click</li>
<li>trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting</li>
<li>sort collation drop down on "Bulk table editor" alphabetically</li>
<li>place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable</li>
<li>performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.</li>
<li>widen buttons on search/replace dialog by one quarter, so translations fit better on them</li>
<li>use default library of given network type in command line receiver</li>
<li>refreshed application icon</li>
</ul>
<p>Bugfixes:</p>
<ul>
<li>fix crashes when restoring tabs: expect no UTF-8 BOM</li>
<li>Procedure body changes invisible when parameter tab is active</li>
<li>last active session was no longer scrolled into view area of session manager</li>
<li>crash when mouse moves over data grid with broken connection</li>
<li>clicking too fast on session folder opens connection instead of collapse</li>
<li>passphrase input for SSH tunnel now masked</li>
<li>detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema</li>
<li>fix crash when accessing data from data tab on a disconnected session</li>
<li>fix crash when active main tab changes and data grid is disabled (due to disconnect)</li>
<li>make copy/cut safer against harmless crashes, and show occurring error messages in log panel</li>
<li>MSSQL: Remove surrounding parentheses from default value</li>
<li>fix state of checkboxes on the session manager's Advanced tab</li>
<li>fix crash by click on "Add column" in table editor, when columns list has a minimum height</li>
</ul>
<p>Third party libraries and components:</p>
<ul>
<li>update libmariadb.dll to v3.1.7</li>
<li>update libpq.dll to v10.0.11</li>
<li>introduce additional libpq.dll v12.0.1</li>
<li>update InnoSetup compiler to v6.0.3</li>
<li>update VirtualTree component to v7.3</li>
<li>introduce sqlite3.dll v3.30.1</li>
</ul>
<p>Complete change list: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1">https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1</a></p>ansgarHeidiSQL 10.3 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=350832019-12-11T12:35:02+01:00<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>New features and enhancements in this version:</p>
<ul>
<li>Theme preview in preferences dialog</li>
<li>"Library" dropdown in session manager, to enhance support for older and newer MySQL and MariaDB versions</li>
<li>Various new shortcuts in the "Go to" menu, e.g. for switching between result and query area</li>
<li>Support newer plink versions for SSH tunneled connections</li>
<li>Grid rightclick on cell: "Open in webbrowser" for fields containing a web url</li>
<li>Support for client_ed25519 MariaDB plugin</li>
<li>Support for SSH tunneled connections to PostgreSQL servers</li>
<li>Support for SSL on PostgreSQL servers</li>
<li>"Same text" background color in grid now applies to neigbour fields in selected row as well</li>
<li>Support for connections to Amazon Redshift (basically older PostgreSQL servers)</li>
<li>Restored query tabs also restore bind parameters</li>
<li>New option in grid export dialog: "Remove linebreaks from data"</li>
<li>New option to remove DEFINER clauses in SQL export option drop-down</li>
<li>Increase compatibility of table editor on PostgreSQL</li>
</ul>
<p>Bugfixes:</p>
<ul>
<li>Reverts earlier attempts for native high DPI support, so scaling is done by Windows again (blurry but less buggy)</li>
<li>Auto-detected Chinese localization fixed</li>
<li>Compatibility to MySQL 4 restored</li>
<li>Various fixes for SSL on MySQL and MariaDB</li>
<li>Fixed broken "undo" after auto-uppercased SQL keyword</li>
<li>Fixed crash when switching to table/database with same name on different server</li>
<li>Fixed invisible column comments on PostgreSQL</li>
<li>Fixed unsupported def.adsrc on PostgreSQL 12</li>
<li>Ctrl+Backspace in text boxes deletes left word, instead of writing cryptic character</li>
<li>Fixed update SQL for JSON columns in PostgreSQL</li>
<li>Fixed disappearing table comments after saving</li>
<li>Fixed warning about unsafe query when fooled with a commented WHERE clause</li>
</ul>
<p>Complete change list: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/3?closed=1">https://github.com/HeidiSQL/HeidiSQL/milestone/3?closed=1</a></p>ansgarHeidiSQL 10.2 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=272912019-06-15T08:36:36+02:00<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>New features and enhancements in this version:</p>
<ul>
<li>High resolution icons from Icons8</li>
<li>Save and restore query tabs automatically</li>
<li>PostgreSQL connection over SSH tunnel</li>
<li>Configurable web search engine for help links in footer of message dialogs</li>
<li>Support for DATETIMEOFFSET data types on MSSQL</li>
<li>Table designer: Support for custom expressions in column default values</li>
<li>Caching of "SELECT 1234::regclass" queries on PostgreSQL connections</li>
<li>New data grid menu item "Duplicate row with keys" (besides the old one "Duplicate row without keys)</li>
<li>Support for TLS versions up to 1.3 in MySQL connections</li>
</ul>
<p>Bugfixes:</p>
<ul>
<li>Text search on PostgreSQL works properly now</li>
<li>Auto-uppercase feature does not touch column names on table aliases</li>
<li>Enhanced Material theme colors</li>
<li>Artefacts in query editor when using non-default theme</li>
</ul>
<p>Complete change list: <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/2?closed=1">https://github.com/HeidiSQL/HeidiSQL/milestone/2?closed=1</a></p>
<p>If you liked the old Silk icons more: they are still there. You can switch back in Tools > Preferences > General > Icon Pack.</p>
<p>Wine users: You will probably need a newer Wine version, as recent ones did not work with HeidiSQL. Wine 4.10 runs fine according to some user feedback.</p>ansgarRestore your query tabs automaticallyhttps://www.heidisql.com/rss.php?c=1,7&p=269992019-04-29T14:58:34+02:00<p>Since a few nightly builds, your query tabs are now stored automatically. This means the code in them is back again when you restart HeidiSQL, without the need to select one or more files for each tab.</p>
<p>This was one of the most wanted features from many users, and now I heard you - finally :) Read about the progress of this conveniance feature on <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/issues/140">GitHub</a>.</p>
<p>By default, the old „ask to save contents“ dialog is still activated, but now tells you about the uselessness of it, when you exit HeidiSQL:</p>
<p><img src="/files/tab-restore-ask-save.png" alt="HeidiSQL asks to save your unsaved code" /></p>
<p>You can disable or enable these settings in the new „Files“ tab on the Preferences dialog:</p>
<p><img src="/files/tab-restore-preferences.png" alt="How to enable or disable this feature" /></p>ansgarFilter box for snippets, functions etc.https://www.heidisql.com/rss.php?c=1,7&p=269232019-04-07T11:56:53+02:00<p>I often found myself searching in the many snippets I stored over the years. To make it quick and easy to find anything in the query helpers box, I just added a filter box on top of it. The tree will filter items as you type, and it keeps the collapsed and expanded nodes, so you only see what you want.</p>ansgarHeidiSQL 10.1 bugfix releasehttps://www.heidisql.com/rss.php?c=1,7&p=264292019-01-26T07:31:32+01:00<p>This is a new release which mainly fixes the installer, which named the executable in your program files folder "heidisql32.exe", not "heidisql.exe". Sounds minor, but I suppose there are quite a few links out there still pointing to heidisql.exe. The 10.1 installer now deletes that heidisql32.exe and installs the fresh heidisql.exe.</p>
<p>Thanks to forum user fyrye for <a href="/forum.php?t=26412">reporting that issue</a>.</p>
<p>Grab it from the <a href="/download.php?download=installer">download page</a>. And don't forget to disable your adblocker :)</p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>ansgarHeidiSQL 10.0 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=263922019-01-23T19:26:17+01:00<p>This is a new release with quite a few new features, some enhancements and many bugfixes.</p>
<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<p>Most noticable new features and enhancements:</p>
<ul>
<li>Basic support for high DPI scaling on modern screens with 4K resolutions (work in progress)</li>
<li>Theme support: many stylish themes selectable, dark and light ones, and even one user contributed dark Material theme</li>
<li>Predefined color presets for data types and SQL code in preferences dialog</li>
<li>Support for connecting to MySQL 8 servers, with the help of caching_sha2_password plugin from MariaDB</li>
<li>Portable version downloads now have a <code>portable.lock</code> file, and do no longer overwrite your <code>portable_settings.txt</code></li>
<li>Auto uppercase writing of SQL keywords in editors</li>
<li>Switch to Microsoft OLE DB driver for SQL Server connections, to support TLS 1.2 secured connections</li>
<li>Data grids with highlighted cells in view port having the same content as the focused one</li>
<li>No Direct2D overriding required anymore when running on Wine</li>
<li><a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/milestone/1?closed=1">more solved issues</a></li>
</ul>ansgarTheme supporthttps://www.heidisql.com/rss.php?c=1,7&p=259522018-11-07T21:18:49+01:00<p>The latest nightly builds of HeidiSQL have support for themes, and some quite nice themes included.</p>
<p><img src="/images/screenshots/themes.png" alt="image description" /></p>
<p>If you'd like to have a dark theme for example, feel free to update to the latest build. After starting HeidiSQL, you can select a theme under Tools > Preferences > General. For fitting colors in the SQL editors, there are two new color presets - one for dark themes, and the old default preset for light themes.</p>
<p>Enjoy!</p>ansgarheidisql.com on IPv6https://www.heidisql.com/rss.php?c=1,7&p=257052018-09-15T08:39:52+02:00<p>Better late than never: Yesterday I configured heidisql.com for the IPv6 address <code>2a01:488:66:1000:53a9:8f8:0:1</code>, additionally to the existing IPv4 address <code>83.169.8.248</code>.</p>
<p>My Firefox and Edge on Windows 10 have zero problems with that. However, if you encounter any problems, especially while checking for HeidiSQL updates, please report that to <a rel="ugc"href="https://github.com/HeidiSQL/HeidiSQL/issues">HeidiSQL's bug tracker</a>.</p>ansgarHeidiSQL available through Microsoft Storehttps://www.heidisql.com/rss.php?c=1,7&p=249762018-02-21T12:58:03+01:00<p>HeidiSQL is now available in Microsoft's App Store:
<a rel="ugc"href="https://www.microsoft.com/store/apps/9NXPRT2T0ZJF">https://www.microsoft.com/store/apps/9NXPRT2T0ZJF</a></p>
<p>This is basically the current v9.5 release, with some functionality enhancements for running on the Universal Windows Platform (UWP).</p>
<p>This is for all Windows 10 users, and probably a good replacement for the outdated package on Chocolatey: <a rel="ugc"href="https://chocolatey.org/packages/HeidiSQL">https://chocolatey.org/packages/HeidiSQL</a></p>
<p>Thanks a lot to Marc from Microsoft for helping me get through the process, and for his patience!</p>ansgarHeidiSQL 9.5 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=245542017-12-19T17:19:09+01:00<p>This is a bugfix release with a few new features and enhancements.</p>
<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<ul>
<li>
<p>New features:</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>Add custom setting for number of days to keep queries in the query history. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23530">https://www.heidisql.com/forum.php?t=23530</a></p>
</li>
<li>
<p>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 <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23190">https://www.heidisql.com/forum.php?t=23190</a></p>
</li>
<li>
<p>Support grouping by tree node type in "check xyz" menu items on table tools dialog. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23351">https://www.heidisql.com/forum.php?t=23351</a></p>
</li>
<li>
<p>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 <a rel="ugc"href="http://www.heidisql.com/forum.php?t=23049">http://www.heidisql.com/forum.php?t=23049</a></p>
</li>
<li>
<p>Support SQL security setting in view editor via drop down menu. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=21740">http://www.heidisql.com/forum.php?t=21740</a></p>
</li>
<li>
<p>Use the right SQL commands for killing a process on PostgreSQL. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=21760">http://www.heidisql.com/forum.php?t=21760</a></p>
</li>
<li>
<p>Bugfixes:</p>
</li>
<li>
<p>Prevent accessing non existing string list item in TMainForm.ListDatabasesGetText, to fix a sporadic crash after dropping a database. Closes #33</p>
</li>
<li>
<p>Temporarily disable local number formatting in data grid while the search dialog is open. Closes #30.</p>
</li>
<li>
<p>Prevent TMainForm.DisplayRowCountStats from crashing due to no current table/view/...</p>
</li>
<li>
<p>Don't export data for virtual columns. Fixes #5.</p>
</li>
<li>
<p>Simplify regular expression for extracting column details in ParseTableStructure(), so it does not barf on huge length/set. Fixes <a href="https://github.com/HeidiSQL/HeidiSQL/issues/2">issue #2</a>.</p>
</li>
<li>
<p>New attempt to fix menu and buttons flicker on Win10, this time by with the help of Delphi Detours library. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=19141">https://www.heidisql.com/forum.php?t=19141</a></p>
</li>
<li>
<p>fix exception in early stage of table editor initialization</p>
</li>
<li>
<p>Fix detection of column types with DEFAULT CURRENT_TIMESTAMP(123). See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=17585">https://www.heidisql.com/forum.php?t=17585</a></p>
</li>
<li>
<p>Reduce flicker on Windows 10. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=19141">https://www.heidisql.com/forum.php?t=19141</a></p>
</li>
<li>
<p>Silence dumb exceptions from mysql_ping() call. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23483">https://www.heidisql.com/forum.php?t=23483</a></p>
</li>
<li>
<p>Fix typos in encoding of xml exports. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23421">https://www.heidisql.com/forum.php?t=23421</a></p>
</li>
<li>
<p>Prevent inserting cell text ellipsis in query tab. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23353">https://www.heidisql.com/forum.php?t=23353</a></p>
</li>
<li>
<p>Work around access violation in highlighter, which raises after a successful reconnect. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=23009">http://www.heidisql.com/forum.php?t=23009</a></p>
</li>
<li>
<p>Fix sloppy regular expression in TDBConnection.DetectUSEQuery which removes too much of trailing quotes in a database name. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22743">http://www.heidisql.com/forum.php?t=22743</a></p>
</li>
<li>
<p>Escape quotes and stuff in JSON keys and values. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22747">http://www.heidisql.com/forum.php?t=22747</a></p>
</li>
<li>
<p>PostgreSQL: query timeout is set in milliseconds, not seconds. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22645">http://www.heidisql.com/forum.php?t=22645</a></p>
</li>
<li>
<p>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. </p>
</li>
<li>
<p>Fix compiler warning</p>
</li>
<li>
<p>Fix crash when taskbar button interface is not available for some reason. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22451">http://www.heidisql.com/forum.php?t=22451</a></p>
</li>
<li>
<p>Enhancements:</p>
</li>
<li>
<p>Support quote chars other than the relevant one within identifiers. For example <code>"mycolumn"</code> or "<code>mycolumn</code>" ... or even worse: <code>"``mycolumn"</code>. Closes #44.</p>
</li>
<li>
<p>Send donators’ e-mail addresses encrypted</p>
</li>
<li>
<p>Update url to issue tracker and copyright year</p>
</li>
<li>
<p>SynEdit's SQL highlighter provides a sample source text. Display that text in the preferences editor panel for SQL colors.</p>
</li>
<li>
<p>Update gettext binaries, from <a rel="ugc"href="http://svn.code.sf.net/p/dxgettext/code/trunk/buildtools">http://svn.code.sf.net/p/dxgettext/code/trunk/buildtools</a> . The old msgfmt.exe creates endless processes on Win10, not so this one.</p>
</li>
<li>
<p>Remove debug code. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=24400">https://www.heidisql.com/forum.php?t=24400</a></p>
</li>
<li>
<p>Extend TMySQLOption enumeration with newer items</p>
</li>
<li>
<p>unify context menu of various sql editors, by supporting all contained editors instead of searching for one with the name "SynMemoBody"</p>
</li>
<li>
<p>Trigger OnChange event on TSynMemo after toggling comment, so a save button gets enabled. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23834">https://www.heidisql.com/forum.php?t=23834</a></p>
</li>
<li>
<p>Save session tree color when creating a copy of a session. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23796">https://www.heidisql.com/forum.php?t=23796</a></p>
</li>
<li>
<p>Use new copy-columns icon in main image list</p>
</li>
<li>
<p>Create a nicer icon for "Copy selected columns/rows"</p>
</li>
<li>
<p>Create a new menu item for copying rows to clipboard, and assign Ctr+Shift+C to it. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23190#p23490">https://www.heidisql.com/forum.php?t=23190#p23490</a></p>
</li>
<li>
<p>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 <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23383">https://www.heidisql.com/forum.php?t=23383</a></p>
</li>
<li>
<p>Add "&lt;server default&gt;" to the engine drop down on the table editor, and make that the new default, so we leave the ENGINE=.. clause away. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=23363">https://www.heidisql.com/forum.php?t=23363</a></p>
</li>
<li>
<p>Use HTTPS for all web requests on heidisql.com</p>
</li>
<li>
<p>Update SynEdit component code to v2.0.9 beta from <a rel="ugc"href="https://github.com/SynEdit/SynEdit/releases/tag/SynEdit-2.0.9-beta">https://github.com/SynEdit/SynEdit/releases/tag/SynEdit-2.0.9-beta</a> . Just a few additional highlighter keywords and one code change for background coloring included.</p>
</li>
<li>
<p>Attempt to add an error string which Windows provides after a failed call to LoadLibrary. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22514">http://www.heidisql.com/forum.php?t=22514</a></p>
</li>
<li>
<p>Make Markdown export code compatible to the parser on gitlab.com, by using 3 dashes instead of 1, below header columns. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22991">http://www.heidisql.com/forum.php?t=22991</a></p>
</li>
<li>
<p>Increase width of "name" field on view editor to the same value as it's on the procedure editor.</p>
</li>
<li>
<p>Reasonably increase and unify design time dimensions of object editors to 700x500 pixels</p>
</li>
<li>
<p>Remove per-row comment in PHP array grid export, which blows up the result. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22749#p22798">http://www.heidisql.com/forum.php?t=22749#p22798</a></p>
</li>
<li>
<p>Don't encode html entities but escape quotes in JSON grid export. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22747#p22783">http://www.heidisql.com/forum.php?t=22747#p22783</a></p>
</li>
<li>
<p>Use double quotes for PHP values when exporting a PHP array from a grid. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22749">http://www.heidisql.com/forum.php?t=22749</a></p>
</li>
<li>
<p>Try to load libpq.dll with explicit file path if the path-less did not succeed. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22514">http://www.heidisql.com/forum.php?t=22514</a></p>
</li>
<li>
<p>Cast unknown data type columns as text when generating a multi column filter from user input. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22562">http://www.heidisql.com/forum.php?t=22562</a></p>
</li>
<li>
<p>Remove quirky logic from TMySQLQuery.Execute when distinguishing between text and binary data types. See <a rel="ugc"href="http://www.heidisql.com/forum.php?t=22441">http://www.heidisql.com/forum.php?t=22441</a></p>
</li>
</ul>ansgarMoving to GitHubhttps://www.heidisql.com/rss.php?c=1,7&p=244382017-11-04T17:22:10+01:00<h2>Move to GitHub</h2>
<p>HeidiSQL sources have just moved from <a rel="ugc"href="https://sourceforge.net/projects/heidisql/">Sourceforge</a> to <a rel="ugc"href="https://github.com/HeidiSQL">GitHub</a>. Thanks to Per for creating the HeidiSQL project family / organization there.</p>
<p>Importing the repository from Sourceforge was done via <a rel="ugc"href="https://github.com/new/import">GitHub importer</a>. Unfortunately, the importer did not yet support issue importing from Sourceforge, so we start at zero here. Well, this is probably a chance to make a more clean start than it was when moving from GoogleCode to Sourceforge.</p>
<p>The last 3 nightly builds are already pulled from Github, so I think I got it working now.</p>
<h2>Code sign certificate expired</h2>
<p>You may have probably noticed that the latest builds no longer have an AuthentiCode certificate for code signing, which is why Windows 8 and 10 display a fat warning message after downloading a build via web browser. I have to renew the certificate each year, but this year the old provider wanted me to buy some expensive smartcard hardware additionally to the certificate.</p>
<p>A code sign certificate at ksoftware.net required me to be listed on dnb.com, which I am not. Letsencrypt.org does not yet suppoprt code signing certificates. So I'm currently without any alternative. Feel free to post alternatives here.</p>ansgarSSL all over the placehttps://www.heidisql.com/rss.php?c=1,7&p=233382017-02-20T09:32:17+01:00<p>For various security reasons, and due to the login page on heidisql.com I have just created and set up an SSL certificate here. Of course there is also Google who says that they downrank pages with an unsecured login-page. Well, they're right (in this particular point).</p>
<p>Thanks to the forum user Cyann for precise information.</p>ansgarHeidiSQL 9.4 releasedhttps://www.heidisql.com/rss.php?c=1,7&p=224202016-10-20T19:22:09+02:00<p>This is a maintenance release with quite some additional new features and enhancements.</p>
<p>Grab it from the <a href="/download.php?download=installer">download page</a></p>
<p><a href="/donatebutton.php?place=announcement"><img src="/images/donatebutton.png" alt="" /></a></p>
<ul>
<li>New features:</li>
<li>Introduce GUI font preferences setting, so the user can customize the font of all dialogs and forms</li>
<li>Add a "clear" button to the both db+table filter textboxes.</li>
<li>Make insertion of node text on double click customizable, per tree style options menu</li>
<li>Make brace matching color customizable, via Tools > Preferences > SQL.</li>
<li>Add menu item "Run SQL file", as a complement to "Load SQL files".</li>
<li>Set font size per Ctrl + mousewheel in any grid view.</li>
<li>Add new "Options" dropdown button on SQL export dialog, and two new true/false settings: "Add comments" and "Remove auto_increment clauses".</li>
<li>Support procedures and functions in "Find text on server" dialog.</li>
<li>Support inline valued functions on MSSQL.</li>
<li>Make keep-alive-interval customizable in "Advanced" tab on session manager.</li>
<li>Display UTC date/time in 5th status bar panel.</li>
<li>Add "SQL DELETEs/INSERTs" to grid export formats.</li>
<li>Display the version of libpq.dll in the status bar's balloon hint with server details, using PQlibVersion().</li>
<li>Support wildcard options in "Find text on server" dialog in a new drop down box, to provide a possibility to find exact matches.</li>
<li>MySQL/MariaDB: Implement support for expired passwords. Show a change-password dialog after the very first query of a connection when it returns "Error 1820: You must SET PASSWORD before executing this statement".</li>
<li>Support Windows authentication via command line parameter W or winauth.</li>
<li>Accept SSL session settings as command line parameters. See <a rel="ugc"href="http://www.heidisql.com/help.php#commandline">http://www.heidisql.com/help.php#commandline</a> for details.</li>
<li>Add some hotkeys for focusing table filter, database tree and main tabs. Also, add a new main menu with these actions, so the user can look up these hotkeys.</li>
<li>Enhancements:</li>
<li>Prefetch mass queries fired for each object in a database</li>
<li>Support MSSQL's XML data type, and do not cast it to VARCHAR in data grid</li>
<li>Increase size of analyzed text file chunk from 100K to 1M, in DetectEncoding(), so it fails less often to see encoding relevant characters</li>
<li>Add various missing translation strings</li>
<li>Detect table and its alias when using UPDATE/INSERT IGNORE</li>
<li>Display column comments on MSSQL</li>
<li>Add basic support for MySQL's new JSON data type.</li>
<li>Add new MySQL internally used date/time data types.</li>
<li>Internally handle MySQL's native column types in an enumeration, not as constants. See mysql.h.pp in the MySQL server code.</li>
<li>Add virtual column syntax for MySQL, which seems to differ slightly from the MariaDB implementation.</li>
<li>User manager: Allow double quotes in SHOW GRANTS output, to support ANSI mode.</li>
<li>Translate SynEdit shortcut captions.</li>
<li>Increase width of shortcut tree, so new translations have enough room.</li>
<li>Update SynEdit component</li>
<li>Remember size of completion proposal between sessions.</li>
<li>Rephrase confirmation message for running unsafe queries.</li>
<li>Do not quote column names when not required in SELECT query for data grid.</li>
<li>Add some new lines in SQL export, especially when "Add comments" is disabled</li>
<li>Try to show tooltip when columns in database tree are too narrow to show the full text.</li>
<li>Format byte numbers so that we never get a thousands separator in it.</li>
<li>Use a better fitting icon for the browse-file button in SQL export dialog.</li>
<li>Warn if export output filename contains illegal characters, which TFileStream.Create does not catch for some reason.</li>
<li>Do not check existence of IS.routines before querying it.</li>
<li>Remember selected encoding in several file-open-dialogs.</li>
<li>Use an exact comparison in multi-column filters for some PostgreSQL data types to overcome SQL errors, e.g. UUID, INT etc. Also, prevent other errors by matching the value against a certain regular expression. If it does not match, leave this column away.</li>
<li>Update all PostgreSQL libraries</li>
<li>Add splitter on procedure editor.</li>
<li>Set each procedure parameter on its own line, and remove some tabs.</li>
<li>Display number of sorted columns on "Sorting" button.</li>
<li>Display number of selected columns besides available columns on "Columns" button in "Data" tab.</li>
<li>Add new item "Logging preferences" to context menu in SQL log panel</li>
<li>Preferences: Add checkbox for "Horizontal scrollbar" in Logging tab.</li>
<li>Preferences: Give each tab an individual icon, and use flat button style for tabs.</li>
<li>Display network type in tooltip over server status panel.</li>
<li>Cosmetics in session manager: Rearrange and resize labels in statistics tab.</li>
<li>Cosmetics: Make status bar panel for server version a bit wider.</li>
<li>Update Transifex command line client to 0.12.1.</li>
<li>Add client plugin for MariaDB's GSSAPI authentication, basically Windows authentication.</li>
<li>Move some menu items for configuring data grids into a new submenu labelled "Grid view options"</li>
<li>Create a duplicated menu item there, for "View binary data as text" button from the main toolbar</li>
<li>Create a new menu item there, for jumping to the "Data" tab in the preferences window</li>
<li>Add related translation strings</li>
<li>Move plink.exe path to lpCommandLine parameter instead of passing it as lpApplicationName. This way, a folderless plink.exe call should use the first available one from the path environment.</li>
<li>Support multiple objects selected in user manager > add object.</li>
<li>Clear contents of filter boxes when pressing Esc key.</li>
<li>Support all integer and real data types for displaying as Unix timestamp.</li>
<li>Support session name in placeholders for filename.</li>
<li>Bugfixes:</li>
<li>Non functional bind parameter detection</li>
<li>Use db.func instead of schema.func when schema is empty, on retrieving MSSQL routine structure</li>
<li>MSSQL: Fix broken query for altering column comment via table editor</li>
<li>A yes/no message dialog may also return mrCancel, when the user clicks the X button to close it. Handle this case as if the user clicked "no", when HeidiSQL detects an unsafe query.</li>
<li>Fix endless loop in retrieval of column comments on MSSQL.</li>
<li>Fix order in table column parsing, so that collation is expected before a virtual expression</li>
<li>Fix non-working detection of indexes on PostgreSQL pre-9.0 servers</li>
<li>Postpone repaint of the data grid to later, after click on a header column with a bad WHERE filter. Fixes a crash in VirtualTree, when handling the click somewhere.</li>
<li>Fix position of horizontal splitter on second and successive query tabs.</li>
<li>MSSQL: Set textsize to a large value, so the view editor does not load partial code only.</li>
<li>Use a reasonable default height for the query editor, to prevent a splitter problem.</li>
<li>Prevent various problems with alignment of controls.</li>
<li>Fix duplication of query tab controls, when it comes to aligning the query helpers tree.</li>
<li>Fix crash when opening completion proposal with only views in a database.</li>
<li>Ignore surrounding parentheses when detecting table aliases for completion proposal.</li>
<li>Table designer: Do not allow an empty length/set for data types which require one.</li>
<li>Slightly increase auto-calculated width of size column in database tree, so it does not use ellipses on wider texts, e.g. "1.023 KiB"</li>
<li>In SQL dumps, make "SET NAMES utf8mb4" a version conditional statement for the minimum MySQL version supporting that charset.</li>
<li>Implement TPGQuery.TableName, so exporting grid rows get a table name when needed. E.g. for output format "SQL Inserts".</li>
<li>Allow tab after double dash comment in SQL highlighter.</li>
<li>Fix detection of virtual columns without "GENERATED ALWAYS" clause.</li>
<li>Fix unquoted and uncleaned numeric values in data grid updates and inserts.</li>
<li>Fix bug in TAdoDBQuery.TableName when multiple queries were executed.</li>
<li>Use an exact comparison for PostgreSQL's BOOLEAN datatype.</li>
<li>Fix multi column filter concatenated without OR after linebreak.</li>
<li>MSSQL: Work around multiple results from a single query, in case of a stored procedure for example.</li>
<li>Fill SSL command line parameters only if not empty in HeidiSQL session.</li>
<li>Overcome 4000 character limit in IS.VIEW_DEFINITION.</li>
<li>Use b'' format only for BIT columns in MySQL only.</li>
<li>Fix "Database(s)" string split by space characters. Allow semicolon only.</li>
<li>Fix wrong FLOAT data type mapping between DB.TFieldType and TDBDatatypeIndex, in TAdoDBQuery.Execute.</li>
<li>Do not complain about empty password when SHOW GRANTS output does not include the IDENTIFIED BY clause on MySQL 5.7.6+.</li>
<li>Rewind result set for column comments before iterating over it, as it's an inner loop.</li>
<li>Trim database names when passed as semicolon separated list.</li>
<li>Use exact text data types instead of their whole category for detecting special binary columns. Fixes unquoted JSON content in SQL exports.</li>
<li>Fix slow highlighter when TableNames contains several 1000's of strings. Removes limitation to 1000 table names for highlighting.</li>
<li>Fix crash when showing hint (animation) on grid cells with large text portions.</li>
<li>Catch exception when clicking "Cancel running operation" and the KILL command cannot be executed.</li>
</ul>ansgarHeidiSQL joins Chocolateyhttps://www.heidisql.com/rss.php?c=1,7&p=207322016-02-21T12:25:02+01:00<p><img src="https://chocolatey.org/Content/Images/nugetlogo.png" alt="" /></p>
<p>I just joined Chocolatey, which is sort of like yum or apt-get for Windows. HeidiSQL was already listed there but was outdated, so I created a package with the current 9.3 release.</p>
<p>See the package here: <a rel="ugc"href="https://chocolatey.org/packages/HeidiSQL">https://chocolatey.org/packages/HeidiSQL</a></p>ansgarSigned downloads and Markdown supporthttps://www.heidisql.com/rss.php?c=1,7&p=200142015-12-02T16:18:35+01:00<h2>Certificate for installers and nightly builds</h2>
<p>Finally I bought a certificate at <a rel="ugc"href="https://www.certum.eu/certum/cert,offer_en_open_source_cs.xml">certum.eu</a> to sign the HeidiSQL installers and nightly build files. The latest built installer and nightly builds now don't show a warning message in Windows 7, 8 and 10 any longer. Instead, Windows 7 displays the certificate owner in a dialog when executing:</p>
<p><img src="/uploads/20005-1-heidi-setup-signed.png" alt="" /></p>
<p>For all Open Source developers - <a rel="ugc"href="http://www.anse.de/programming/code-signing-for-open-source-executable">here's my tutorial for obtaining and managing a code signing certificate using signtool.exe</a>.</p>
<h2>Markdown syntax support in this forum</h2>
<p>After updating most webserver components on heidisql.com I thought I could add Markdown support to the forum. <a rel="ugc"href="http://daringfireball.net/projects/markdown/">Markdown</a> provides an easy-to-read, easy-to-write plain text format, which then converts to valid HTML for viewing forum threads on heidisql.com.</p>
<p>Learn the <a rel="ugc"href="https://help.github.com/articles/markdown-basics/">basics for Markdown on GitHub</a>.</p>
<p>This adds - amongst other features - support for pasting table results from HeidiSQL here. Here comes an example table, copied in <em>Markdown Here</em> format from HeidiSQL via <em>Export grid rows</em> dialog:</p>
<table>
<thead>
<tr>
<th style="text-align: right;">id</th>
<th style="text-align: right;">user</th>
<th>Text</th>
<th style="text-align: right;">Termin</th>
<th>ts</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: right;">6</td>
<td style="text-align: right;">1</td>
<td>Schick anziehen!!!</td>
<td style="text-align: right;">2</td>
<td>2002-04-28 20:16:25</td>
</tr>
<tr>
<td style="text-align: right;">11</td>
<td style="text-align: right;">3</td>
<td>nur mit einladung</td>
<td style="text-align: right;">2</td>
<td>2002-04-29 21:19:56</td>
</tr>
</tbody>
</table>ansgarFixed crash in recent nightly buildhttps://www.heidisql.com/rss.php?c=1,7&p=197492015-11-03T09:27:03+01:00If you're one of the users having updated HeidiSQL this morning to revision 5002, then you will surely see a crash when starting heidisql.exe . This is due to an accidental commit of a file with unfinished changes from me. Sorry for that. I have just reverted that in revision 5003.<br />
<br />
As the program crashes at the very start, you won't be able to update HeidiSQL automatically. As a solution, you can use the installer from that fixed build for updating:<br />
32/64bit: <a href="http://www.heidisql.com/installers/HeidiSQL_9.3.0.5003_Setup.exe">http://www.heidisql.com/installers/HeidiSQL_9.3.0.5003_Setup.exe</a><br />
32bit only: <a href="http://www.heidisql.com/installers/HeidiSQL_9.3.0.5003-32_Setup.exe">http://www.heidisql.com/installers/HeidiSQL_9.3.0.5003-32_Setup.exe</a><br />
<br />
See <a href="/forum.php?t=19743">this forum thread</a> for details.ansgar