powered/hosted by Host Europe

Latest posts in user forum

Download HeidiSQL 5.0 Beta

Download HeidiSQL 4.0 stable

This is the current Unicode release. Previous releases can be downloaded at Google Code. jHeidi can be found here.

HeidiSQL runs fine on Windows (2000, XP, Vista, 7) and on any Linux with Wine.

Nightly Builds of heidisql.exe RSS Feed

Latest automatically compiled main executable for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe (or whatever).

Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones!

Link to latest build

Revision Compiled .EXE Notes
3067 heidisql.r3067.exe 4028K

Committed: Feb 08, 2010 21:57pm, Compiled: Feb 08, 2010 21:57pm

Prefer VT.FocusedNode over VT.GetFirstSelected in various places. Clicking a node twice deselects it and subsequent actions have an access violation. Fixes issue #1674.

Build log
3066 heidisql.r3066.exe 4028K

Committed: Feb 08, 2010 01:36am, Compiled: Feb 08, 2010 01:37am

Delphi 2010 has PNG + alpha channel support in TImageList, so we don't need PNGcomponents any longer.

Build log
3065 heidisql.r3065.exe 4010K

Committed: Feb 08, 2010 00:36am, Compiled: Feb 08, 2010 00:36am

Remove unused icons

Build log
3064 heidisql.r3064.exe 4010K

Committed: Feb 07, 2010 18:11pm, Compiled: Feb 07, 2010 18:11pm

Unify color depth of icons to 32 bits per pixels.

Build log
3063 heidisql.r3063.exe 4010K

Committed: Feb 07, 2010 17:59pm, Compiled: Feb 07, 2010 17:59pm

Surround TRIGGER creation export with custom DELIMITER, so readers (including HeidiSQL itself) are able to detect query end positions. Fixes issue #1672.

Build log
3062 heidisql.r3062.exe 4009K

Committed: Feb 07, 2010 15:23pm, Compiled: Feb 07, 2010 15:23pm

Remove pink foreign key icon - we already had another one. Use that consistently in both foreign key list and columns list.

Build log
3061 heidisql.r3061.exe 4010K

Committed: Feb 07, 2010 13:31pm, Compiled: Feb 07, 2010 13:31pm

Add pink icon for foreign key columns. Fixes issue #1669.

Build log
3060 heidisql.r3060.exe 4009K

Committed: Feb 07, 2010 13:14pm, Compiled: Feb 07, 2010 13:14pm

Auto create pretty foreign key name "FK_thistable_reftable" if it was not customized yet. Fixes issue #1671.

Build log
3059 heidisql.r3059.exe 4009K

Committed: Feb 07, 2010 12:59pm, Compiled: Feb 07, 2010 12:59pm

End editing with home brown editors when the underlying tree scrolls, to avoid a misplaced cell editor. Fixes issue #1670.

Build log
3058 heidisql.r3058.exe 4009K

Committed: Feb 07, 2010 12:37pm, Compiled: Feb 07, 2010 12:37pm

Only display tables in reference table pulldown of foreign key editor. Stored procedures or triggers cannot be applied here. Fixes issue #1668.

Build log
3057 heidisql.r3057.exe 4009K

Committed: Feb 07, 2010 12:32pm, Compiled: Feb 07, 2010 12:32pm

Also quote column names when doubleclicking or dragging from a query helpers column list. Fixes issue #1666.

Build log
3056 heidisql.r3056.exe 4009K

Committed: Feb 07, 2010 12:20pm, Compiled: Feb 07, 2010 12:21pm

Same as r3053, this time for doubleclicking a tree node: Prepend database name, and use backticks. Fixes issue #1666.

Build log
3055 heidisql.r3055.exe 4009K

Committed: Feb 07, 2010 11:45am, Compiled: Feb 07, 2010 11:45am

Foreign key editor needs to be repainted when selecting another table. Fixes issue #1667.

Build log
3054 heidisql.r3054.exe 4009K

Committed: Feb 06, 2010 14:48pm, Compiled: Feb 06, 2010 14:48pm

Fix mysterious endless loop in user manager, after having focused the password editor once. Make use of Delphi's new TextHint property to display the old hashed password, instead of assigning and removing OnChange handlers all the time. Fixes issue #1658.

Build log
3053 heidisql.r3053.exe 4009K

Committed: Feb 05, 2010 22:18pm, Compiled: Feb 05, 2010 22:18pm

Include database name when dropping a db tree node onto a query editor. Fixes issue #1661.

Build log
3052 heidisql.r3052.exe 4009K

Committed: Feb 05, 2010 18:18pm, Compiled: Feb 05, 2010 18:19pm

Issue #1656: Upscale status bar panels in non-96-DPI mode, so text is not cut off.

Build log
3051 heidisql.r3051.exe 4009K

Committed: Feb 05, 2010 18:08pm, Compiled: Feb 05, 2010 18:08pm

Avoid desktop flickering on WinXP at the cost of minor flickering on the main tabs. Seems LockWindowUpdate() should be used with caution. Fixes issue #1659.

Build log
3050 heidisql.r3050.exe 4009K

Committed: Feb 05, 2010 18:02pm, Compiled: Feb 05, 2010 18:03pm

Fix invisible "New query tab" button, broken in r3049.

Build log
3049 heidisql.r3049.exe 4009K

Committed: Feb 05, 2010 00:50am, Compiled: Feb 05, 2010 00:51am

Try to fix most DPI related glitches. Especially TFrames need a ScaleBy() call, which is done automatically on TForms. Fixes issue #1656.

Build log
3048 heidisql.r3048.exe 4015K

Committed: Feb 04, 2010 19:56pm, Compiled: Feb 04, 2010 19:57pm

Do not reset remove AUTO_INCREMENT clause from CREATE TABLE when no data gets exported. Fixes issue #1110.

Build log
3047 heidisql.r3047.exe 4015K

Committed: Feb 04, 2010 01:39am, Compiled: Feb 04, 2010 01:39am

Introduce new log category lcUserFiredSQL, and make log level customizable via preferences. Fixes issue #1652.

Build log
3046 heidisql.r3046.exe 4012K

Committed: Feb 04, 2010 00:27am, Compiled: Feb 04, 2010 00:27am

Work around non working SynEdit.OnSearchNotFound event, when search text could not be found in query memo.

Build log
3045 heidisql.r3045.exe 4013K

Committed: Feb 04, 2010 00:07am, Compiled: Feb 04, 2010 00:08am

Force multi line hint tool tips in grids.
* Fixes issue #1649
* Fixes issue #1567

Build log
3044 heidisql.r3044.exe 4013K

Committed: Feb 03, 2010 23:18pm, Compiled: Feb 03, 2010 23:18pm

Replace default value in object editors by ghosted hint text

Build log
3043 heidisql.r3043.exe 4012K

Committed: Feb 03, 2010 23:12pm, Compiled: Feb 03, 2010 23:12pm

Fill default content of trigger body with a BEGIN END block. Fixes issue #1653.

Build log
3042 heidisql.r3042.exe 4012K

Committed: Feb 02, 2010 22:28pm, Compiled: Feb 02, 2010 22:28pm

Display ghosted hint text on combobox for database filter

Build log
3041 heidisql.r3041.exe 4012K

Committed: Feb 02, 2010 20:55pm, Compiled: Feb 02, 2010 20:56pm

Highlight matching brackets in all SQL editors. Use code from the SynEdit Demo "OnPaintTransient". Fixes issue #1630.

Build log
3040 heidisql.r3040.exe 4011K

Committed: Feb 02, 2010 20:23pm, Compiled: Feb 02, 2010 20:24pm

Cosmetic: Avoid jumping column headers when many notices go into the result log.

Build log
3039 heidisql.r3039.exe 4011K

Committed: Feb 02, 2010 20:13pm, Compiled: Feb 02, 2010 20:14pm

Fix broken r3034: "100%" was displayed in between on large tables, after each loop of 100MB loading. Fixes issue #1628.

Build log
3038 heidisql.r3038.exe 4011K

Committed: Feb 02, 2010 08:18am, Compiled: Feb 02, 2010 10:33am

Fix unresponsive query memo on large "replace all" actions. Also, move redundant code to DoSearchReplace.

Build log
3037 heidisql.r3037.exe 4011K

Committed: Feb 02, 2010 01:18am, Compiled: Feb 02, 2010 10:33am

After selecting a valid export filename, the export button should be active. Fixes issue #1641.

Build log
3036 heidisql.r3036.exe 4011K

Committed: Feb 02, 2010 01:15am, Compiled: Feb 02, 2010 10:32am

When foreign key tab is active with a MyISAM table, switching to a InnoDB table did not activate the controls. Fixes issue #1642.

Build log
3035 heidisql.r3035.exe 4011K

Committed: Feb 02, 2010 00:55am, Compiled: Feb 02, 2010 10:31am

Implement a home brown find + replace dialog, supporting regular expressions, and using all stuff SynEdit gives us. Add main menu item "Search" next to "Edit". Fixes issue #1069.

Build log
3034 heidisql.r3034.exe 4005K

Committed: Jan 30, 2010 19:00pm, Compiled: Jan 30, 2010 19:00pm

Don't use the calculated percentage of processed row count after exporting each table. Just display a hard coded "100%" so InnoDB tables display the right percentage (at least when table data is at eof). Fixes issue #1628.

Build log
3033 heidisql.r3033.exe 4005K

Committed: Jan 30, 2010 18:50pm, Compiled: Jan 30, 2010 18:50pm

If the specified filename in SQL export dialog is empty, disable the execute button. If the file cannot be created for some reason, do not pop up a message dialog. Instead, log the error message into the result list. Fixes issue #1627.

Build log
3032 heidisql.r3032.exe 4005K

Committed: Jan 30, 2010 12:40pm, Compiled: Jan 30, 2010 12:40pm

Build log
3031 heidisql.r3031.exe 4005K

Committed: Jan 30, 2010 09:28am, Compiled: Jan 30, 2010 09:28am

Fix missing and partly wrong search paths in project files for "release" configuration

Build log
3030 heidisql.r3030.exe 4005K

Committed: Jan 30, 2010 09:15am, Compiled: Jan 30, 2010 09:15am

Automatic dfm changes by IDE: Removed ComboBox.ItemHeight property and auto-adjusted dimensions of various buttons and other controls.

Build log
3029 heidisql.r3029.exe 4006K

Committed: Jan 30, 2010 09:05am, Compiled: Jan 30, 2010 09:05am

Silence compiler warning

Build log
3028 heidisql.r3028.exe 4006K

Committed: Jan 30, 2010 09:02am, Compiled: Jan 30, 2010 09:02am

Preparations for upcoming major release

Build log
3027 heidisql.r3027.exe 4006K

Committed: Jan 30, 2010 08:57am, Compiled: Jan 30, 2010 08:57am

Add a toolbar button which, when pressed, allows BLOBs to be displayed as text. Explicitly ignoring weird effects in grid updates/inserts. Fixes issue #1624.

Build log
3026 heidisql.r3026.exe 4004K

Committed: Jan 29, 2010 21:43pm, Compiled: Jan 29, 2010 21:43pm

Update VirtualTreeView sources to revision 250.

Build log
3025 heidisql.r3025.exe 4004K

Committed: Jan 29, 2010 21:38pm, Compiled: Jan 29, 2010 21:38pm

Suppress access violation caused by VCL bug. Fixes issue #1622.

Build log
3024 heidisql.r3024.exe 4004K

Committed: Jan 29, 2010 00:26am, Compiled: Jan 29, 2010 00:27am

Update readme.txt: Add documentation on command line switches, adjust wording in general, fix wrong infos.

Build log
3023 heidisql.r3023.exe 4004K

Committed: Jan 28, 2010 00:59am, Compiled: Jan 28, 2010 01:00am

Remove workaround from r2338 - no need to force the taskbar button active now that the "Retry connection" logic was removed. Could probably fix issue #1622.

Build log
3022 heidisql.r3022.exe 4004K

Committed: Jan 28, 2010 00:45am, Compiled: Jan 28, 2010 00:46am

Minor code simplification, old TNT StringList workaround.

Build log
3021 heidisql.r3021.exe 4004K

Committed: Jan 28, 2010 00:39am, Compiled: Jan 28, 2010 00:39am

Enhance command line processing:
* Rewrite parameter parser
* Remove support for "-C" option (compressed). Anyway switched on by default.
* Add support for loading multiple SQL files at once instead of only one: "fileA.sql fileB.sql ..."
* Also process connection parameters when "Allow multiple application instances" is disabled
* If a session name is specified with -dXYZ, load params from registry, but allow the user to override these by passing e.g. a different user name "-uOtherUser"
Fixes issue #1332.

Build log
3020 heidisql.r3020.exe 4003K

Committed: Jan 26, 2010 21:00pm, Compiled: Jan 26, 2010 21:00pm

Work around a possible timing issue, when the db tree is painted with more nodes than the database has objects. Guess that occurs on a reconnection. Fixes issue #1621.

Build log
3019 heidisql.r3019.exe 4003K

Committed: Jan 24, 2010 16:15pm, Compiled: Jan 24, 2010 16:16pm

Minor code simplification

Build log
3018 heidisql.r3018.exe 4003K

Committed: Jan 24, 2010 16:07pm, Compiled: Jan 24, 2010 16:07pm

Remove TMySQLConnection.Capabilities , which should have brought some light into the feature set of the server. Still doing that per version comparison which is nice enough.

Build log
3017 heidisql.r3017.exe 4004K

Committed: Jan 24, 2010 01:14am, Compiled: Jan 24, 2010 01:14am

Add preference option to restrict number of application instances to 1. If the executable is open and called a second time, it's brought to foreground. Plus, if a filename was passed, a new tab is opened. Should fix a part of what is described in issue #1332.

Build log
3016 heidisql.r3016.exe 4002K

Committed: Jan 24, 2010 01:03am, Compiled: Jan 24, 2010 01:04am

Code cosmetic: Remove dead code, and bring some variables into the right order

Build log
3015 heidisql.r3015.exe 4002K

Committed: Jan 23, 2010 22:54pm, Compiled: Jan 23, 2010 22:54pm

Fine tune main package file, so we don't accidentally set weird things like "Typed @ operator" and more.

Build log
3014 heidisql.r3014.exe 4002K

Committed: Jan 22, 2010 11:21am, Compiled: Jan 22, 2010 11:21am

Add support for indexes using BTREE/RTREE/HASH algorithm. Make that visible in a new, 3rd column in the index tree. Fixes issue #1576.

Build log
3013 heidisql.r3013.exe 4001K

Committed: Jan 22, 2010 09:54am, Compiled: Jan 22, 2010 09:54am

Don't quote numeric values in grid export as SQL. See: http://www.heidisql.com/forum.php?t=4885

Build log
3012 heidisql.r3012.exe 4001K

Committed: Jan 21, 2010 11:24am, Compiled: Jan 21, 2010 11:24am

Update readme files, now that a few packages were removed.

Build log
3011 heidisql.r3011.exe 4001K

Committed: Jan 20, 2010 00:51am, Compiled: Jan 20, 2010 00:51am

SizeOf(AnsiStrings) returns 4, the size of a 32 bit pointer, not the number of bytes which one char takes. Fix that. Also, stabilize text copying to clipboard by just using Clipboard.AsText. Fixes issue #1614.

Build log
3010 heidisql.r3010.exe 4002K

Committed: Jan 20, 2010 00:19am, Compiled: Jan 20, 2010 00:19am

Convert MySQL date/time values more safely against 0-dates. Fixes issue #1613

Build log
3009 heidisql.r3009.exe 4000K

Committed: Jan 19, 2010 23:49pm, Compiled: Jan 19, 2010 23:49pm

Columns of selected datagrid object can also come from a view, so ParseTableStructure is not sufficient in both data sorting and column selection forms. Instead, just use mainform's lists which are exactly what we need. Fixes issue #1611.

Build log
3008 heidisql.r3008.exe 4026K

Committed: Jan 19, 2010 01:58am, Compiled: Jan 19, 2010 01:58am

Wording: Users know the differences between INSERT/REPLACE/DELETE+INSERT . Say it more clearly in the selection box what gets generated.

Build log
3007 heidisql.r3007.exe 4026K

Committed: Jan 19, 2010 01:55am, Compiled: Jan 19, 2010 01:55am

Do not generate "_binary 0x" for empty blobs. Fixes issue #1610.

Build log
3006 heidisql.r3006.exe 4026K

Committed: Jan 19, 2010 01:45am, Compiled: Jan 19, 2010 01:45am

Add formatted HTML to clipboard for "Copy rows as HTML". Fixes issue #1249

Build log
3005 heidisql.r3005.exe 4021K

Committed: Jan 18, 2010 09:22am, Compiled: Jan 18, 2010 09:22am

If the first column with the number of the column has too less width, sometimes it's not clear that the user can resize it to show its whole text. This change adds an auto-resize mechanism, which is fired after any node structure was changed. Fixes issue #1609.

Build log
3004 heidisql.r3004.exe 4021K

Committed: Jan 17, 2010 17:52pm, Compiled: Jan 17, 2010 17:53pm

Save a loop for finding the right tree node in topic browser, when the user already clicked the relevant item. Fixes wrong item selection when item text exists twice or more often (e.g. "SHOW PLUGINS") Fixes issue #1575.

Build log
3003 heidisql.r3003.exe 4021K

Committed: Jan 17, 2010 17:12pm, Compiled: Jan 17, 2010 17:12pm

Disable non working column default values for given data type. Fixes issue #1519.

Build log
3002 heidisql.r3002.exe 4021K

Committed: Jan 17, 2010 16:23pm, Compiled: Jan 17, 2010 16:23pm

If user disables "Allow NULL" for some column which has NULL as default value, silently change that default value to "No default", instead of "Custom text". Additionally, this fixes the default text "NULL" as literal in such cases.

Build log
3001 heidisql.r3001.exe 4021K

Committed: Jan 17, 2010 14:31pm, Compiled: Jan 17, 2010 14:32pm

Do not pass <Enter> key to parent grid, if radio button or checkbox on default editor is currently focused. Fixes issue #1605.

Build log
3000 heidisql.r3000.exe 4019K

Committed: Jan 17, 2010 11:50am, Compiled: Jan 17, 2010 11:51am

Override VirtualTree's incremental search event, make it case insensitive, and apply that event in FixVT to various lists and grids, which have IncrementalSearch enabled. Fixes issue #1605.

Build log