Isaac Bythewood's Blog

Optimizing SQLite for Django in production

The default SQLite settings in Django are fine for development but will hit "database is locked" errors under any concurrency. Here's the config I use in production.

Isaac Bythewood Isaac Bythewood
2026-04-18

If you don't know what you're looking for check out some of my older posts.

Counting table row counts in PostgreSQL
Counting table row counts in PostgreSQL
An easy way to count the number of rows in a PostgreSQL table and sort by totals allowing you to find what's taking up space in your database.
Isaac Bythewood Isaac Bythewood
2022-05-28
Adding dark mode with automatic system preference selection
Adding dark mode with automatic system preference selection
Creating a dark, or light, version of your website may seem like a daunting task if you think you need an entirely new color pallet. It's 2022 though and we have the widely supported invert CSS filter.
Isaac Bythewood Isaac Bythewood
2022-07-02
Using EditorConfig to improve coding style consistency
Using EditorConfig to improve coding style consistency
EditorConfig has been around for almost a decade at this point. It is widely supported by many editors natively and many more with plugins.
Isaac Bythewood Isaac Bythewood
2022-05-21