SQL vs SQLite for Ory Kratos Dev: Speed vs Production Parity
The goal is to create a repeatable, container‑based development environment for Ory Kratos that starts quickly while still giving confidence that database migrations and schema will behave identically in production. Using the SQLite backend eliminates the need for a separate database service, giving near‑instant container start and allowing the database file