|
|
|
|
|
by jtarchie
229 days ago
|
|
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. |
|