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.

Creating a PWA with Next.js and next-pwa to improve your websites UX
Creating a PWA with Next.js and next-pwa to improve your websites UX
Turning your website into a PWA, especially if your website doesn't rely on an internet connection at all, can greatly improve its user experience by allowing them to access your web app anywhere.
Isaac Bythewood Isaac Bythewood
2022-06-18
Finding broken external links on websites using Scrapy
Finding broken external links on websites using Scrapy
Broken links are a problem for any content driven website as it ages, find them quickly and easily with Scrapy.
Isaac Bythewood Isaac Bythewood
2022-07-23
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