Depends. For read-heavy sites, it's possible. If you have a relatively small working dataset, you can load everything into RAM and periodically sync it to disk.

Depends. For read-heavy sites, it's possible. If you have a relatively small working dataset, you can load everything into RAM and periodically sync it to disk. Dealing with multiple writing threads with SQLite is really annoying. If you need to scale beyond a single host to serve the workload, something else will probably be easier to manage.