I first came across SQLyog when I found myself frustrated by the web-based MySQL management package that I was using at the time. I saw SQLyog mentioned in a blog and thought it had to be worth taking a look at so I downloaded the demonstration version available at the time: it was around 2005.
I was extremely impressed by the software and recommended it to my employer. The software was duly purchased and employed in the management of eight servers at their data centre in the Dockland, London. The company had major changes on the horizon though and I, along with most of the rest of the developers, were made redundant a few years later.
Not to be outdone, I purchased my personal copy of SQLyog Ultimate in 2008 because I could see the value in the tool for my own developments. I only have a single server, but I occasionally create ‘virtual’ machines containing servers for testing purposes. SQLyog is a happy with a connection to the localhost, the remote server over SSH, or a virtual server – it just does the job without any hassle.
My favourite features have to be the redundant index analyser, for when other people send databases to me, and the SQL formatter, for when I dump a load of auto-generated SQL out of a module I’m writing.
Thank you Webyog for these marvellous tools – they save me hours of hard slog… and stop premature balding I’m sure!