One of the most wanted, needed features in HeidiSQL was a GUI for creating and editing triggers, available in MySQL 5.0.2 and above. Now implemented and hopefully as usable at it can be. Very simple compared to editing tables or procedures. See it in action by downloading the latest build file (Help > Check for updates).

The recently refactored "Table tools" dialog has a new tab now: "Bulk table editor". What is bulk editing?
* Move all tables of one or more databases to another database
* Change default collation of these tables
* Change table engine
* Convert data to a different charset
* Reset auto_increment value

See it in action:

Happy Holidays!

Black Friday is back. We are happy to offer a 50% flat discount on all Webyog products. Yes, you read it right, fifty percent flat discount. Hurry up, this offer is valid only till 1st Dec 09, 23:59 PST.

Still using SQLyog Community Edition? Held off buying SQLyog Enterprise Edition? This offer is literally too good to pass up. Its time to own your copy of SQLyog Enterprise with all the PowerTools. Check out what Enterprise Edition has to offer.

Worried about your MySQL server’s health? Monitor it like a PRO. Get MONyog – MySQL Monitor & Advisor. Your MySQL DBA in a box! Check what it has to offer.

Want to extend your maintenance period? Don’t think twice, head right away to …

The old "Export as SQL" dialog is gone. Functionality was moved to the table tools dialog which has one tab per tool (maintenance, find in db, export SQL). Most features are still alive, only the target version drop down was found to be more confusing then helpful to me so I left it out for now.

Apart from the GUI changes, I rewrote the whole bunch of code which loops through your table rows and creates INSERTs. Probably you have noticed the old dialog was very slow when it came to export large tables. Not so the new dialog - it is nearly as fast as mysqldump does an export!

I have a 23M table with 1,1 Mio rows, used for testing purposes:
* Old HeidiSQL export took ~1 minute
* New dialog: 10 seconds
* mysqldump: 4 seconds
Another 5M table with 40,000 rows:
* Old dialog: 22 seconds
* New: 1 second
* mysqldump: 1 second

The problem with the old dialog was …

So you’ve finally caught on with the hype, and you’re seriously considering using Amazon RDS for your database needs. Here are ten things you ought to know before you take the leap:

10. Amazon RDS uses a patched version of MySQL 5.1.38. While several discussions within MySQL forums allude to a growing concern that Amazon may not have the required expertise for upgrading and maintaining patched versions of MySQL, the fact still remains that Amazon has enough resources to just buy them from other vendors who do. The patch enables MySQL to scale dynamically in the cloud, besides adding other features.

9. EC2, EBS, and RDS: Connecting the dots. Amazon RDS DB instances are basically instances of MySQL running on an EC2 platform. Persistent storage (for back-ups, etc.) is allocated in EBS volumes. However, neither can you access the underlying EC2 instance nor can you use S3 to access your stored …

On the eve of Microsoft’s announcement of the public release of SQL Azure Database, Amazon decides to release RDS. And that, too, after having resisted users’ demands for a relational database service for a very long time. Preemptive action, perhaps? Whatever it may be, I believe that such a healthy competition can do much good to the Cloud marketplace.

RDS brings with it the promise of MySQL on a Cloud. Having been a MySQL fan for quite some time now, I was itching to get my hands on an AWS account and check out what the hype was all about. Imagine my confusion when I signed up for Amazon RDS and all the AWS Management Console showed me was the EC2 dashboard! It was time I downloaded the Getting Started Guide and went through the rigmarole of studying it.

Setting up the Command Line Interface Tools

Apparently, there is no GUI yet for RDS. The only way to go about using it is through the CLI tools. Setting up the tools, …

The sources are available all time - though not per ZIP download between the releases - but via Subversion repository:

* Browse through files: http://code.google.com/p/heidisql/source/browse/#svn/trunk
* Check out with a client like TortoiseSVN: http://code.google.com/p/heidisql/source/checkout

The database layer is located here:
* http://code.google.com/p/heidisql/source/browse/trunk/source/mysql_connection.pas
* …

HeidiSQL now uses a more lightweight database layer to access MySQL servers. This completely new written layer consists of just two units and replaces the big ZeosDBO package - which worked well over the years, but I felt that here and there developping new features regarding the libmysql API was a pain.

Unfortunately there is nothing to show you here, no screenshot available, but in fact that was one of the most critical change over the last year.

* The UPX compressed executable's size has decreased from 1,1M to 900K.
* Should also result in better performance in some cases.

Didn't take too much notice of our download numbers recently, so I saw a nice number today: ~130,000 downloads of the 4.0 release.

Together with
* 230,000 downloads of HeidiSQL 3.2
* 90,000 downloads of source packages, portable and various older releases
* 50,000 downloads from pre-Google-Code times for which I don't have statistics

... we have 500,000 downloads total!

More statistics:
* Average size of one downloaded file is ~2MB
* HeidiSQL development started ~3 years ago in late 2006 (ignoring old MF2.5 times)
* Makes ~900 MB / ~450 files of downloads each day

A big thank to all and each user out there!

Recently we have released Workbench 5.2.4 Alpha. This version has some new features, and amongst them there is Workbench Administrator plugin or WBA plugin for short.

The plugin aims to ease the managing process of server instances. What we offer with WBA is a simple way to check status, configure and control one server instance. Some parts will resemble discontinued MySQL Administrator.

And here is a short summary of what we will have in WBA:

• Start/Stop server
• Edit server configuration (my.cnf)
• Manage user accounts
• Monitor user connections
• Status/Server variables browsing
• Log browsing
• Dump/Restore

In this alpha we have implemented a subset, which targets local usage only. Remote management and administration is upcoming. The subset includes:

• Add new Server Profiles
• Start/Stop the Server
…