5 cross-platform alternatives to HeidiSQL
When it comes to database administration, HeidiSQL seems to be the best (gui) tool available. Unfortunately, it's only available for Windows and it doesn't look like a cross-platform is coming anytime soon. Fortunately, there are some really good cross-platform alternatives and in this post I will have a quick look at five of them:
MySQL Workbench is a MySQL client maintained by Oracle (which also maintains MySQL server these days). It is the most advanced client I've tested and packs some really nice features like server load statistics. On the downside: it seems to be a bit unstable and occasionally crashed on my system.
Toad is a nice client developed and maintained by Dell that supports multiple database platforms. The interface is is clear and it seems to be quite stable. It doesn't have some of the advanced features of other clients but for typical usage this shouldn't be a problem.
DBeaver (editors choice)
DBeaver is my personal favorite. It is developed and maintained by a company named JKISS. It is well packed with features, supports multiple database platforms and seems to be stable. The interface is based on Eclipse and is easy to understand. The only problem I encountered with this program is when I tried to make a database dump when DBeaver required me to point to manual installed 'mysqldump' instance.
SQuireLSQL is a community developed, Java written client. My experiences with it weren't any good. It may require manual installation of JDBC drivers and it feels a bit unstable. I personally can only recommend picking any of the other clients available.
Emma is a nice tiny and fast database client written in Python, it's extremely lightweight and the feature set is just enough for basic CRUD operations. Emma's interface shines in simplicity. It's quite stable (though occasional crashes may appear). It's perfect for simple databases.
Ubuntu Apps Directory
When you don't want to fall back to a command line, many graphical database clients are available and they all differ in terms of stability and features. The most advanced client is MySQL Workbench, but occasional crashes (on my system) made me look for an alternative. I was really impressed with the feature set and stability of DBeaver and this will be my goto client. If you're however, looking for a lightweight alternative I would suggest Emma. But off course, the choice is yours.
Thanks for reading!