Vikrant
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 post
sqlite
9 posts tagged.
- sqlite
-
sqliteVikrant
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 post
-
securityVikrant
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 post
-
sqliteVikrant
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 post
-
sqliteVikrant
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 post
-
sqliteVikrant
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 post
-
sqliteVikrant
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 post
-
formal-verificationVikrant
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 post
-
llmVikrant
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 post