Content deleted Content added
m →Graphical user interfaces: HTTP to HTTPS for SourceForge |
|||
| (29 intermediate revisions by 23 users not shown) | |||
Line 1:
{{Short description|1=Overview of and topical guide to MySQL}}
<!--... Attention: THIS IS AN OUTLINE
part of the set of
[[
Wikipedia outlines are
Line 9 ⟶ 10:
content navigation systems
[[Wikipedia:WikiProject
Further improvements
to this outline are on the way
Line 16 ⟶ 17:
The following [[outline (list)|outline]] is provided as an overview of and topical guide to MySQL:
'''[[MySQL]]''' ("My [[Structured Query Language]]") – world's second most{{Efn|Following [[SQLite]], which is deployed with every [[Android (operating system)|Android]] and [[iPhone]] device along with the [[Google Chrome|Chrome]] and [[Firefox]] browsers.<ref name="sqlite">{{cite web | url=https://www.sqlite.org/famous.html | title=Well-Known Users of SQLite | publisher=The SQLite Consortium | accessdate=8 October 2013 | quote=Apple uses SQLite for many functions within Mac OS X, including Apple Mail, Safari, and in Aperture. Apple uses SQLite in the iPhone and in the iPod touch and in iTunes software. .... SQLite is the primary meta-data storage format for the Firefox Web Browser and the Thunderbird Email Reader from Mozilla. .... It is known that Google uses SQLite in their Desktop for Mac, in Google Gears, in the Android cell-phone operating system, and in the [[Google Chrome]] Web Browser.}}</ref> In the second quarter of 2013 alone, 213 million smartphones shipped, of which 200 million were Android and iOS.<ref>{{cite web | url=
== What type of thing is MySQL? ==
Line 27 ⟶ 28:
** [[Solution stack]] component – one of the pieces of a solution stack, which is a set of software subsystems or components needed to create a complete platform such that no additional software is needed to support applications. Applications are said to "run on" or "run on top of" the resulting platform. Some definitions of a platform overlap with what is known as system software.
*** [[List of Apache–MySQL–PHP packages|AMP-stack]] component – MySQL is the "M" component of Apache-MySQL-Perl/PHP/Python solution stacks (which, by the way, are available across all computer platforms). AMP software bundles are used to run dynamic Web sites or servers.
*It supports php, perl, c, c++, java etc.
== Ownership and copyrights ==
Line 52 ⟶ 53:
* [[DBEdit]]{{snd}} a free front end for MySQL and other databases
* [[HeidiSQL]]{{snd}} a full featured free front end that runs on [[Windows]], and can connect to local or remote MySQL servers to manage databases, tables, column structure, and individual data records. Also supports specialised GUI features for date/time fields and enumerated multiple-value fields<ref>{{cite web | url=http://www.heidisql.com/screenshots.php?which=grideditors | title=HeidiSQL Grid editing features}}</ref>
* [[LibreOffice|LibreOffice Base]]{{snd}} LibreOffice Base allows the creation and management of databases, preparation of forms and reports that provide end users easy access to data. Like [[Microsoft Access]], it can be used as a front-end for various database systems, including Access databases (JET), ODBC data sources, and MySQL or [[PostgreSQL]]<ref>{{cite web | url=http://www.libreoffice.org/features/base/ | title=LibreOffice Base | accessdate=5 January 2012 | url-status=dead | archiveurl=https://web.archive.org/web/20120107063659/http://www.libreoffice.org/features/base/ | archivedate=7 January 2012 }}</ref>
* [[Navicat]]{{snd}} a series of proprietary graphical database management applications, developed for Windows, Macintosh and Linux
* [[OpenOffice.org]]{{snd}} freely available [[OpenOffice.org Base]] can manage MySQL databases if the entire suite is installed
* [[phpMyAdmin]]{{snd}} a free Web-based front-end, widely installed<ref>{{cite web |title=Download Statistics: phpMyAdmin|url=
* [[SQLBuddy]]{{snd}} a free Web-based front end, developed in PHP
* [[SQLyog]]{{snd}} proprietary, but there is also a free 'community' edition available
Line 69 ⟶ 70:
** CassandraSE –
** CONNECT (storage engine) –
** [[Falcon (storage engine)|Falcon]] – was<ref>http://www.eweek.com/c/a/Database/Oracle-Discusses-MySQL-Database-Plans-854185/ {{Dead link|date=February 2022}}</ref> a [[database transaction|transactional]] [[storage engine]] being developed for the [[MySQL]] [[relational database management system]]. Development was stopped after Oracle purchased MySQL.<ref>{{Cite web|url=http://www.databasejournal.com/features/mysql/article.php/3876206/Oracle-Commits-to-MySQL-with-InnoDB.htm|title=Oracle Commits to MySQL with InnoDB|date=13 April 2010}}</ref> It was based on the [[Netfrastructure]] database engine. Falcon was designed to take advantage of Sun's [[zfs]] file system.
** FederatedX –
** [[InfiniDB]] – scalable, software-only columnar database management system<ref>{{Cite web|url=http://www.cmswire.com/cms/enterprise-cms/infinidb-20-supports-big-data-analytics-009089.php|title = InfiniDB 2.0 Supports Big Data, Analytics}}</ref> for analytic applications.<ref>{{Cite web|url=http://www.enterpriseirregulars.com/28857/calpont%E2%80%99s-infinidb-%E2%80%93-another-adbms-insurgent-arises/|title = Calpont's InfiniDB – Another ADBMS Insurgent Arises|date = 8 November 2010}}</ref> However, on 1 October 2014 InfiniDB ceased operations and filed for bankruptcy protection in US Bankruptcy Court in the Eastern District of Texas. Existing customers may be able to receive support from other companies, notably MariaDB.
** [[InnoDB]] – storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity).
** mroonga –
Line 102 ⟶ 103:
== Forks of MySQL ==
* [[Drizzle (database server)|Drizzle]] – free software/open source relational database management system (DBMS) that was forked from the now-defunct 6.0 development branch of the MySQL DBMS.<ref>
* [[MariaDB]] is a community-developed fork of MySQL intended to remain free under the GNU GPL, being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.<ref>{{cite web|url=http://www.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/ |title=Dead database walking: MySQL's creator on why the future belongs to MariaDB - MariaDB, open source, mysql, Oracle |publisher=Computerworld |date= |accessdate=2013-09-11}}</ref>
* [[Percona Server]] – created by [[Percona]], aims to retain close compatibility to the official MySQL releases, while focusing on performance and increased visibility into server operations.<ref>[http://www.percona.com/software/percona-server/faq Percona Server Frequently Asked Questions] {{Webarchive|url=https://web.archive.org/web/20150415051416/http://www.percona.com/software/percona-server/faq |date=2015-04-15 }}, How is it related to other MySQL forks?</ref> Also included in Percona Server is [[XtraDB]], Percona's fork of the [[InnoDB|InnoDB Storage Engine]].
* [[WebScaleSQL]] – software branch of MySQL 5.6 jointly developed by Facebook, Google, LinkedIn and Twitter to provide a centralized development structure for extending MySQL with new features specific to large-scale deployments, such as building large replicated databases running on server farms. The project's objective is to tightly follow new MySQL community releases, rather than merely be a software fork.
Line 110 ⟶ 111:
* [[Outline of free software]]
<!-- The following links need to be placed in the body of the outline above-->
* [[
* [[MySQL DataController]]
* [[
▲* [[Xeround]] –
==References==
Line 122:
== External links ==
{{
* [http://dev.mysql.com/doc/refman/5.6/en/ ''MySQL 5.6 Reference Manual'']
** [http://dev.mysql.com/doc/refman/5.6/en/tutorial.html ''MySQL 5.6 Tutorial'']
Line 130 ⟶ 129:
* [http://www.oracle.com/us/products/mysql/index.html MySQL site at Oracle.com]
* [http://intruders.tv/en-tech/mysql-co-founder-david-axmark-on-sun-s-billion-dollar-acquisition/ Interview with David Axmark, MySQL co-founder] Video
{{Outline footer}}
[[Category:
[[Category:Outlines|MySQL]]
[[Category:MySQL| ]]
| |||