ncruces helped me with some code I made for VFS. It uses [zstd seekable](https://github.com/jtarchie/sqlitezstd) for reading a file. I thought it would be really well-suited for S3.
- Support for HTTP range queries
- "Fast" read times
- No disk required
I was wrong.
It turns out that for specific SQL queries, it might be fine, but not fast.
For queries that do aggregations, like `COUNT`, sqlite loads the whole database anyway.
Warning: Was vibe coded with my instructions of architecture, testing preferences (LuaJIT for FFI), and how I wanted to be able to accept stories.