WineHQ

HeidiSQL

No Screenshot

Submit Screenshot

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

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

Complete change list: https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1

Application Details:

Version: 10.x
License: Free to use
URL: http://www.heidisql.com
Votes: 0
Latest Rating: Platinum
Latest Wine Version Tested: 6.5

Maintainers: About Maintainership

Free Download Download via official website

Test Results

Old test results
The test results you have selected are very old and may not represent the current state of Wine.
Selected Test Results

What works

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.

Workarounds

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.

Hardware tested

Graphics:

  • GPU: Intel
  • Driver: proprietary

Additional Comments

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.

selected in Test Results table below
Operating systemTest dateWine versionInstalls?Runs?Used
Workaround?
RatingSubmitter
ShowDebian 10.x "Buster"Apr 03 20216.5Yes Yes NoPlatinumBorislav Sabev 
CurrentSlackware64 14.2 multilibFeb 04 20194.1Yes Yes YesGoldZootal 

Known Bugs

Bug # Description Status Resolution Other apps affected

Show all bugs

Comments

Back