3 liens privés
SQLite Is All You Need
JayJay
July 14, 2026
I read Prefer STRICT tables in SQLite by Evan Hahn last week, and it got me thinking. Here is someone treating SQLite as a database you put real, typed, production data into. Which raises the obvious question: how far does that actually go?
So we found out. We built a social network on SQLite, 50,000 users and a million posts in a single 343MB file, put it behind a Node API, made every table STRICT on Evan's advice, and hammered it until the numbers stopped being flattering. This post is what came back: the benchmarks, the config, the code, and the places it falls over.
https://github.com/rqlite/rqlite
via https://sebsauvage.net/links/?uQT2vg
The distributed database built on SQLite
Fault tolerance and high availability with zero hassle
Why run rqlite?
rqlite combines the simplicity of SQLite with a fault-tolerant, highly available system. Whether you're deploying resilient services in the cloud or reliable applications at the edge, rqlite provides a developer-friendly database that's exceptionally easy to operate.
DiskCache: Disk Backed Cache
DiskCache is an Apache2 licensed disk and file backed cache library, written in pure-Python, and compatible with Django.
The cloud-based computing of 2023 puts a premium on memory. Gigabytes of empty space is left on disks as processes vie for memory. Among these processes is Memcached (and sometimes Redis) which is used as a cache. Wouldn’t it be nice to leverage empty disk space for caching?
Django is Python’s most popular web framework and ships with several caching backends. Unfortunately the file-based cache in Django is essentially broken. The culling method is random and large caches repeatedly scan a cache directory which slows linearly with growth. Can you really allow it to take sixty milliseconds to store a key in a cache with a thousand items?
A faster way to copy SQLite databases between computers
Tagged with sqlitePosted 29 April 2025I store a lot of data in SQLite databases on remote servers, and I often want to copy them to my local machine for analysis or backup.