News for hackers. Stuff that matters.
Re:SQLite Archive Files (2018) by lifthrasiir on Monday September 27, 2021 @10:51AM (#28671338)
> Another missing element is that SQLite's support for large blobs is via linked lists of pages.

This surprised me and you were correct, there is no guarantee that related payload overflow pages are consecutively ordered. I thought extents can be implemented with those pages but it would be pretty bad for random access as is. In fact one of the reasons I thought SQLite can function as a file system was a built-in support of random-accessible BLOBs, and some more research revealed that the support was based on the fact that SQLite loads the entire BLOB into memory. Oops.

There are no comments on this comment yet.