SQLyog is a Graphical User Interface (GUI) for the popular Relational Database Management System (RDBMS) MySQL. The software is created by the software development company Webyog, based in Bangalore.
| SQLyog | |
|---|---|
| Developer(s) | Webyog |
| Operating system | Windows |
| Type | RDBMS |
| Website | webyog.com/en/ |
History
SQLyog was started as a undergraduate college project by Ritesh Nadhani when he had to use MySQL for one of his required course project in 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]
After 8 months of development v0.9 was released for public as a closed source free software. SQLyog was a free software up 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.
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 98 to Windows Vista. It has also been made to work under Linux using WINE 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
- SQLyog Screenshots
- Managing Foreign Key Relationships - Accessed on 2007-09-09