Is SQLite in Ecto "production-ready"?

Questions & Help Questions
, ,
1

Just read this blog post on how Rails 8 features immediate mode for SQLite and makes it a viable choice for most production workloads (assuming no deployment redundancy).

Is immediate mode available on Ecto’s SQLite 3 adapter too? I don’t see a mention of it on the docs. Is there a way to make it the default?

2

Iirc are options on Repo.transaction to make it add the necessary keyword.

3

Here’s a relevant discussion in the ecto_sqlite3 repo:

https://github.com/elixir-sqlite/ecto_sqlite3/issues/151

Short answer: just add a function to your Repo module to do immediate transactions :slight_smile: