Comment by ncruces

Comment by ncruces 14 hours ago

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 4 hours ago

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

Reply View 0 replies

pdyc 9 hours 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.

Reply View 1 reply

ncruces 8 hours ago

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.

Reply View | 0 replies