ncruces/go-sqlite3

Integrate with sqlite-zstd

Closed this issue · 3 comments

franchb commented

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

ncruces commented

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.

  • 👍1
franchb commented

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

  • 👍1
ncruces commented

Please report any feedback!