Hey,
I’ve noticed in the Temporal docs that SQLite v3.x persistence is supported, but only for development and testing, not for production. I understand that PostgreSQL and MySQL are the officially supported production backends, but I’m curious to understand more deeply why SQLite is discouraged (even for small to medium use cases?)
What are the shortcomings of running Temporal with SQLite in production (for small-scale use cases)?
SQLite can be used from a single process only. Temporal service is scaled out by adding processes that share a single DB.
1 Like