A database in one file
When SQLite fits
Choose SQLite for the workloads it handles well and recognize the concurrency or deployment requirements that point to a database server.
8 minute lesson
~~~
SQLite is a great default when one application owns the database and the data belongs on one machine.
It handles many readers well. Writes are serialized, so applications with many concurrent writers need more care. A database server is usually a better fit when several machines must write directly to the same database.
Start from the workload you have. Do not add a database server only because the project might become large one day.
Lesson completed