History of MySQL and Open Source Database Market Evolution
60 likes | 170 Views
Explore the inception of MySQL in 1995, its evolution post-acquisition, and the rise of open-source competitors like SQLite, PostgreSQL, and MongoDB in the database market. Uncover the journey from MySQL to MariaDB and the shifting landscape of database technologies.
History of MySQL and Open Source Database Market Evolution
E N D
Presentation Transcript
Post-Module PHP Functions and MySQL BTM 395: Internet Programming
Default function parameters • PHP CodePadexercise: http://codepad.org/lWbpmr1D • You can do this in JavaScript, but it is rather convoluted
Passing arguments by reference • [Top Hat exercises]
PHP Manual • PHP Manual: Official documentation for PHP • PHP Language Reference: list of all language features • PHP Function Reference: list of all extended functions that are standard PHP • Many of these functions are included in special modules that might or might note be installed by your web host
Brief history of MySQL • Created in 1995 by MySQL AB, a Swedish company • “My” is the name the daughter of one of the creators, Monty Widenius • 2008: Sun Microsystems acquired MySQL AB • 2009: Monty Widenius forked MySQL to create MariaDB when Oracle attempted to buy Sun Microsystems • “Maria” is Monty Widenius’ youngest daughter • MariaDB maintains 100% compatibility with MySQL • 2010: Oracle acquired Sun Microsystems with MySQL • A number of MySQL lead developers have moved to MariaDB • 2012: Many major MySQL users started switching to MariaDB Source: Wikipedia
Open source competitors of MySQL • SQLite: small, embedded single-user databases • Possibly the most widely deployed database in the world, whether open-source or proprietary • PostgreSQL: #3 OSS database, after MySQL • Better for enterprise-class applications than MySQL • Faster for larger-scale applications • MySQL may be faster for read-heavy applications • MongoDB: non-relational document-oriented database • Suitable for very large, unstructured data sets