I mainly see SQLite as a fast C API for accessing subsets of data from a file on disk, optionally using indexes to speed up that access It makes all of the decisions about what gets read into memory and when for me, so I can pretty much ignore those low level details entirely

→ View original post on X — @simonw,