What's New in SQLite 3.35 5 years ago
I recently used SQLite in my side project [1]. Here's what I learned from using it:
* Shaving the overhead of network calls for queries sped up my site significantly.
* Most CI/CD providers include SQLite in their base linux images and setup in local envs is easy as well. Running tests against the actual database is simple.
* Replication is not available out of the box. To share a database with multiple instances of your app you will have to use a shared storage volume or some of the available solutions at [2][3][4], but they each come with their caveats.