Summary

As has been shown throughout this chapter, SQLite is an incredibly powerful tool that has a variety of uses in PHP development. More than a RDBMS, it is an excellent method of performing advanced data analysis in memory without the need for a complete and overly complex RDBMS such as MySQL. As an added bonus, because SQLite (both the extension and the library) are installed by default in PHP 5, it can be relied on as a fallback RDBMS, regardless of where the script is executed. If you would like to learn more about the details of the SQLite extension, please consult the PHP manual or the SQLite library's website at http://www.sqlite.org/.