GOTCHAS WITH SQLITE IN PRODUCTION

Summary from the TLDR newsletter

SQLite provides lower operational complexity. It is the best choice for getting applications running on a single machine. However, SQLite becomes less appealing if a project requires multiple machines, has a write-heavy workload, or has long-running transactions. In these cases, developers are better off using a more traditional database like MySQL or Postgres.