The newest major version of HeidiSQL released in 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
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
Complete change list: https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1
Almost everything. It installs, it runs. You can connect to database servers, browse tables, modify data, modify tables. Update user permissions. Store multiple profiles for multiple servers. Export results. Save and load sql snippets. Everything I tried works with one exception: see notes below on crash when running custom query against MSSQL server.
What does not
Program crashes when running custom queries against MSSQL only. You can run custom queries against other databases just fine, it is only
Microsoft sql server. I don't know why, and I have not been able to find a workaround. There is a wine bug report for this specific problem. This is the only thing I know of that does not work.
Must install mdac28 and set native_mdac via winetricks. Optionally you can install corefonts via winetricks (sh winetricks corefonts) or fonts will be a bit odd looking.
If you want to avoid the crash when running custom query against MSSQL database, try wine version 3.14. This problem does not occur with that version. Wine versions 3.15 and cause various crashing problems.
What was not tested
Nothing that I can think of - I've been using this program for a long time, and I ran it through its paces. I use it almost every day. I'm
sure there are some obscure bugs in it, but I did everything I could think of.
I give it a SILVER rating because of the above mentioned crash. There is no workaround that I am aware of other than to use an older wine version.
This report is primarily for version 10.1. However, the crashing problem described above happens to version 9.5 and 10.0 of HeidiSQL as well.
I tested every version of wine from 3.0 through 4.1.
With wine versions 3.0 through 3.14, this program works perfectly. Starting with wine 3.15 and above, including 4.0 and 4.1, there are various crashing problems.
|Debian 10.x "Buster"
|Apr 03 2021
|Slackware64 14.2 multilib
|Feb 04 2019