v12.0 [Apr 13, 2022]
3rd party updates:
- Update SQLite libraries to v3.38.0.
- Update VirtualTrees component source to v7.6.1.
- Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode).
- Update libmariadb.dll and plugins to current stable versions.
New stuff:.
- Experimental support for high DPI in default Windows theme/style.
- Experimental support for Interbase and Firebird connections (issue #1169).
- Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (issue #362).
- SQL export: add new menu item "Copy mysqldump command line" in "Options".
- Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini.
- Create editor commands for moving line up/down (Alt Up, Alt Down, "Edit" menu).
- Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285).
- New context menu items "Close query tabs to the right", and "Close all query tabs" (issue #710).
- New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360).
- New grid export format: SQL UPDATEs (issue #125).
- New grid export format: Jira Textile (issue #1013).
- Empty-tables-confirmation supports disabling foreign key checks (issue #1491).
- Support renaming SQLite tables in database tab (#1427).
- Editor highlights all occurrences of selected word, similar to Notepad (issue #670).
Bugfixes and enhancements:.
- 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..
- Remove closing PHP tag from export as PHP array.
- Performance enhancement with many opened query tabs.
- Fix some potential file related exceptions in text file import.
- Support filenames with accented chars in text file import dialog (issue #1387).
- New query tab uses the same memo height as the current tab.
- Session background color now used on query result tabs, and in query gutter (issue #932).
- Fix various style/theme related crashes, for instance when closing the grid export dialog.
- Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns.
- Fix missing SET TIME_ZONE.. on export target server (issue #1457).
- Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (issue #1417).
- Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (issue #1259).
- Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See https://www.heidisql.com/forum.php?t=38150.
- Support UINT columns in SQLite mode (issue #1453).
- Update SynEdit's list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series (issue #1437).
- Run current query: Prefer query left to the current one, if current one contains no text (issue #603).
- SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables.
- Activate auto-suggest option "Find matches in middle of entered text" by default..
- Don't clear variable from --description cli parameter. (#1295).
- Quote column names for quick filter, when column name matches an SQL function (#1398).
- Session manager: Auto-expand session folder when user filter matches a child session.
- Fixes for handling virtual columns (#1210).
- Add option to turn off tab close by doubleclick/middleclick (#1151).
- Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (issue #1539).
- NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (issue #202).
- Binary values in foreign key pulldown now works with hex code, instead of binary garbage (issue #1540).
- Enhanced foreground/background colors for matching brace in dark themes. (issue #887).
- Fix EAbort error when copying text from SynMemo without highlighter.
v11.3 [Jun 1, 2021]
3rd party updates:
- Update SynEdit component code.
- Update VirtualTrees component code.
- Include Microsoft Visual C 2015-2019 Redistributable in installer, required for some 3rd party libraries (issue #1296).
- Update plink.exe to v0.75.
New stuff:
- Log DDL and/or DML queries per session to custom file path (issue #397).
- Grid text editor:.
- syntax highlighting for 64 code languages, including JSON and XML (issue #136).
- gutter with line numbers and marks for edited lines.
- now using search/replace dialog with regular expression support.
- Enable query timeout setting for MySQL and MariaDB (issue #1306).
- Show check constraints on MySQL, MSSQL and PostgreSQL (issue #1298).
- New menu Query > "Editor commands", revealing available quick actions for SQL editors.
- Create "Editor commands" menu in "Query" main menu, and populate it with all available editor commands.
- Add new preference option for displaying hexadecimal content in lowercase.
v11.2 [Jan 24, 2021]
Issue #136: fix OS crash with large cell text when reading FEdit.SelStart/Length.
v11.0 [Mar 19, 2020]
New features and enhancements in this version:
- Support connecting to SQLite database files.
- drop schema support for PostgreSQL.
- support foreign keys in PostgreSQL.
- support foreign keys in MS SQL.
- read-only mode for grid cell editors, if underlying query or table does not allow updates.
- support scram-sha-256 authentication on PostgreSQL.
- enhanced readability of release notes.
- enhanced readability of help links with dark themes.
- support column comments of PostgreSQL.
- support disabling "Full table status" on PostgreSQL.
- new filter edit box on session manager, for filtering sessions using regular expressions.
- close query tabs via middle mouse click.
- trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting.
- sort collation drop down on "Bulk table editor" alphabetically.
- place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable.
- performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
- widen buttons on search/replace dialog by one quarter, so translations fit better on them.
- use default library of given network type in command line receiver.
- refreshed application icon.
Bugfixes:
- fix crashes when restoring tabs: expect no UTF-8 BOM.
- Procedure body changes invisible when parameter tab is active.
- last active session was no longer scrolled into view area of session manager.
- crash when mouse moves over data grid with broken connection.
- clicking too fast on session folder opens connection instead of collapse.
- passphrase input for SSH tunnel now masked.
- 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.
- fix crash when accessing data from data tab on a disconnected session.
- fix crash when active main tab changes and data grid is disabled (due to disconnect).
- make copy/cut safer against harmless crashes, and show occurring error messages in log panel.
- MSSQL: Remove surrounding parentheses from default value.
- fix state of checkboxes on the session manager's Advanced tab.
- fix crash by click on "Add column" in table editor, when columns list has a minimum height.
Third party libraries and components:
- update libmariadb.dll to v3.1.7.
- update libpq.dll to v10.0.11.
- introduce additional libpq.dll v12.0.1.
- update InnoSetup compiler to v6.0.3.
- update VirtualTree component to v7.3.
- introduce sqlite3.dll v3.30.1.
v11.0 [Apr 22, 2020]
#444: show initial captions and hints of TAction's on shortcut page in preferences dialog.
v10.3 [Dec 13, 2019]
New features and enhancements in this version:
- Theme preview in preferences dialog.
- "Library" dropdown in session manager, to enhance support for older and newer MySQL and MariaDB versions.
- Various new shortcuts in the "Go to" menu, e.g. for switching between result and query area.
- Support newer plink versions for SSH tunneled connections.
- Grid rightclick on cell: "Open in webbrowser" for fields containing a web url.
- Support for client_ed25519 MariaDB plugin.
- Support for SSH tunneled connections to PostgreSQL servers.
- Support for SSL on PostgreSQL servers.
- "Same text" background color in grid now applies to neigbour fields in selected row as well.
- Support for connections to Amazon Redshift (basically older PostgreSQL servers).
- Restored query tabs also restore bind parameters.
- New option in grid export dialog: "Remove linebreaks from data".
- New option to remove DEFINER clauses in SQL export option drop-down.
- Increase compatibility of table editor on PostgreSQL.
Bugfixes:
- Reverts earlier attempts for native high DPI support, so scaling is done by Windows again (blurry but less buggy).
- Auto-detected Chinese localization fixed.
- Compatibility to MySQL 4 restored.
- Various fixes for SSL on MySQL and MariaDB.
- Fixed broken "undo" after auto-uppercased SQL keyword.
- Fixed crash when switching to table/database with same name on different server.
- Fixed invisible column comments on PostgreSQL.
- Fixed unsupported def.adsrc on PostgreSQL 12.
- Ctrl Backspace in text boxes deletes left word, instead of writing cryptic character.
- Fixed update SQL for JSON columns in PostgreSQL.
- Fixed disappearing table comments after saving.
- Fixed warning about unsafe query when fooled with a commented WHERE clause.
v10.2 [Jun 17, 2019]
New features and enhancements in this version:
- High resolution icons from Icons8.
- Save and restore query tabs automatically.
- PostgreSQL connection over SSH tunnel.
- Configurable web search engine for help links in footer of message dialogs.
- Support for DATETIMEOFFSET data types on MSSQL.
- Table designer: Support for custom expressions in column default values.
- Caching of "SELECT 1234::regclass" queries on PostgreSQL connections.
- New data grid menu item "Duplicate row with keys" (besides the old one "Duplicate row without keys).
- Support for TLS versions up to 1.3 in MySQL connections.
Bugfixes:
- Text search on PostgreSQL works properly now.
- Auto-uppercase feature does not touch column names on table aliases.
- Enhanced Material theme colors.
- Artefacts in query editor when using non-default theme.
v9.5 [Dec 30, 2017]
-Expect regular expression in filter text on right panel, not a simple string. Keep searching case insensitive, as in prior logic. Add text hint to filter box so the user knows he can enter a regular expression here. Closes #45.
-Add new TAction for clearing query log, and assign it to the rightclick menu item of it. Give this new action the hotkey Ctrl+Q. Closes #25.
-Add custom setting for number of days to keep queries in the query history.
-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.
-Support grouping by tree node type in "check xyz" menu items on table tools dialog. S
-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.
-Support SQL security setting in view editor via drop down menu.
-Use the right SQL commands for killing a process on PostgreSQL.
v9.3 [Aug 10, 2015]
Added various missing translation strings.
v9.1 [Nov 14, 2014]
This is a maintenance release, which basically reintroduces support for legacy password encryption (pre-4.1 hash format).
v8.3 [Jan 27, 2014]
25 Jan HeidiSQL 8.3 released
This is a maintenance release, fixing a build update problem on Win64, along with various other fixes and the new comment field on the session manager.
v8.1 [Oct 3, 2013]
- Make snippets directory customizable.
- Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
- Introduce Win7 jump items on task button.
- Introduce the data option "Local number format"
- Remove "Run file" dialog, and use a standard Windows IProgressDialog instead when executing a SQL file.
- Added check option "FOR UPGRADE" to maintenance dialog.
- Provide edit box for custom NULL value, in grid export dialog.
- Support length of "max" in data types. Used in MSSQL.
- Added schema support in MSSQL.
- Added overlay icons for table engines Blackhole and MergeMyISAM.
- Added preference option and logic for alternating grid row background colors.
- Display values in grid columns which the user explicitly sets to be a UNIX timestamp in date/time format.
- Append instead of overwrite data grid filter when user has Shift pressed.
- Implement a simple search/replace dialog in the popup text editor.
v8.0 [May 19, 2013]
Available in 23 languages now. Thanks to all translators and Transifex hereby!
- Database tree: Introduce optional folders for tables, views, routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB 5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values different to their session pendant
- Add menu item for launching mysql.exe command line with current parameters.
v7.0 [Feb 12, 2012]
- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export;
- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created;
- Threaded query execution, including a button to stop long running queries;
- Add right click option to toggle visibility of horizontal scrollbar in SQL log .
v1.0 [Jan 21, 2015]
New features and enhancements in this version:
- Support connecting to sqlite database files.
- Drop schema support for postgresql.
- Support foreign keys in postgresql.
- Support foreign keys in MS SQL.
- Read-only mode for grid cell editors, if underlying query or table does not allow updates.
- Support scram-sha-256 authentication on postgresql.
- Enhanced readability of release notes.
- Enhanced readability of help links with dark themes.
- Support column comments of postgresql.
- Support disabling "Full table status" on postgresql.
- New filter edit box on session manager, for filtering sessions using regular expressions.
- Close query tabs via middle mouse click.
- Trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting.
- Sort collation drop down on "Bulk table editor" alphabetically.
- Place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable.
- Performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
- Widen buttons on search/replace dialog by one quarter, so translations fit better on them.
- Use default library of given network type in command line receiver.
- Refreshed application icon.
Bugfixes:
- Fix crashes when restoring tabs: expect no UTF-8 BOM.
- Procedure body changes invisible when parameter tab is active.
- Last active session was no longer scrolled into view area of session manager.
- Crash when mouse moves over data grid with broken connection.
- Clicking too fast on session folder opens connection instead of collapse.
- Passphrase input for SSH tunnel now masked.
- 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.
- Fix crash when accessing data from data tab on a disconnected session.
- Fix crash when active main tab changes and data grid is disabled (due to disconnect).
- Make copy/cut safer against harmless crashes, and show occurring error messages in log panel.
- MSSQL: Remove surrounding parentheses from default value.
- Fix state of checkboxes on the session manager's Advanced tab.
- Fix crash by click on "Add column" in table editor, when columns list has a minimum height.
Third party libraries and components:
- Update libmariadb.dll to v3.1.7.
- Update libpq.dll to v10.0.11.
- Introduce additional libpq.dll v12.0.1.
- Update innosetup compiler to v6.0.3.
- Update virtualtree component to v7.3.
- Introduce sqlite3.dll v3.30.1.
This program allows you to import and export excel tables to MySQUL databases.