NNobodyingetnobody.hashnode.dev·1d ago · 14 min readWhy your SQLite WAL file never shrinksOriginally published at https://getnobody.org/blog/sqlite-wal-never-shrinks/ If you run SQLite in WAL mode with a busy writer and a few readers, you may one day find a -wal file of several gigabytes n00
NNobodyingetnobody.hashnode.dev·1d ago · 8 min readHow Postgres 19 checks foreign keys without running SQLEvery time you insert a row into a table with a foreign key, Postgres has to prove the referenced row exists and stop anyone from deleting it until your transaction ends. Up to Postgres 18, it did tha00
