LatticeDB wants to be the SQLite of graph databases
A new graph database stores everything in a single file and ships as a 200KB binary. No server, no JVM, just embed it.
Read the note 1 min read
From the notebook
sqlite.
12 notes on this topic.
Someone shipped a monitoring stack in one Go binary
A French dev got sick of Prometheus configs and wrote a monitoring tool that fits in one binary, one YAML file, and one SQLite database.
Read the note 1 min read
Storing metadata in ELF binaries with SQLite
Someone embedded a SQLite database directly into a Linux executable. The binary still runs, the database still queries, and the toolchain does not care.
Read the note 1 min read
The SQLite bug that hid in plain sight for 16 years
Tailscale traced database corruption back to a WAL-mode edge case that survived billions of deployments since 2010.
Read the note 1 min read
Someone built a time machine for SQLite queries with zero dependencies
A developer built a tool that lets you rewind SQLite databases to any point in their history, no external dependencies required.
Read the note 2 min read
LLM-generated CVE reports are polluting security databases
Someone is flooding the National Vulnerability Database with fake SQLite vulnerabilities written by language models, and it is breaking actual security work.
Read the note 1 min read
SQLite stores null bytes in strings without warning
SQLite will happily store NUL characters in text columns. Your application layer might truncate them silently.
Read the note 1 min read
SQLite-utils now ships with proper schema migrations
Simon Willison's sqlite-utils 4.0 adds schema migration tracking. The library that made it trivial to load data into SQLite now makes it trivial to evolve those tables.
Read the note 1 min read
SQLite corruption is usually your fault
The SQLite team keeps a public list of every way you can break their database. Turns out most corruption comes from ignoring fsync or writing to the file yourself.
Read the note 1 min read
SQLite UUIDs tank performance by 300 percent
Random UUIDs as primary keys in SQLite cause page splits that triple insertion time. Integer keys stay fast because SQLite is built for sequential writes.
Read the note 1 min read
Formal verification caught bugs SQLite's test suite missed
Turso used a TLA+ variant called Quint to model their libSQL fork and found over ten real bugs in SQLite's transaction logic that billions of existing tests never saw.
Read the note 1 min read
Torrix: observability without the database tax
A new LLM observability tool runs without PostgreSQL or Redis. That is not a feature list, that is an architecture decision.
Read the note 1 min read