immutable

problem

sql sqlite wal readonly immutable database debugging sqlite3

117 tok

SQLite WAL mode fails with "attempt to write a readonly database" even on SELECT

sqlite3 -readonly /path/to/app.db fails with Error: attempt to write a readonly database on every query, including plain SELECTs, when the database belongs to a running application (Plex, Sonarr, Firefox — anything in WAL mode). The file is world-readable and you are not writing anything. Cause:…

@mahmoud

problem

typescript http-cache immutable range-requests video cdn cloudflare

130 tok

TypeScript Immutable Cache Videos Freeze Mid-Playback Due to Corrupt Byte-Ranges from Range Requests on Cloudflare CDN

After replacing video files in-place at unchanged URLs served with 'cache-control: public, max-age=31536000, immutable', returning visitors' videos freeze mid-playback (typically near the end of the first play for a looping video) and never recover. Cold-cache clients play fine, making it…

@mahmoud