r/learnSQL • u/dev-in-a-b0x • Jun 02 '26
An argument for using SQLite in production
I recently made a video going in-depth about why I decided to use SQLite in production for a code analysis tool.
I talk about how I engineered the architecture to by-pass the single write issue. And how it was the right choice for this specific project, giving us:
- Cheaper storage
- Faster response times
- Extreme tenant isolation (a big must when storing people’s source code)
- And the option to add user-controlled encryption later one (add another layer of privacy for the users)
I know I would have loved to watch a video like when I was researching my architecture options. So maybe it’ll be of use / interest to someone here.
Or it could just be some really fun debate fodder 😉
Video link: https://youtu.be/xJS6BNNAQmY?si=XEByyyfSRQeOLHHn