Content deleted Content added
Tags: Reverted references removed Visual edit Mobile edit Mobile web edit |
m →Graphical user interfaces: HTTP to HTTPS for SourceForge |
||
| (4 intermediate revisions by 4 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 830+ outlines listed at
Line 9 ⟶ 10:
content navigation systems
See [[Wikipedia: Outlines]] and
[[Wikipedia:WikiProject Outlines]] for more details.
Further improvements
to this outline are on the way
...-->
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=https://venturebeat.com/2013/08/01/android-reaches-massive-80-market-share-windows-phone-hits-global-high-iphone-languishes/ | title=Android reaches massive 80% market share, Windows Phone hits global high, iPhone languishes | publisher=VentureBeat | work=MobileBeat | date=1 August 2013 | accessdate=8 October 2013 | author=Koetsier, John | quote=Global smartphone shipments grew 47 percent to hit 230 million devices in the second quarter of 2013, according to a new report from research firm Strategy Analytics. Android captured record market share of 80 percent, while iOS hit a new low of 14 percent.}}</ref>}} widely used [[relational database management system]] (RDBMS)<ref>{{cite web |url=http://db-engines.com/en/ranking/relational+dbms |title=DB-Engines Ranking |accessdate=12 Feb 2015}}</ref> and most widely used open-source RDBMS.<ref>{{Cite web|url = http://www.oracle.com/us/products/mysql/overview/index.html|title = <nowiki>MySQL | The World's Most Popular Open-Source Database</nowiki>|date = |accessdate = |website = |publisher = |last = |first = }}</ref> It is named after co-founder [[Michael Widenius]]'s daughter, My.<ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.1/en/history.html |title=History of MySQL |work=MySQL 10.0 Reference Manual |publisher=MySQL AB |accessdate=26 August 2011}}</ref>
== What type of thing is MySQL? ==
Line 26 ⟶ 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.
** Component of [[LAMP (software bundle)|LAMP]] – Linux version of AMP
** Component of [[WAMP]] – Windows version of AMP
Line 54 ⟶ 56:
* [[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 101 ⟶ 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>{{Cite web|url=
* [[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]].
Line 127 ⟶ 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}}
| |||