SQLyog: Difference between revisions

Revision as of 12:19, 24 July 2019

Latest revision as of 03:28, 20 July 2025

(7 intermediate revisions by 7 users not shown)

Line 17:

| website = http://webyog.com

}}

'''SQLyog''' is a [[Graphical user interface|GUI]] tool for the [[RDBMS]] [[MySQL]]. It is developed by Webyog, Inc., based in [[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.<ref>{{Cite web|url=https://www.webyog.com/webyog/aboutUs|title=Webyog {{!}} Manage, Monitor and Secure Your MySQL Servers|website=www.webyog.com|access-date=2019-11-20}}</ref>

==History==

Line 27:

Prominent features<ref>{{cite web| publisher=Webyog | accessdate=3 December 2014|title=Comprehensive Feature List|url=https://www.webyog.com/product/sqlyogFeatureListExpanded/}}</ref> of SQLyog are:

* 64-bit binaries are available from version 11.0.<ref>{{cite web | publisher=Webyog | accessdate=3 December 2014 | title=MySQL GUI in 64 bit | url=http://blog.webyog.com/2013/02/13/sqlyog-11-ga-your-favorite-mysql-gui-in-64-bit-avatar/ | archive-url=https://web.archive.org/web/20130221125801/http://blog.webyog.com/2013/02/13/sqlyog-11-ga-your-favorite-mysql-gui-in-64-bit-avatar/ | dead-url-status=yesdead | archive-date=21 February 2013 }}</ref>

* Editor with [[syntax highlighting]] and various automatic formatting options

* Intelligent Code Completion

Line 42:

* All automated jobs have mail alerting and reporting options.

* Full character set/[[Unicode]] support

* A "Data Search"<ref>{{cite web|publisher=Webyog|accessdate=3 December 2014|title=MySQL Data Search|url=http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/|archive-url=https://web.archive.org/web/20110612203002/http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/|dead-url-status=yesdead|archive-date=12 June 2011}}</ref> feature using a Google-type search syntax translated transparently for user to SQL.

* Form view<ref>{{cite web|publisher=Webyog|accessdate=3 December 2014|title=Form View|url=http://www.webyog.com/blog/2010/11/19/sqlyog-mysql-gui-8-7-released-form-view-improved-sql-formatter-and-more/|archive-url=https://web.archive.org/web/20101122075741/http://www.webyog.com/blog/2010/11/19/sqlyog-mysql-gui-8-7-released-form-view-improved-sql-formatter-and-more/|dead-url-status=yesdead|archive-date=22 November 2010}}</ref> to display one row at a time

* Foreign key lookup

* Visual Data Compare<ref>{{cite web | publisher=Webyog | accessdate=3 December 2014 | title=Visual Data Compare | url=http://blog.webyog.com/2012/12/11/visually-compare-mysql-data-and-sync-the-differences/ | archive-url=https://web.archive.org/web/20121215072602/http://blog.webyog.com/2012/12/11/visually-compare-mysql-data-and-sync-the-differences/ | dead-url-status=yesdead | archive-date=15 December 2012 }}</ref>

==Technical Specificationspecification==

* Programmed and developed in [[C++]] using Win32 [[Application programming interface|API]]. No dependencies on runtimes ([[.NET Framework|.NET]], [[Java (software platform)|Java]] etc.).

* Uses [[MySQL]] C API to communicate with MySQL servers. No dependencies on [[database abstraction layer]]s (like [[ODBC]]/[[JDBC]]).

* Uses [[SQLite]] to store internal data like Grid settings. Consequently, these settings are persistent across sessions on a per-table basis.

Line 55:

==Platforms==

SQLyog works on the [[Microsoft Windows|Windows]] platform ranging from [[Windows Vista]]<ref>{{Cite web|url=http://faq.webyog.com/category/31/installation-and-configuration.html|title=SQLyog MySQL Admin FAQ - Installation and Configuration|website=faq.webyog.com|access-date=2019-11-20}}</ref> to [[Windows 10]]. (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]] and various Unixes (including [[macOS]]) using the [[Wine (software)|Wine]] environment.<ref>{{cite web| publisher=Webyog | accessdate=3 December 2014|title=SQLyog on Wine|url=http://www.webyog.com/faq/5_71_en.html|archive-date=18 March 2012|archive-url=https://web.archive.org/web/20120318085314/http://www.webyog.com/faq/5_71_en.html|url-status=dead}}</ref> 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.<ref>{{Cite web|url=https://sqlyogkb.webyog.com/article/6-version-history-2017|title=Version History - 2017 - SQLyog Knowledge Base|website=sqlyogkb.webyog.com|access-date=2019-11-20}}</ref>

== Support ==

Webyog provides priority support to customers primarily through a ticket based support system.<ref>{{cite web|publisher=Webyog|accessdate=3 December 2014|title=Contact options|url=http://www.webyog.com/en/contact_us.php|deadurlurl-status=yesdead|archiveurl=https://web.archive.org/web/20110831012415/http://www.webyog.com/en/contact_us.php|archivedate=31 August 2011|df=}}</ref> Users of Community Edition can get support through [http://www.webyog.com/forums Webyog Forums] which has more than 15000 registered users. Webyog also maintains an extensive FAQ<ref>{{cite web| publisher=Webyog | accessdate=3 December 2014|title=FAQ|url=http://faq.webyog.com/}}</ref> for most commonly asked questions.

==See also==

Line 69:

== External links ==

* [https://www.webyog.com/ Official Webyog home page]

* [httphttps://code.googlegithub.com/pwebyog/sqlyog/-community Community Edition project page]

* [https://www.webyog.com/product/sqlyogFeatureListExpanded/ Comparison Sheet between Community and commercial editions]

* [https://www.webyog.com/webyog/sqlyogScreenShots/?ref=2 SQLyog Screenshots]

* [https://wwwweb.webcitationarchive.org/65jYlfbl9?url=web/20120229041015/http://dev.mysql.com/tech-resources/interviews/rohit-nadhani-webyog.html Interview with Rohit Nadhani, ''MySQL AB'', August 23rd, 2006]

{{MySQL}}

{{DEFAULTSORT:Sqlyog}}