Running on Cloudflare Workers

[sorenbs]

Has anybody experimented with running wa-sqlite on Cloudflare Workers?

I am interested in using the recently announced Cloud Backed SQLite VFS module (or implement a similar mechanism in Javascript) and run it in a Cloudflare Durable Object.

[rhashimoto]

I'm not aware of anything in that specific area, but there are examples of using an in-browser SQLite VFS to access a remotely stored database:

• @phiresky wrote a VFS for SQL.js to access a database file using HTTP Range from a static web site. This work inspired a lot of similar efforts; I'm sure I'm not aware of all of them.
• @ydylla wrote a WebTorrent VFS.
• Here's another WebTorrent VFS.
• @LoneRifle wrote a writable Amazon S3 VFS. This is the closest effort I know of to your question.

In addition, there is development on syncing distributed local databases (including in-browser) to be "eventually consistent". cr-sqlite is one example using (a fork of) wa-sqlite.

[sorenbs]

These are some great resources - thank you! I think my first experiment is going to be to get one of these wasm builds targeting the browser to work on Cloudflare Workers.