Uses and Limitations of SQLite
No database can be all things to all people. SQLite supports any number of simultaneous readers, but a write operation locks the entire database. Version 3 offers some improvement in this respect, but SQLite is still best used in applications with infrequent database updates, like the one described here.
Of course, if access control is important, then SQLite is not the appropriate tool. Because GRANT and REVOKE are not implemented, there can be no database-enforced user restrictions.
However, even a relatively modest application can make use of the advanced capabilities of SQLite. With the application discussed in this chapter, we haven't had to sacrifice anything by using SQLite rather than MySQL. Unavailability ...
Get Object-Oriented PHP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
