SQLyog is a

GUI The GUI ( "UI" by itself is still usually pronounced . or ), graphical user interface, is a form of user interface that allows users to interact with electronic devices through graphical icons and audio indicator such as primary notation, inste ...

tool for the

RDBMS A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...

. It is developed by Webyog, Inc., based in

Bangalore, India Bangalore (), officially Bengaluru (), is the capital and largest city of the Indian state of Karnataka. It has a population of more than and a metropolitan population of around , making it the third most populous city and fifth most ...

, and

Santa Clara, California Santa Clara (; Spanish for " Saint Clare") is a city in Santa Clara County, California. The city's population was 127,647 at the 2020 census, making it the eighth-most populous city in the Bay Area. Located in the southern Bay Area, the cit ...

. 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 after eight months of development. SQLyog was available free of charge, but with closed source code, until v3.0 when it was made a fully commercial software. Nowadays SQLyog is distributed both as

free software Free software or libre software is computer software distributed under terms that allow users to run the software for any purpose as well as to study, change, and distribute it and any adapted versions. Free software is a matter of liberty, n ...

as well as several paid, proprietary, versions. The free software version is known as Community Edition at

GitHub GitHub, Inc. () is an Internet hosting service for software development and version control using Git. It provides the distributed version control of Git plus access control, bug tracking, software feature requests, task management, cont ...

. Paid versions are sold as Professional, Enterprise and Ultimate Editions.

Features

Prominent features of SQLyog are: * 64-bit binaries are available from version 11.0. * Editor with

syntax highlighting Syntax highlighting is a feature of text editors that are used for programming, scripting, or markup languages, such as HTML. The feature displays text, especially source code, in different colours and fonts according to the category of terms ...

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

API (

SSL SSL may refer to: Entertainment * RoboCup Small Size League, robotics football competition * ''Sesame Street Live'', a touring version of the children's television show * StarCraft II StarLeague, a Korean league in the video game Natural language ...

supported),

HTTP The Hypertext Transfer Protocol (HTTP) is an application layer protocol in the Internet protocol suite model for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide We ...

HTTPS Hypertext Transfer Protocol Secure (HTTPS) is an extension of the Hypertext Transfer Protocol (HTTP). It is used for secure communication over a computer network, and is widely used on the Internet. In HTTPS, the communication protocol is enc ...

tunneling, SSH tunneling * Wizard-driven tool for import of data from

ODBC In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...

-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 The HyperText Markup Language or HTML is the standard markup language for documents designed to be displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets (CSS) and scripting languages such as JavaS ...

-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 Unicode, formally The Unicode Standard,The formal version reference is is an information technology standard for the consistent encoding, representation, and handling of text expressed in most of the world's writing systems. The standard, ...

support * A "Data Search" feature using a Google-type search syntax translated transparently for user to SQL. * Form view to display one row at a time * Foreign key lookup * Visual Data Compare

Technical Specification

* Programmed and developed in C++ using Win32 API. No dependencies on runtimes ( .NET,

Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's mo ...

etc.). * Uses

C API to communicate with MySQL servers. No dependencies on

database abstraction layer A database abstraction layer (DBAL or DAL) is an application programming interface which unifies the communication between a computer application and databases such as SQL Server, IBM Db2, MySQL, PostgreSQL, Oracle or SQLite. Traditionally, all da ...

s (like

JDBC Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. I ...

). * Uses

SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the mo ...

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 Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for se ...

platform ranging from

Windows Vista Windows Vista is a major release of the Windows NT operating system developed by Microsoft. It was the direct successor to Windows XP, which was released five years before, at the time being the longest time span between successive releases of ...

Windows 10 Windows 10 is a major release of Microsoft's Windows NT operating system. It is the direct successor to Windows 8.1, which was released nearly two years earlier. It was released to manufacturing on July 15, 2015, and later to retail on ...

. (Windows 9x/ME support was removed in version 5.0, Windows 2000 support stopped with version 8.6, and Windows XP support ended with version 12.5.) It has also been made to work under

Linux Linux ( or ) is a family of open-source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically packaged as a Linux distribution, whi ...

and various Unixes (including

macOS macOS (; previously OS X and originally Mac OS X) is a Unix operating system developed and marketed by Apple Inc. since 2001. It is the primary operating system for Apple's Mac computers. Within the market of desktop and la ...

) using the

Wine Wine is an alcoholic drink typically made from Fermentation in winemaking, fermented grapes. Yeast in winemaking, Yeast consumes the sugar in the grapes and converts it to ethanol and carbon dioxide, releasing heat in the process. Different ...

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 throug
Webyog Forums
which has more than 15000 registered users. Webyog also maintains an extensive FAQ for most commonly asked questions.

References

External links

Official Webyog home page

Community Edition project page

Comparison Sheet between Community and commercial editions

SQLyog Screenshots

{{DEFAULTSORT:Sqlyog Database administration tools