HeidiSQL

HeidiSQL

HeidiSQL has been excellent SQL Administration and Development tool so far for me. HeidiSQL has active development team which keeps adding new feature and upgrading and correcting bugs to get us the great tool for MySQL development.

I have been using HeidiSQL since more than three and half years now and I am really happy with it. I must say that we work with heavy database consisting of more than 400 tables and database size exceeding few GBs but HeidiSQL has never let us down. I have tried loading my development database with phpMyAdmin and SQL Buddy both but they just failed to load such a large database with few hundreds of tables..! But with HeidiSQL I never had any problem except I got some crashing sometime in newer 5.x version but I am sure all such things will be fixed in coming builds. I am not telling that there are no other good tools are available in the market but HeidiSQL is in premium open-source tool at free of cost. I remember I had written a post on HeidiSQL 4.x more than a year ago and today we are up with HeidiSQL 5.1.

HeidiSQL 5.1 Interface

HeidiSQL 5.1 Interface

New Features with HeidiSQL 5.x are:

  • Improved UI and design: better, handy interface to edit table structure, indexes, fields - most of routine tasks are at almost 1 or 2 clicks.
  • Improved Stored Procedure, Trigger and new Event support: Trigger and Stored routine support has improved while new support for MySQL Events are added..!
  • Excellent MySQL User Management: User Management support has been good which has improved.
  • Multiple Query tabs: This feature was one of my much awaited feature. I am loving it.:) Bunch of Thanks HeidiSQL Team for this..! :)
  • Copy selected Rows as SQL: You can go to table data view, filter data by your custom criteria and out of that you can select N rows and export as SQL, CSV, XML or HTML. I really like this Copy selected rows as SQL. Excellent and real quick.
  • Improved Data Filter, Export and Find features.

Above listed features are what I have observed and I liked during my usage of HeidiSQL 5.x there might be few or more which I might have missed out...! I am sure if you are not using HeidiSQL so far and if you will give it a try you will not leave it for sure.

HeidiSQL fueatures as defined in ReadMe

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers
using the popular MySQL-Database. It allows you to manage and browse your
databases and tables from an intuitive Windows® interface.

With HeidiSQL you will also be able to
* Generate nice SQL-exports
* Synchronize tables between two databases
* Manage user-privileges
* Import text-files
* Export table-data as CSV, HTML, XML and SQL
* Browse and edit table-data using a comfortable grid
* Create and edit tables, views, stored routines and triggers
* Bulk edit tables (move to db, change engine, collation etc.)
* Batch-insert ascii or binary files into tables
* Write queries with customizable syntax-highlighting and code-completion
* Pretty reformat disordered SQL
* Monitor and kill client-processes
* Connect to servers via commandline
* Find specific text in all tables of all databases of one server
* Optimize and repair tables in a batch manner
* And much more

You can browse through HeidiSQL 5.1 screenshots on official website to take a look at what's new and what is being offered or just download to try.

With this post I would like to appreciate and thanks HeidiSQL team for great work. Thanks Team.

Similar Posts: