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.
v9.5 [Dec 30, 2017]
-Expect regular expression in filter text on right panel, not a simple string. Keep searching case insensitive, as in prior logic. Add text hint to filter box so the user knows he can enter a regular expression here. Closes #45.
-Add new TAction for clearing query log, and assign it to the rightclick menu item of it. Give this new action the hotkey Ctrl+Q. Closes #25.
-Add custom setting for number of days to keep queries in the query history.
-Use the grid export dialog for setting values for copy-to-clipboard clicks on grids. Adds a new button in the lower left on that dialog.
-Support grouping by tree node type in "check xyz" menu items on table tools dialog. S
-Include ADO connection string in status bar connection details, shorten the lines reasonably and show the full lines in a message box when clicking on it.
-Support SQL security setting in view editor via drop down menu.
-Use the right SQL commands for killing a process on PostgreSQL.
Feature-rich relational database known for its high performance and excellent concurrency
