HeidiSQL 11.3 with syntax highlighting in grid text editor

Get it from the download page

Still need 32bit support?

• 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.

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

Bugfixes and enhancements:

• Query tab resizes after minimize (issue #1113)
• Foreign key add issue (issue #1320)
• Cannot update/insert postgres jsonb column from data editor (issue #1321)
• MariaDB 10.5: REPLICATION CLIENT privilege was renamed to BINLOG MONITOR (issue #1302)
• Quoted column default value expression on Percona (issue #1282)
• Cannot delete row in MSSQL (issue #1294)
• 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
• 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
• function COALESCE is identified as plain text, not function (issue #1342)
• Non-synchronized checkbox state on privileges in user manager tree (issue #1352)
• Auto-scroll grid when tabbing through cells
• Run SQL button disabled after reconnect (issue #1319)
• Don't repeat running prompt to reload a file after multiple external changes (issue #821)
• Fix identifier quoting when creating a foreign key in a database with dots in its name (issue #1364)
• Increase maximum pixel width of status bar panels slightly, so these better fit with a larger font size. (issue #1356)
• Get rid of quotes around hex values and integers in quick filters
• Fix crash happening when using un/comment action. (issue #1359)
• include column names in "copy as" submenu export actions by default (issue #1357)
• Restore/keep cursor position in filter editor after refresh
• Detect pressed shift key before prompting for filter value. (issue #588)
• Fix wrong query duration in log panel after multiple queries in "one-go" mode
• Unhide public schema on Redshift
• Table tools: auto-fit column widths with each result grid update, and show execution time in main status bar
• Enable menu items for EXPLAIN <query> on PostgreSQL and SQLite

Please do NOT drop the 32-bit releases.

To add to my previous comment, I'm specifically interested in the portable 32-bit version. If this makes any difference for you because you mentioned the installer size.

Does that mean you cannot use the 64bit version or you don't like to?

Do not drop 32 bit version please

I'm sure you're asked this all the time, but any chance on a Mac port ?

I have 32-bit PCs on various locations, so I cannot use the 64-bit version.

However, I'm happy with just the portable 32-bit version. I don't need the installer version.

The update installed itself through the windows store. After that, when running the app I lost all my settings, is there a way to retrieve it ?

Settings are still there, the Store version is wrongly marked as a portable. I already updated the version in the store with a bugfix, so you should update once again.

But the store updates are quite slow in some cases. If you don't get an update there, here's a manual fix: https://github.com/HeidiSQL/HeidiSQL/issues/1382#issuecomment-852139550

After installing the new release and rebooting, all of my existing saved queries are throwing an access violation error in the executable itself. The queries continue to function, but the UI loses cursor focus and the query is treated as if it was a new adhoc query rather than one that was previously saved.

@CFlath does that error appear when you load that sql file, or when you run it?

Sorry, when I load any saved query files. They do continue to run properly, however I also lose my cursor in the query section and the saved query appears as an unsaved new query.

@CFlath, please update to the next nightly build and try again. That build will most likely crash at the same point where you got a dialog up to now. Please post the crash report here, so I can find and fix the actual cause.

@ansgar, please see attached. Thanks

@CFlath, thanks for quick feedback. Crash is fixed in the latest build.

Cause was the expectation a loaded file always happens on the active tab, which is not always the case. Especially when loading multiple files from File > Load SQL file.

@ansgar Thank you for the patch. It is working properly with no errors. I wish every developer I interact with was so responsive. Much appreciated!

Usage statistics say that roughly 1% of all users are using a 32 bit version of HeidiSQL.

But I think it's quite clear now some users still really need a 32 bit version. So I'll keep up the support for these. With one exception: Only the official releases (installer and portable) will include both bit versions. Nightly builds will only be created for the 64 bit version from now on.

@scottlapointe: I would be happy to offer a native Mac port (and a Linux port). But this would be a separate project, for which I have no time unfortunately.