SQLyog for MySQL is a Graphical User Interface (GUI) tool for the popular Relational Database Management System (RDBMS) MySQL. The software is created by the software development company Webyog, based in Bangalore, India.
| SQLyog | |
|---|---|
| Developer(s) | Webyog |
| Operating system | Windows |
| Type | RDBMS |
| Website | webyog.com/en/ |
SQLyog is popular for its ease of use yet its immense power. SQLyog provides a very intuitive interface to develop MySQL scripts effectively.
History
SQLyog was started by Ritesh Nadhani in the year 2001. For 2 years, it was developed by him with technical and project management input given by his elder brother Rohit. Rohit later on joined the development team as a full time contributor.[1]
SQLyog v0.9 was first released for public 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.0, SQLyog is now available in two editions: Enterprise and Free Community Edition.
From version 5.2 Community Edition has been available as Open Source (GPL license)
Current Version (March 2008)
Current version of SQLyog Enterprise is 6.x.
Features
Prominent features of SQLyog are:
- Visual Schema Designer
- Visual Query Builder
- Smart Autocomplete
- Intelligent Code Completion
- HTTP/HTTPs Tunneling
- SSH Tunneling
- SSL Connections
- Wizard driven Migration Tool
- Data/Structure Synchronization [2]
- Fully unicode support.
Program specifications
Technical Specification
- Developed using Win32 API
- Uses MySQL C API to communicate with MySQL servers
- Uses Sqlite to store all internal data
Platforms
SQLyog works on the Windows platform starting from Windows 2000 to Windows Vista/Server 2008 (Windows 9x/ME/NT4 support was removed in version 5.0 because of lack of unicode support in those early Windows versions). It has also been made to work under Linux and various Unix's (including Mac OS-X) using WINE environment. Further a subset of SQLyog Enterprise 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 Enterprise customers through their ticket based support system. Users of community edition can get support through Webyog Forums which has more than 5000 active users. Core SQLyog developers also respond to queries asked in the forums.
Webyog also maintains an extensive FAQ for most commonly asked questions.
References
- ^ Interview with Rohit Nadhani, MySQL AB, August 23rd, 2006
- ^ Complete Feature List, Webyog
External links
- Official Webyog home page Official Webyog home page.
- MONyog - Monitoring and Advisory Tool for MySQL MySQL Monitoring and Advisory Tool from Webyog
- Comparison Sheet between Community and Enterprise Edition
- Screenshots
- Managing Foreign Key Relationships
- Synchronize MySQL Data Using SQLyog Job Agent
- Community Edition project page