Connects, manages, and organizes the database structure for supported SQL-based applications like MySQL, Microsoft SQL, and PostgreSQL. Provides the tools to export the entire database structure locally, or remotely on the other supported servers and edit it accordingly (edit, copy, paste, table altering, procedures, scheduled events).
HeidiSQL it's a program developed by Ansgar Becker for developers and administrators that have to deal with MySQL databases at their working sites.
It comes wrapped in an old-fashioned interface, one that reminds of Windows XP, but which embeds lots of functions and commands and it's highly responsive to user commands. It has some font and background color customizations but unfortunately has no other themes than the default one. Also, another downside it's the miss of a built-in debugger.
Speaking about functionalities, the program offers a wide variety of facilities for database management. With HeidiSQL is possible to run and establish several databases at once, thus making creation and editing of tables much easier.
Moreover, the program offers the tools to create and run custom queries, where you can give permissions for every user to access the databases.
Besides that, you can export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array, write queries with customizable syntax-highlighting and code-completion or bulk edit tables.
HeidiSQL also offers the option to export and import settings with just one click, therefore exporting and synchronizing SQL databases becomes easier to do.
All in all, this software program delivers what developers and administrators would expect: a highly responsive system with lots of functionalities. Above that, it's free and it's constantly improved and updated.
v12.0 [Apr 13, 2022]
3rd party updates:
- Update SQLite libraries to v3.38.0.
- Update VirtualTrees component source to v7.6.1.
- Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode).
- Update libmariadb.dll and plugins to current stable versions.
New stuff:.
- Experimental support for high DPI in default Windows theme/style.
- Experimental support for Interbase and Firebird connections (issue #1169).
- Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (issue #362).
- SQL export: add new menu item "Copy mysqldump command line" in "Options".
- Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini.
- Create editor commands for moving line up/down (Alt Up, Alt Down, "Edit" menu).
- Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285).
- New context menu items "Close query tabs to the right", and "Close all query tabs" (issue #710).
- New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360).
- New grid export format: SQL UPDATEs (issue #125).
- New grid export format: Jira Textile (issue #1013).
- Empty-tables-confirmation supports disabling foreign key checks (issue #1491).
- Support renaming SQLite tables in database tab (#1427).
- Editor highlights all occurrences of selected word, similar to Notepad (issue #670).
Bugfixes and enhancements:.
- 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..
- Remove closing PHP tag from export as PHP array.
- Performance enhancement with many opened query tabs.
- Fix some potential file related exceptions in text file import.
- Support filenames with accented chars in text file import dialog (issue #1387).
- New query tab uses the same memo height as the current tab.
- Session background color now used on query result tabs, and in query gutter (issue #932).
- Fix various style/theme related crashes, for instance when closing the grid export dialog.
- Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns.
- Fix missing SET TIME_ZONE.. on export target server (issue #1457).
- Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (issue #1417).
- Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (issue #1259).
- Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See https://www.heidisql.com/forum.php?t=38150.
- Support UINT columns in SQLite mode (issue #1453).
- Update SynEdit's list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series (issue #1437).
- Run current query: Prefer query left to the current one, if current one contains no text (issue #603).
- SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables.
- Activate auto-suggest option "Find matches in middle of entered text" by default..
- Don't clear variable from --description cli parameter. (#1295).
- Quote column names for quick filter, when column name matches an SQL function (#1398).
- Session manager: Auto-expand session folder when user filter matches a child session.
- Fixes for handling virtual columns (#1210).
- Add option to turn off tab close by doubleclick/middleclick (#1151).
- Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (issue #1539).
- NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (issue #202).
- Binary values in foreign key pulldown now works with hex code, instead of binary garbage (issue #1540).
- Enhanced foreground/background colors for matching brace in dark themes. (issue #887).
- Fix EAbort error when copying text from SynMemo without highlighter.
Feature-rich relational database known for its high performance and excellent concurrency
Mall Creeps
