History
SQLyog v0.9 was first released for public in the year 2001 as a closed source free software after 8 months of development. SQLyog was a free software until v3.0 when it was made a commercial software.
Starting from v5.2 SQLyog has been available as a (Propreitary) Non Community Edition. Commercial editions are named Professional, Enterprise and Ultimate.
Current Version (July 2010)
Current version of SQLyog Enterprise is 8.x.
Features
Prominent features of SQLyog are:
Tabbed interface for connections. Connections can be given a color for identification.
Editor with syntax highlighting and various automatic formatting options.
Intelligent Code Completion.
Data manipulations (INSERT, UPDATE, DELETE) may be done from a spreadsheet-like interface. Both raw table data and a result set from a query can be manipulated.
Rich context menus etc. for performing common tasks without writing SQL.
Visual Schema Designer.
Visual Query Builder.
Query Formatter.
Connectivity options: Direct client/server using MySQL API (SSL supported), HTTP/HTTPs Tunneling, SSH Tunneling.
Wizard driven Tool for import of data from ODBC-databases
Backup Tool for performing unattended backups. Backups may be compressed and optionally stored as a file-per-table as well as identified with a timestamp.
'Notifications Service' - a tool for scheduling and automating execution of any sequence of SQL statements.
Schema/Structure and Data Synchronization.
Query Profiler and Redundant Index Finder.
All automated jobs have mail alerting and reporting options.
Full character set/unicode support.
Optionally portable. All files used by SQLyog may be saved to a removable drive etc.
Technical Specification
Programmed and developed in C++ using Win32 API. No dependencies on runtimes (.NET, Java etc.).
Uses MySQL C API to communicate with MySQL servers. No dependencies on 'database abstraction layers' (like ODBC/JDBC).
Uses Sqlite to store internal data like Grid settings. Consequently these settings are persistent across sessions on a per-table basis.
Platforms
SQLyog works on the Windows platform starting from Windows XP/Windows 2003 to Windows7/Server 2008(r2) (Windows 9x/ME support was removed in version 5.0 primarily because of lack of unicode support in those early Windows versions and Windows 2000 support stopped with version 8.6). It has also been made to work under Linux and various Unix's (including Mac OS X) using the Wine environment. Further a subset of SQLyog Enterprise/Ultimate functionalities are available with the free SJA (SQLyog Job Agent) for Linux as a native Linux utility. This makes it possible to specify and test 'scheduled jobs' on a Windows environment and port execution parameters seamlessly to a Linux environment.
Support
Webyog provides priority support to customers primarily through a ticket based support system. Users of Community edition can get support through Webyog Forums which has more than 7000 registered users. Webyog also maintains an extensive FAQ for most commonly asked questions.
|