SQLyog: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 04:48, 3 May 2007 edit 61.95.199.19 (talk) →Features ← Previous edit		Latest revision as of 03:28, 20 July 2025 edit undo InternetArchiveBot (talk \| contribs) Bots, Pending changes reviewers 5,696,269 edits Rescuing 1 sources and tagging 0 as dead.) #IABot (v2.0.9.5
(236 intermediate revisions by more than 100 users not shown)
Line 1: {{Third-party\|date=December 2014}} ~~{{Infobox_Software~~ {{Infobox software \| name = SQLyog ~~\|logo = [[Image:Sc_sqlyog.gif\|250px]]~~ \| logo = ~~\|caption =~~ \| screenshot = \|developer = Webyog▼ ~~\|latest_stable_version = 5.29~~ \| caption = MySQL GUI ~~\|latest_beta_version = 6.0~~ ▲\| developer = Webyog, Inc. ~~\|operating_system = [[Windows]]~~ \| latest release version = {{SQLyog version}} ~~\|genre = [[Relational database management system\|RDBMS]]~~ \| latest release date = {{SQLyog version\|releasedate}} \|website = [http://webyog.com/en/]▼ \| programming language = [[C++]] \| operating system = [[Microsoft Windows]] \| size = 11.0MB \| language = English ~~[[Category:~~\| genre = Database administration tools]]▼ \| license = Proprietary, GPL (Community Edition) ▲\| website = [http://webyog.com~~/en/]~~ }} '''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> '''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 [http://webyog.com/en/about_webyog.php Webyog], based in [[Bangalore]]. ~~__TOC__~~ ==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]] as well as several paid, proprietary, versions. The free software version is known as '''Community Edition'''<ref>{{cite web\| publisher=Webyog / Github \| accessdate=20 June 2016\|title=SQLyog Community Edition on Github\|url=https://github.com/webyog/sqlyog-community}}</ref> at [[GitHub]]. Paid versions are sold as '''Professional''', '''Enterprise''' and '''Ultimate Editions'''.<ref>{{cite web\| publisher=Webyog \| accessdate=3 December 2014\|title=Online Shop\|url=https://www.webyog.com/shop}}</ref> SQLyog was started as a undergraduate college project by [http://www.riteshn.com 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.<ref>[http://dev.mysql.com/tech-resources/interviews/rohit-nadhani-webyog.html Interview with Rohit Nadhani], ''MySQL AB'', August 23rd, 2006</ref> ~~After 8 months of development v0.9 was released for public as a closed source free software. SQLyog was a free software uptil 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<ref>{{cite web\| publisher=Webyog \| accessdate=3 December 2014\|title=Comprehensive Feature List\|url=https://www.webyog.com/product/sqlyogFeatureListExpanded/}}</ref> of SQLyog are: ~~Prominent features 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/ \| url-status=dead \| archive-date=21 February 2013 }}</ref> * Query Builder (available in the BETA version) * Editor with [[syntax highlighting]] and various automatic formatting options * Smart Autocomplete * 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. * HTTP/HTTPs Tunneling * Visual Schema Designer * SSH Tunneling * Visual Query Builder * SSL Connections * Query Formatter * Wizard driven Migration Tool * Connectivity options: Direct client/server using [[MySQL]] [[Application programming interface\|API]] ([[Transport Layer Security\|SSL]] supported), [[Hypertext Transfer Protocol\|HTTP]]/[[HTTPS]] tunneling, [[Secure Shell\|SSH]] tunneling * Data/Structure Synchronization <ref>[http://webyog.com/en/sqlyog_feature_matrix.php Complete Feature List], ''Webyog''</ref> * Wizard-driven tool for import of data from [[ODBC]]-databases * Fully unicode support. * 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"<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/\|url-status=dead\|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/\|url-status=dead\|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/ \| url-status=dead \| archive-date=15 December 2012 }}</ref> ===Technical ~~Specification=~~specification==▼ ~~==Program specifications==~~ * Programmed and developed in [[C++]] using Win32 [[Application programming interface\|API]]. No dependencies on runtimes ([[.NET Framework\|.NET]], [[Java (software platform)\|Java]] etc.). ▲===Technical Specification=== * 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. ===Platforms===▼ * Developed using Win32 API * Uses MySQL C API to communicate with MySQL servers * Uses [[Sqlite]] to store all internal data 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> ▲===Platforms=== ~~SQLyog works on the [[Windows]] platform starting from [[Windows 95]] to [[Windows Vista]]. It has also been able to work under [[Linux]] using [[WINE]] environment.~~ == Support == Webyog provides priority support to ~~Enterprise~~ customers primarily through ~~their~~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\|url-status=dead\|archiveurl=https://web.archive.org/web/20110831012415/http://www.webyog.com/en/contact_us.php\|archivedate=31 August 2011}}</ref> Users of ~~community~~Community ~~edition~~Edition can get support through [http://www.webyog.com/forums Webyog Forums] which has more ~~then~~than ~~5000~~15000 ~~active~~registered users. ~~Core~~Webyog ~~SQLyog~~also ~~developers~~maintains ~~also~~an ~~respond~~extensive toFAQ<ref>{{cite ~~queries~~web\| ~~asked~~publisher=Webyog in\| ~~the~~accessdate=3 ~~forums~~December 2014\|title=FAQ\|url=http://faq.webyog.com/}}</ref> for most commonly asked questions. ==See also== ~~Webyog also maintains an extensive [http://www.webyog.com/faq FAQ] for most commonly asked questions.~~ * [[Comparison of database tools]] == References == {{Reflist}} ~~<references />~~ == External links == * [~~http~~https://www.webyog.com~~/en~~/ ~~Offical~~Official Webyog home page] ~~Official Webyog home page.~~ * [~~http~~https://~~webyog~~github.com/enwebyog/~~sqlyog_feature_matrix.php Comparison Sheet between~~sqlyog-community Community ~~and~~Edition ~~Enterprise~~project ~~Edition~~page] * [https://www.webyog.com/product/sqlyogFeatureListExpanded/ Comparison Sheet between Community and commercial editions] * [~~http~~https://www.webyog.com/enwebyog/~~screenshots.php~~sqlyogScreenShots/?ref=2 SQLyog Screenshots] * [https://web.archive.org/web/20120229041015/http://dev.mysql.com/tech-resources/interviews/rohit-nadhani-webyog.html Interview with Rohit Nadhani, ''MySQL AB'', August 23rd, 2006] {{MySQL}} ~~[[Category:Graphical user interface]]~~ ▲[[Category:Database administration tools]] {{DEFAULTSORT:Sqlyog}} ~~[[pt:SQLyog]]~~ [[Category:Database administration tools]]