OPFS VFS support for browser environments

[arthurcornil]

I recently built a simple proof of concept that uses go-sqlite3 and OPFS as a VFS. I relied on danmestas/go-sqlite3-opfs for OPFS support, which is of uncertain maintenance status.

Following a conversation on HN, @ncruces suggested opening a discussion to track interest in a proper OPFS VFS implementation for go-sqlite3.

HN post: https://news.ycombinator.com/item?id=48106940
wa-sqlite, that supports OPFS: https://github.com/rhashimoto/wa-sqlite

Opening this to track interest and figure out next steps. Happy to contribute on the browser/OPFS side if needed.

[ncruces]

cc: @danmestas creator of danmestas/go-sqlite3-opfs

As I wrote on HN, I know quite a bit about SQLite VFSes, and can help there, bit very little about browsers.

[danmestas]

@arthurcornil I've been interested in this type of thing for a while. I went through nearly a decade of GraphQL resolver, django-rest-framework, and Redux boilerplate hell.

I follow the local-first software happenings pretty closely, but the solutions they've come up with are too complex for me. I stumbled across nlepage/go-wasm-http-server and go-app.dev that Dagger.io uses, and got inspired (I have good blood with serviceworkers).

The VFS implementation was written by clankers, but I tested it quite a bit. If you were to submit an issue I'd triage it and get it fixed quickly — but also feel free to fork or just reimplement from scratch.

FWIW, I chose @ncruces sqlite because it has no cgo and compiles easily banchmarks well and I can write purely in go. I have other POCs with other implementations, but they tend to be much more complex.