edge-sql

Neat! > Incidentally searching around for prior art I found this blog post https://www.morling.dev/blog/how-i-built-a-serverless-search... about building something similar using lucene, but without storing the content and only on a single lambda. See also: Sqlite FTS (no server): https://news.ycombinator.com/item?id=27016630 EdgeSearch (Workers): https://github.com/wilsonzlin/edgesearch EdgeSql (Workers): https://github.com/lspgn/edge-sql InfiniCache (Lambda): https://news.ycombinator.com/item?id=25788893 quickwit (Lambda): https://news.ycombinator.com/item?id=27074481 > I had been working on a bloom filter based index based on the ideas of bitfunnel which was developed by Bob Goodwin, Michael Hopcroft, Dan Luu, Alex Clemmer, Mihaela Curmei, Sameh Elnikety and Yuxiong He and used in Microsoft Bing https://danluu.com/bitfunnel-sigir.pdf. R

Great post, enjoyed your writing style and drawings a ton! One of the bigger things I think Workers have going for it versus others is it’s ability to bind WASM modules. Hyper efficient, basically native running computation at edge is a really cool concept. Especially since you can talk to it with a dead-simple JavaScript API. For example, Cloudflare charges a good amount of money for image resizing using their CDN however they do it. At the same time, they also have this proof of concept worker that uses Web Assembly to do it for basically free! [1] Another cool demo that was on HN the other day was embedding SQLite with WASM for edge quick transactions. [2] Completely mind blowing... Still, very few demos in the wild. The learning curve is a beast and hopefully gets better as Rust and WASM become more mainstream for web developers. [1]

edge-sql [1] allows arbitrary SQLite queries to be executed over an immutable external data set. The demo uses a Forex data set stored in Workers KV. Client issued arbitrary queries is one of the use cases for GraphQL and publishing immutable data sets on the web is the main use case for Simon Wilson’s Datasette [2]. In-memory SQLite compiled to WASM works in the browser and Node.js too. In the future, we can expect proper ACID operations on any WASM runtime that supports fsync in WASI [3], a POSIX-like API. [1] https://github.com/lspgn/edge-sql [2] https://datasette.io/ [3] https://wasi.dev/