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.
v8.1 [Oct 3, 2013]
- Make snippets directory customizable.
- Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
- Introduce Win7 jump items on task button.
- Introduce the data option "Local number format"
- Remove "Run file" dialog, and use a standard Windows IProgressDialog instead when executing a SQL file.
- Added check option "FOR UPGRADE" to maintenance dialog.
- Provide edit box for custom NULL value, in grid export dialog.
- Support length of "max" in data types. Used in MSSQL.
- Added schema support in MSSQL.
- Added overlay icons for table engines Blackhole and MergeMyISAM.
- Added preference option and logic for alternating grid row background colors.
- Display values in grid columns which the user explicitly sets to be a UNIX timestamp in date/time format.
- Append instead of overwrite data grid filter when user has Shift pressed.
- Implement a simple search/replace dialog in the popup text editor.
Feature-rich relational database known for its high performance and excellent concurrency
