20 SQLite
If a file-based database will do, then SQLite is a surprisingly performant option—especially when reading data (not so much when writing, which is obvious).
Let's start with a historical reminder: One of the most noticeable new features of PHP 5 was support for the SQLite database. When it became public knowledge that PHP 5 would offer this new feature, the first voices claiming that MySQL was dead or would be shunned by PHP were heard.[ 114 ] That this is of course not the case.
To make a long story short: SQLite is not a replacement for MySQL but an alternative in certain cases. PHP is known to support a large number of databases; there are so many that we can't even introduce them all in this book. SQLite is another one, but one ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access