Many people assume that SQlite is not capable of production builds for web apps, as it lacks an database management server, which handles parallel requests.
Pros:
- No need to set up a DB server, leading to less resources and less hassle regarding network access and dependencies
- No need for a dedicated machine, instance or container to run the database
- Easy to move around, as it is just a file which can be copied
- Migrating to a DB with database server later on is easy
- Easy to scale up vertically
Cons:
- Usually depends on Docker volumes in production
- Updating the schema in the production without overwriting the production DB state must be considered
- Hard to scale up horizontally
What to do
- Use WAL mode for the DB
- You might want to use LibSQL
- Dump your DB for backups Dumping Sqlite