Jump to content

SQLyog

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Filedelinkerbot (talk | contribs) at 12:41, 8 December 2014 (Bot: Removing Commons:File:Sqlyog.png (en). It was deleted on Commons by Yann (Per Commons:Commons:Deletion requests/File:Sqlyog.png).). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQLyog
Developer(s)Webyog, Inc.
Stable release
12.02[1] / October 23, 2014 (2014-10-23)
Written inC++
Operating systemMicrosoft Windows
Size11.0MB
Available inEnglish
TypeDatabase administration tools
LicenseProprietary, GPL (Community Edition)
Websitehttp://webyog.com

SQLyog is a GUI tool for the RDBMS MySQL. It is developed by Webyog, Inc. based out of Bangalore, India and Santa Clara, California. SQLyog is being used by more than 30,000 customers worldwide and has been downloaded more than 2,000,000 times.

History

SQLyog v0.9 was first released to the public in 2001 as closed source free software after eight months of development. SQLyog was freely available until v3.0 when it was made commercial software. SQLyog is available in free as well as paid versions. The free version is known as Community Edition and is available as an open source project[2] at Google Code. Paid versions are sold as Professional, Enterprise and Ultimate Editions.[3]

Features

Prominent features[4] of SQLyog are:

  • 64 bit binaries are available from version 11.0.[5]
  • 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.
  • 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.
  • 'SQL Scheduler and Reporting Tool' - a tool for scheduling and automating execution of any sequence of SQL statements. Result of queries may be sent as HTML-formatted reports.
  • Schema/Structure Synchronization and Data Synchronization.
  • Query Profiler and Redundant Index Finder.
  • All automated jobs have mail alerting and reporting options.
  • Full character set/Unicode support.
  • A 'Data Search'[6] feature using a Google-type search syntax translated transparently for user to SQL.
  • Form view[7] to display one row at a time - a great way to enter/edit data.
  • Foreign key lookup.
  • Visual Data Compare.[8]

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 Windows 8/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.[9] 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.[10] Users of Community Edition can get support through Webyog Forums which has more than 15000 registered users. Webyog also maintains an extensive FAQ[11] for most commonly asked questions.

See also

References

  1. ^ "SQLyog MySQL GUI 12.02 Released". Webyog. Retrieved 7 November 2014.
  2. ^ "SQLyog Community Edition on Google Code". Webyog / Google Code. Retrieved 3 December 2014.
  3. ^ "Online Shop". Webyog. Retrieved 3 December 2014.
  4. ^ "Comprehensive Feature List". Webyog. Retrieved 3 December 2014.
  5. ^ "MySQL GUI in 64 bit". Webyog. Retrieved 3 December 2014.
  6. ^ "MySQL Data Search". Webyog. Retrieved 3 December 2014.
  7. ^ "Form View". Webyog. Retrieved 3 December 2014.
  8. ^ "Visual Data Compare". Webyog. Retrieved 3 December 2014.
  9. ^ "SQLyog on Wine". Webyog. Retrieved 3 December 2014.
  10. ^ "Contact options". Webyog. Retrieved 3 December 2014.
  11. ^ "FAQ". Webyog. Retrieved 3 December 2014.