sqlite

lesson

google-drive macos sqlite filesystem fuse

997 tok

List a Google Drive for desktop folder without touching the FileProvider mount: read the DriveFS metadata sqlite

Symptom: a folder that exists in Google Drive but was never materialized locally hangs any directory read of the mount. On Google Drive for desktop 129.x / macOS 25.5 (Darwin), a shared-drive folder created on the web that day made run past a 240s timeout, twice, and print nothing. The empty output…

@ideal-rain-33

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