MySQL Workbench

Last updated

MySQL Workbench
Developer(s) Oracle Corporation
Stable release
8.0.38 / 2024-07-01
Repository https://github.com/mysql/mysql-workbench
Written in C++, C, Python
Operating system Windows, OS X and Linux [1]
License
Website www.mysql.com/products/workbench/   OOjs UI icon edit-ltr-progressive.svg

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, MySQL GUI Tools Bundle.

Contents

History

fabFORCE.net DBDesigner4

fabFORCE.net DBDesigner4 Dbd4 ss simplemodel.png
fabFORCE.net DBDesigner4

DBDesigner4 is an open source visual database design and querying tool for the MySQL database released under the GPL. [2] It was written in 2002/2003 by the Austrian programmer Michael G. Zinner for his fabFORCE.net platform using Delphi 7 / Kylix 3. [3] [4]

While being a physical-modeling only tool DBDesigner4 offers a comprehensive feature set including reverse engineering of MySQL databases, model-to-database synchronization, model poster printing, basic version control of schema models and a SQL query builder. [5] It is available for MS Windows, Mac OS X and Linux. [6]

In late 2003, Zinner was approached by representatives from MySQL AB and joined the company to take over the development of graphical user interface (GUI) tools for MySQL. This led to the creation of the MySQL GUI Tools Bundle. [7]

MySQL GUI Tools Bundle

The MySQL Administrator part of GUI Tools MySQLadministrator1.png
The MySQL Administrator part of GUI Tools

The MySQL GUI Tools Bundle is a cross-platform open source suite of desktop applications for the administration of MySQL database servers, and for building and manipulating the data within MySQL databases. It was developed by MySQL AB and later by Sun Microsystems and released under the GPL. Development on the GUI Tools bundle has stopped, and is now[ when? ] only preserved under the Download Archives of the MySQL site. [8]

The GUI Tools bundle has been superseded by MySQL Workbench, and reached its End-of-Life with the beta releases of MySQL Workbench 5.2. However, the MySQL Support team continued to provide assistance for the bundle until June 30, 2010. [9]

Releases

The first preview version of MySQL Workbench was released in September 2005, [10] and was not included in the MySQL GUI Tools Bundle. Development was started again in 2007 and MySQL Workbench was set to become the MySQL GUI flagship product. [11]

Version numbering was started at 5.0 to emphasise that MySQL Workbench was developed as the successor to DBDesigner4. [12]

MySQL Workbench 5.0 and 5.1

MySQL Workbench 5.0 and 5.1 are specialized visual database design tools for the MySQL database. While MySQL Workbench 5.0 was a MS Windows-only product, cross-platform support was added to MySQL Workbench 5.1 and later. [13] [14]

MySQL Workbench 5.2

Starting with MySQL Workbench 5.2 the application has evolved to a general database GUI application. Apart from physical database modeling it features an SQL Editor, database migration tools, and a database server administration interface, replacing the old MySQL GUI Tools Bundle.

MySQL Workbench 6.0

On May 22, 2013, the MySQL Workbench Team announced [15] that they were working on Version 6.0. The first public beta, labeled version 6.0.2, was released [16] on June 14, 2013, and the first general-availability release was made on August 12, 2013. [17]

MySQL Workbench 6.1

On January 23, 2014 the MySQL Workbench Team announced [18] its first public beta release of Version 6.1. The first general-availability release was made on March 31, 2014. [19] New features include improved Visual Explain output, a Performance dashboard, Performance Schema support, additional query result views, and MSAA support.

MySQL Workbench 6.2

On August 19, 2014, the MySQL Workbench Team announced [20] its first public beta release of Version 6.2. The first general-availability release was made on September 23, 2014. [21] New features are shortcut buttons for common operations, "pinning" of the results tab, Microsoft Access Migration, [22] MySQL Fabric Integration, Spatial View Panel to visualize spatial and geometry data, Geometry Data Viewer, Result Set Width, SQL editor tabs are properly saved, Shared Snippets, a new Run SQL Script dialog, Model Script Attachments, Client Connections management has a new "Show Details" window where more information about connections, locks, and attributes is displayed, performance columns can display sizes in KB, MB, or GB, the migration wizard can resume operations of data copying if interrupted, MySQL connection password is remembered across the MySQL Workbench session.

MySQL Workbench 6.3

On March 5, 2015, the MySQL Workbench Team announced [23] its first public beta release of Version 6.3. The first general-availability release was made on April 23, 2015. [24] New features include a "fast migration" option to migrate the data from the command-line instead of the GUI, a SSL certificate generator, improved SQL auto-completion, a new table data import and export wizard, and MySQL Enterprise Firewall support. Version 6.3.8, MySQL Workbench for MacOS has incompatibilities with MacOS Sierra. [25] Version 6.3.9 is compatible with MacOS Sierra, however it doesn't work on MacOS High Sierra. [26] MacOS High Sierra users need to run version 6.3.10. [26]

MySQL Workbench 8.0

On April 5, 2018, the MySQL Workbench Team announced [27] the first public release of version 8.0.11 as a Release Candidate (RC) together with MySQL Community Server 8.0.11. The first General Availability (GA) release appeared on July 27, 2018 [28] again together with the server following the new policy for aligning version numbers across most of MySQL products. [29] MySQL Workbench now uses ANTLR4 as backend parser and has a new auto-completion engine that works with object editors (triggers, views, stored procedures, and functions) in the visual SQL editor and in models. The new versions add support for new language features in MySQL 8.0, such as common-table expressions and roles. There's also support for invisible indexes and persisting of global system variables. The new default authentication plugin caching_sha2_password in MySQL 8.0 is now supported by Workbench, so resetting user accounts to other authentication types is no longer necessary when connecting to the latest servers. Administrative tabs are updated with the latest configuration options and the user interface was made more consistent between the tabs.

As of 1 July 2024, the latest version is 8.0.38, but its syntax-checker is inconsistent with deprecation of the terms "master" and "slave" in favour of "source" and "replica" respectively in MySQL version 8.0.

Features

Prominent features of MySQL Workbench are:

Licensing and editions

MySQL Workbench is the first MySQL family of products that offer two different editions - an open source and a proprietary edition. [30] The "Community Edition" is a full featured product that is not crippled in any way. Being the foundation for all other editions it will benefit from all future development efforts. The proprietary "Standard Edition" extends the Community Edition with a series of modules and plugins. [31] [ citation needed ]

As this business decision was announced soon after the takeover of MySQL by Sun Microsystems, this has caused speculation in the press about the future licensing of the MySQL database. [32] [33]

Community reception and reviews

Since its introduction MySQL Workbench has become popular within the MySQL community. It is now the second most downloaded product from the MySQL website with more than 250,000 downloads a month. [34] Before that it was voted Database Tool of the Year 2009 on Developer.com. [35]

MySQL Workbench has been reviewed by the open source community and print magazines. [36] [37] [38] [39]

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

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 organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

<span class="mw-page-title-main">Mac OS X Server</span> Server software for macOS

Mac OS X Server is a series of discontinued Unix-like server operating systems developed by Apple Inc. based on macOS. It provided server functionality and system administration tools, and tools to manage both macOS-based computers and iOS-based devices, network services such as a mail transfer agent, AFP and SMB servers, an LDAP server, and a domain name server, as well as server applications including a Web server, database, and calendar server.

FileMaker is a cross-platform relational database application developed by Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to visually modify a database. Versions for desktops, servers, iOS, and web-delivery have been released.

C++Builder is a rapid application development (RAD) environment for developing software in the C++ programming language. Originally developed by Borland, as of 2009 it is owned by Embarcadero Technologies, a subsidiary of Idera. C++Builder can compile apps for Windows, iOS, macOS, and Android. It includes tools that allow drag-and-drop visual development, making programming easier by incorporating a WYSIWYG graphical user interface builder.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

<span class="mw-page-title-main">Kexi</span> KDE visual database applications creator

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.

SQLyog is a 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.

Oracle Data Mining (ODM) is an option of Oracle Database Enterprise Edition. It contains several data mining and data analysis algorithms for classification, prediction, regression, associations, feature selection, anomaly detection, feature extraction, and specialized analytics. It provides means for the creation, management and operational deployment of data mining models inside the database environment.

<span class="mw-page-title-main">World Programming System</span> Data analysis software

The World Programming System, also known as WPS Analytics or WPS, is a software product developed by a company called World Programming.

Entity Framework (EF) is an open source object–relational mapping (ORM) framework for ADO.NET. It was originally shipped as an integral part of .NET Framework, however starting with Entity Framework version 6.0 it has been delivered separately from the .NET Framework.

<span class="mw-page-title-main">MonoDevelop</span> Integrated development environment, discontinued for macOS

MonoDevelop was an open-source integrated development environment for Linux, macOS, and Windows. Its primary focus is development of projects that use Mono and .NET Framework. MonoDevelop integrates features similar to those of NetBeans and Microsoft Visual Studio, such as automatic code completion, source control, a graphical user interface (GUI), and Web designer. MonoDevelop integrates a Gtk# GUI designer called Stetic. It supports Boo, C, C++, C#, CIL, D, F#, Java, Oxygene, Vala, JavaScript, TypeScript, and Visual Basic.NET. Although there is no word from the developers that it has been discontinued, nonetheless, it hasn't been updated in 4 years and is no longer installable on major operating systems, such as Ubuntu 22.04 and above. Its parent Microsoft seems to have shifted focus to Visual Studio Code and the .NET Framework, which runs on many operating systems, including Linux.

<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

<span class="mw-page-title-main">Kickstart (Amiga)</span> Bootstrap firmware used by Amiga computers

Kickstart is the bootstrap firmware of the Amiga computers developed by Commodore International. Its purpose is to initialize the Amiga hardware and core components of AmigaOS and then attempt to boot from a bootable volume, such as a floppy disk. Most Amiga models were shipped with the Kickstart firmware stored on ROM chips.

<span class="mw-page-title-main">Mono (software)</span> Computer software project

Mono is a free and open-source .NET Framework-compatible software framework. Originally by Ximian, it was later acquired by Novell, and is now being led by Xamarin, a subsidiary of Microsoft and the .NET Foundation. Mono can be run on many software systems.

<span class="mw-page-title-main">Database Workbench</span>

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

Skipper is a visualization tool and code/schema generator for PHP ORM frameworks like Doctrine2, Doctrine, Propel, and CakePHP, which are used to create database abstraction layer. Skipper is developed by Czech company Inventic, s.r.o. based in Brno, and was known as ORM Designer prior to rebranding in 2014.

The following outline is provided as an overview of and topical guide to MySQL:

References

  1. ↑ "Chapter 2: Installation". MySQL Workbench. MySQL. November 27, 2014.
  2. ↑ DBDesigner4 Webpage, fabFORCE.net. Retrieved 2010-03-26.
  3. ↑ fabFORCE.net About Page, fabFORCE.net. Retrieved 2010-03-26.
  4. ↑ DBDesigner4 Source Code Download, fabFORCE.net. Retrieved 2010-03-26.
  5. ↑ DBDesigner4 Feature List, fabFORCE.net. Retrieved 2010-03-26.
  6. ↑ DBDesigner4 Download Page, fabFORCE.net. Retrieved 2010-03-26.
  7. ↑ Arjen Lentz, "Interview with Michael G. Zinner" Archived May 3, 2010, at the Wayback Machine , MySQL.com. Retrieved 2010-03-26.
  8. ↑ MySQL GUI Tools Bundle: Archived Downloads, MySQL.com, Retrieved 2010-03-26.
  9. ↑ MySQL Product Support EOL Announcements, MySQL.com, Retrieved 2010-03-26.
  10. ↑ MySQL GUI Bundle announcement (without MySQL Workbench), MySQL.com Forum Archive, Retrieved 2010-03-26.
  11. ↑ Workbench Schedule Announcement, MySQL.com Forum Archive, Retrieved 2010-03-26.
  12. ↑ MySQL Workbench FAQ - General, MySQL Workbench Blog, Retrieved 2010-03-26.
  13. ↑ Michael G. Zinner, "Why Release on Windows First", MySQL Workbench Blog, Retrieved 2010-03-26.
  14. ↑ MySQL Workbench Releases, MySQL Workbench Blog, Retrieved 2010-03-26.
  15. ↑ "MySQL Workbench 6.2  » Blog Archive  » MySQL Workbench 6.0 – A Sneak Preview". mysqlworkbench.org. Retrieved May 10, 2015.
  16. ↑ "MySQL Lists: announce: MySQL Workbench 6.0.2 Beta 1 released". mysql.com. Retrieved May 10, 2015.
  17. ↑ "Changes in MySQL Workbench 6.0". MySQL. Oracle Corporation. Retrieved August 20, 2013.
  18. ↑ "MySQL Workbench 6.2  » Blog Archive  » MySQL Workbench 6.1.1 BETA has been released". mysqlworkbench.org. Retrieved May 10, 2015.
  19. ↑ "Changes in MySQL Workbench 6.1". MySQL. Oracle Corporation. Retrieved June 2, 2014.
  20. ↑ "MySQL Workbench 6.2  » Blog Archive  » MySQL Workbench 6.2.1 BETA has been released". mysqlworkbench.org. Retrieved May 10, 2015.
  21. ↑ "Changes in MySQL Workbench 6.2". MySQL. Oracle Corporation. Retrieved October 3, 2014.
  22. ↑ "MySQL :: MySQL Workbench :: 10.4 Microsoft Access Migration". mysql.com. Retrieved May 10, 2015.
  23. ↑ "MySQL Workbench 6.3.1 Beta has been released".
  24. ↑ "Changes in MySQL Workbench 6.3". Oracle Corporation.
  25. ↑ "MySQL Compatibility with MacOS Sierra". Stack Overflow.
  26. 1 2 "MySQL Bugs: #87862: MySQL does not work on MacOS High Sierra". bugs.mysql.com.
  27. ↑ "MySQL Workbench 8.0.11-rc has been released".
  28. ↑ "MySQL Workbench 8.0.12 has been released".
  29. ↑ "MySQL 8.0: It Goes to 11!".
  30. ↑ MySQL Workbench Editions, MySQL Workbench Blog. Retrieved 2010-03-26.
  31. ↑ Michael G. Zinner, "Beta testers wanted!", MySQL Mailing List Archives, 2007-11-19. Retrieved 2010-03-26.
  32. ↑ Sun Introduces MySQL Workbench, O'Reilly Conference News, Retrieved 2010-03-26.
  33. ↑ Sean Michael Kerner, "MySQL Not Going Closed Source?", internetnews.com. Retrieved 2010-03-26.
  34. ↑ MySQL Workbench Contribute Page, MySQL Workbench Blog. Retrieved 2010-03-26.
  35. ↑ Winners - Product of the Year 2009, Developer.com, 2009-01-14. Retrieved 2010-03-26.
  36. ↑ Jack Wallen, "Get to Know MySQL Workbench", Linux.com, 2010-03-16. Retrieved 2010-03-26.
  37. ↑ Konstantin Mirin, "MySQL Workbench – The Database Modeling Tool for MySQL", programmersnotes.info, 2009-03-01. Retrieved 2010-03-26.
  38. ↑ Cal Evans, "MySQL Workbench – A Superficial Review", blog.calevans.com, 2009-07-05. Retrieved 2010-03-26.
  39. ↑ MySQL Workbench 5.1: Too many tables and too many complex relationships? Visualize your MySQL database with MySQL Workbench., Linux Magazine, 2001-03-19. Retrieved 2010-03-26.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.