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
databases
5 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
-
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
-
sqlVikrant
Someone built a ray tracer in SQL and it actually works
ClickHouse's query language is Turing-complete. Someone proved it by rendering 3D scenes with recursive CTEs and array functions.
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