Avoiding SQLite Database Locks in Production
Some tips for working with sqlite, which is great in prod.
It comes down to:
- Better error tracking (I personally use AppSignal for it’s good Rails integration)
- SQLite configuration
- Background job recurring jobs
- Optimize SQLite batch jobs