One of most loved feature of SQLyog is the snappy and responsive user interface. Many of our users and customers prefer SQLyog over other tools because of this particular reason.

One reason for the zippy interface could be that SQLyog is entirely developed in C/C++, which tends to be faster than other languages when it comes to raw speed. I don’t want to start a flame war here, but our customers seem to like this fact. Using C/C++ allows us to use the native MySQL C client libraries that gives the best performance as compared to other ways of communicating with MySQL. Using C/C++ also ensures that there are no external dependencies on any bulky frameworks and the download file is relatively small.

Although using a language that complies directly to machine instructions helps a lot, but true speed comes from better algorithms. A similar analogy in the MySQL context would be that you might get some benefits from tuning your …

At the MySQL Conference, I had the chance to interview Rohit Nadhani, founder of Webyog, the folk that make SQLyog and MONyog. Watch the video, for more.

Generally based out of Bangalore (I visited them when I was last there), Webyog just started an office in Santa Clara, and are expanding. They boast 15,000 paid customers so far, with some big name customers: Google, Yahoo!, executive office to the US president, and more.

SQLyog is termed as an upgrade from phpMyAdmin. There is a GPL community edition, with some “power tools” that is part of the Enterprise Edition. It is very Win32 based, but easy enough to run on other OSes via WINE or some sort of virtualisation tool.

MONyog is an agentless monitoring tool. It …

Changes (as compared to 8.03) include:

Features:
* Crash dumps with no information (zero-size) will now be deleted automatically.
* When saving/copying from the editor the LETTERCASE modfications for keywords and functions will now be preserved.
* Selecting a ‘child’ object for a table (columns and indexes) will now refresh the DATA tab if DATA tab is open. Before only selecting the table object itself did. Also the table information is now available in OBJECTS tab when a column or index is selected.
* Now also a ‘key’ icon is used for identifying the Primary Key in an Object Browser ‘Indexes’ folder,
* When a GRID cell is only partly visible, doubleclicking it will move the grid position so that cell/row will become visible (before it worked like that with singleclick - we changed to doubleclick as this is a de facto standard in such grids - in Excel for …

Changes (as compared to 8.01) include:

Features:
* Both SQLyog and SJA will now detect if Base64 encoding is required for HTTP-tunnel.

Funtionality changed:
*  CHUNK setting  (for exports)  now also has effect for non-HTTP-tunneled connections.  Using this option is required if it takes more time to retrieve data from a table than server ‘net_write_timeout’ setting.
*  SQLyog will now not reconnect if connection is lost during imports.  Instead an error message will prompt (the reason for this is that session variables defined on top of the script  would be reset to server defaults with reconnection.  As a result (and most important) special characters could garble and other errors could occur as well)..
* When trying to INSERT or UPDATE spatial data types from the DATA/RESULT tab SQLyog will now throw an error. …

Hi,

SQLyog 8.0 is a major new version of SQLyog introducing major features like Query Profiler, SQL Formatter and vastly improved look and feel.

Query Profiler:

MySQL has always lacked the sophisticated profiling tools shipped with proprietary databases like SQL Server, etc. MySQL developers have largely depended on EXPLAIN for tuning queries. The SHOW PROFILE patch by Jeremy Cole was introduced in the MySQL Community version 5.0.37 and it provided much more insight into where the query spends its time. However, to take advantage of this feature, MySQL developers were supposed to switch on profiling, run their queries and then filter the profiling data from a table that contained the profiling results of the last few profiled queries. A lot of manual book-keeping is required to take advantage of …

Changes (as compared to 7.14) include:

Features:
* Added an option to use Base64 encoding for communicating XML data stream with the HTTP tunneller. Using this option can be required to work around this XML-related bug in PHP.
* Improved editor performance with large scripts if Wordwrap was enabled.

Bug fixes:
* On Windows Vista Business edition, SQLyog could crash while closing down. No other Windows OS (and also not any other Vista edition) was affected.
*  Also a ‘hang’ could occur when closing down. It could happen with all systems, but Windows Vista was mostly affected.
* Schema Sync failed with identically named Foreign Key CONSTRAINTs on identically named colums of basically same type (that could still differ in LENGTH, SIGNED/UNSIGNED specification etc.)

Introduction

If you are hosting your website with Yahoo Small Business Hosting, you will be forced to use a web based admin tool to manage your MySQL database. In fact, the help page on managing MySQL categorically mentions that “You will not be able to access your database using a desktop client or other tools run outside of Yahoo!”(I bet they don’t read our blog). In this article, I will show you how you can use all the cool and powerful features of SQLyog Enterprise with Yahoo Small Business Hosting. The same concepts can be applied to connect to other hosting providers like Godaddy, Network Solutions etc. which don’t provide direct access to MySQL database.

Step by Step Setup Guide

1. Login to your Yahoo web-hosting and you will land in home page of “Web Hosting Control …

Changes (as compared to 7.02) include:

Features:
* Added keyboard shortcut (F6) for Edit Index.
* The behaviour of Ctrl+R shortcut was slightly changed. It will now position cursor inside the active tab in Result pane. Before it was functional only with DATA tab and RESULT tabs.
* Added tab-navigation (for query tabs) entries in Edit-menu. Also the active Query tab can now be closed from menu.
* In certain situations Schema Sync would generate CHANGE-clauses for a column that basically did nothing (changing column to what it was). This is now ‘cleaned up’.
* A tab in the Query pane (a Query tab, a Schema Designer tab and a Query Builder tab) can now be closed with Alt+L keyboard shortcut and can now be navigated with Ctrl+pgup and Ctrl+pgdn keyboard shortcuts.
* Favorites are now displayed using Scintilla editor component. For statements with complex formatting this …

Changes (as compared to version 7.0) include:

Bug fix:
* When SQLyog tried to reconnect while exporting a crash could occur. This bug was introduced in 7.0 with the speed optimization of the export dialogue.

Also SJA for Linux was updated with a fix for a (non-related) issue: Since version 6.5 SJA for Linux would not run on Pentium 3 processors (a ‘illegal instruction’ error was returned).  This is now fixed with this generic build.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Changes as compared to version 6.56 include:

Features:

* New GRID design (’zebra’ Office 2007 style) for easier navigation.
* Multiple selection in GRIDs with SHIFT+CLICK.
* Improved Data Synchronization. Now typically 2-8 times faster than before depending on data. Option to generate a SQL sync script was added.
*  Drastically improved the speed of exports.
* New more user friendly design for the Schema Synchronisation (renamed from Structure Synchonisation). Various filter (’hide and ignore’) options were added. Also a long-running Schema Sync compare task can now be stopped.
*  Added automatic and manual update check.

Bug fixes:

* A backup script backing up all databases could fail to restore VIEWs referencing another database than the one where the VIEW was.
* Around 50 other small (mostly GUI-related) …