sqlite wasm support

[tantaman]

Curious if you guys have built out or plan to build out support for SQLite in the browser.

In particular, for either one of these builds: https://github.com/rhashimoto/wa-sqlite or https://sqlite.org/wasm/doc/tip/about.md

(although wa-sqlite is not the official WASM port, it seems to be in a much better state than the official one)

For some more context, I maintain a SQLite project that allows syncing data between a persistent SQLite instance in the browser and server or peers -- https://github.com/vlcn-io/cr-sqlite

[AndriiSherman]

Hi @tantaman!

Yes, we have a ticket for it #193. We were checking https://sqlite.org/wasm/doc/tip/about.md and this post and already have working POC for that. Just didn't have a chance to finish and release. But it's assigned to me for March milestone so maybe it could be live soon
btw, We also have support for sql.js

But thanks for sharing your library. Will definitely check it this week!

[septatrix]

btw, We also have support for sql.js

That seems to be documented nowhere? The only reference to sql.js seems to be in the release notes for v0.28.3 🤔

[205g0]

Just checked your project and skimmed the repo, how do you want to sync schema changes? I mean, yes it's possible but I don't know how many worms are in this can...

[tantaman]

The idea for schema changes that we're taking is pretty simple.

Peers are forbidden from communicating until they're on the same schema version. Schema versions are distributed via a code update to the application.

[tantaman]

In terms of ensuring state still converges post migration, that is a bit more tricky but something I'm building some primitives for that you run before and after a migration.

[Sheraff]

If there is interest, I wrote a fairly simple adapter for crsqlite-wasm https://www.npmjs.com/package/drizzle-orm-crsqlite-wasm. It's pretty close to what one would need to write to support wa-sqlite but since the APIs are slightly different, my package isn't compatible with it out of the box.

The goal of this package is to exist for as little time as possible, hoping that drizzle-orm itself will soon be compatible with these sorts of WASM builds of SQLite. But in the meantime, it's there if someone needs it.

Also, I'm open to feedback. The package hasn't been tested much yet, but I'm going to start using it on a personal project.