Internal versus External BLOBs in SQLite

sqlite.org

2 pointsi_feel_great2 comments

I don't know who posted this story, but it is timely. Earlier today I was working on a new related article (https://www.sqlite.org/draft/fasterthanfs.html) claiming that it is faster to read blobs out of SQLite than it is to read them out of separate files on disk. Comments welcomed.

I posted it. Timely indeed. I am trying to figure out a way to cache images content for a web application without eating RAM or using up file handles. Many proxy caches have Lua embedded and Lua has good drivers for SQLite3. Anyone else have suggestions?

Reply on news.ycombinator.com