A read-only VFS doing this can be really simple, with the right API… This is my ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ncruces 5 hours ago \| parent \| context \| favorite \| on: Show HN: 22 GB of Hacker News in SQLite A read-only VFS doing this can be really simple, with the right API… This is my VFS: https://github.com/ncruces/go-sqlite3/blob/main/vfs/readervf... And using it with range requests: https://pkg.go.dev/github.com/ncruces/go-sqlite3/vfs/readerv... And having it work with a Zstandard compressed SQLite database, is one library away: https://pkg.go.dev/github.com/SaveTheRbtz/zstd-seekable-form...

pdyc 19 minutes ago [–]

this does not caches the data right? it would always fetch from network? by any chance do you know of solution/extension that caches the data it would make it so much more efficient.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact