Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL 11.3 with syntax highlighting in grid text editor

ansgar's profile image ansgar posted 6 months ago in Anouncements Permalink

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:

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
tonypdmtr's profile image tonypdmtr posted 6 months ago Permalink

Please do NOT drop the 32-bit releases.

tonypdmtr's profile image tonypdmtr posted 6 months ago Permalink

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.

ansgar's profile image ansgar posted 6 months ago Permalink

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

delphichem's profile image delphichem posted 6 months ago Permalink

Do not drop 32 bit version please

scottlapointe's profile image scottlapointe posted 6 months ago Permalink

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

tonypdmtr's profile image tonypdmtr posted 6 months ago Permalink

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.

sau's profile image sau posted 6 months ago Permalink

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 ?

ansgar's profile image ansgar posted 6 months ago Permalink

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

CFlath's profile image CFlath posted 6 months ago Permalink

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.

1 attachment(s):
  • 2021-06-01_14-58-47
ansgar's profile image ansgar posted 6 months ago Permalink

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

CFlath's profile image CFlath posted 6 months ago Permalink

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.

Code modification/commit fcfb6ea from Ansgar Becker <anse@heidisql.com>, 6 months ago, revision 6296
Modify TQueryTab.LoadContents so it only catches crashes in ReadTextfile(), and let the remaining unsuspicious code run without catching a crash. This way we should get an exact crash report here: https://www.heidisql.com/forum.php?t=37945#p37957
ansgar's profile image ansgar posted 6 months ago Permalink

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

CFlath's profile image CFlath posted 6 months ago Permalink

@ansgar, please see attached. Thanks

1 attachment(s):
Code modification/commit db0affd from Ansgar Becker <anse@heidisql.com>, 6 months ago, revision 6301
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. See https://www.heidisql.com/forum.php?t=37945#p37959
ansgar's profile image ansgar posted 6 months ago Permalink

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

CFlath's profile image CFlath posted 6 months ago Permalink

@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!

ansgar's profile image ansgar posted 6 months ago Permalink

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.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.