SQLyog

This is an old revision of this page, as edited by 114.31.25.2 (talk) at 10:58, 13 October 2008 (Technical Specification). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQLyog 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 Softworks Pvt. Ltd.
Stable release
Written inC++
Operating systemMicrosoft Windows
Size8MB
Available inEnglish
TypeRDBMS
LicenseGPL
Websitewebyog.com

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.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 (August 2008)

Current version of SQLyog Enterprise is 7.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 [1]
  • 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 jhjhj

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 registered users. Core SQLyog developers also respond to queries asked in the forums.

Webyog also maintains an extensive FAQ for most commonly asked questions.

References