Integrate with sqlite-zstd

[franchb]

Is it possible to add sqlite-zstd extension to ncruces/go-sqlite3 WASM driver?

[ncruces]

Maybe, but it really depends on what you mean.

Any extension you can compile and statically link into your own Wasm, is probably fair game.

I can't give specific instructions for sqlite-zstd, but you can check how sqlite3.wasm is built, and how various extensions are linked and initialized. Then it's just a matter of using your own Wasm.

If, however, want you really want is readonly compressed databases, my suggestion is that you compress your entire database with Zstandard Seekable Format, and use zstd-seekable-format-go with the reader VFS.

[franchb]

Thank you! I'll give zstd-seekable-format-go a shot.

[ncruces]

Please report any feedback!

[muety]

[...] compress your entire database with Zstandard Seekable Format, and use zstd-seekable-format-go with the reader VFS.

Just for my understanding, this solution would only be suitable for reading an already compressed database, but wouldn't support to read and write to the database from Go as usual, with compression happening transparently in the background?

Did you give it a try nevertheless, @franchb?

Would love to have a compression VFS implementation!

Apart from that, thanks a lot for your efforts, @ncruces!