Software Review: HeidiSQL, you can get rid of phpMyAdmin now

24 05 2007

I found HeidiSQL today which blows away all other products in the category. It is a third party GUI management tool for MySQL, 100% free, 1.5MB download size for windows and takes only 2.4MB on hard drive, when installed.

I found HeidiSQL on www.osalt.com. Somebody commented that, “Better functionality than phpmyadmin”. I wasn’t too optimistic before I used it. And now I agree with him big time. I was looking for something like this for months. I use phpMyAdmin, wanted to switch to a faster alternative, but could not find a good one.

  • I tried MySQL Control Center (mysqlcc), which I feel has freaky MDI.
  • Tried trial version of MySQLyog, which was kind of OK, but not free.
  • Tried MySQL Toad. Many people I know uses that, But I found it cumbersome to use.
  • Tried MySQL Administrator, which is not a product in the same domain. It helps you manage the server rather than managing tables and data on it quick and fast.

So I had to fall back to phpMyAdmin which is complete but slow because of web interface and can never beat a native windows software. But now HeidiSQL proves itself as good in usability, simplicity and feature set. And As a bonus think of how light it is. I ready to use a 5 to 10 times heavier application as smart as this. I tested first of all it’s large SQL file import ability. It imports 20MB SQL without any problem. Has csv, html and xml export feature. On the spot editing in tables, like MS Access. Can import files as blob directly. And the help file is another excellent feature quoth smart SQL references with examples. It will make you refer to it for most day to day MySQL activities. Features quick filters which is great to use.Only feature I can ask for is, ability to remove some columns from the views, which mysqlcc has.

Feature list from their site:

* generate nice SQL-exports
* synchronize tables between two databases
* manage user-privileges
* import text-files
* export table-data as CSV, HTML and XML
* browse and edit table-data using a comfortable grid
* batch-insert ascii or binary files into tables
* write queries with syntax-highlighting (next version will have also code-completion)
* monitor and kill client-processes
* and much more

I am looking forward to see more intuitive improvements in the future versions. Lets wrap up with some screen shots.



Please feel free to drop your suggestions to help me improve my reviews.

technorati tags:, , , , , , , , , , , ,

Blogged with Flock


Actions

Information

5 responses

26 05 2007
Ehab

No. nothing beats phpMyAdmin :$

26 05 2007
skywriter14

7h4nx |=0r 7h3 (o/v\/v\3n7 (I guess you understand leet). Did you try it though? I admit, phpMyAdmin is hard to beat. But you can’t edit a table on the spot in phpMyAdmin. And it’s slow.

11 09 2009
Steve

Nice post. You might want to link this post to the bookmarks section!!

http://www.gplpedia.com/Softwares/about/HeidiSQL.html?type=about

17 02 2012
compfused

All I can say is that I was stunned coming from developing database on MS access/ASP platform and finally found a tool that now makes it same easy handle SQL database for my PHP programming

This app rocks big time. I dumped MySQL a second after I tried this.

Thanks a bunch

15 04 2013
Daniel

I use a free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview at the moment. Does everything you need, and does it very well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: