Hands-On Software Engineering with Python

MySQL/MariaDB

MySQL is a popular RDBMS that started as an open source project in the mid 1990s. MariaDB is a community-maintained fork of MySQL, intended to serve as a drop-in replacement for MySQL, and to remain available as an open source option in case MySQL (now owned by Oracle) every ceases to be released under an open source license. MySQL and MariaDB are, at the time of writing this book, interchangeable.

Both use the same variant of SQL, with mostly trivial syntax differences from standard SQL that are typically very straightforward. MySQL is—and MariaDB is presumed to be—more optimized for reading/retrieving data than for writing it, but for many applications, those optimizations will likely not be noticeable.

MySQL and MariaDB can ...