SQLite Forum

books / papers on "one sqlite per user" design ?
Login
I saw somewhere a SQLite database which emulated a folder hierarchy and file storage.  There was one table which held the folder structure and another table which held files, with their contents as BLOBs.  It was used as part of a backup system and was faster than reproducing the folder structure and files using the file system.

I was toying with the idea of suggesting the author add a custom function to compress the BLOBs but never did it.