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...

▲

keepamovin an hour ago | parent | next [-]

Your page is served over sqlitevfs with Range queries? Let's try this here.

▲

pdyc 6 hours ago | parent | prev [-]

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.

	▲	ncruces 5 hours ago \| parent [-]
		The package I'm using in the HTTP example can be configured to cache data: https://github.com/psanford/httpreadat?tab=readme-ov-file#ca... But, also, SQLite caches data; you can simply increase the page cache.