[local_surfer]

Orama is definitely a hidden gem, and it's a clever usage for complementary indexing!

Also agreed Triplit's DX is excellent. I'd recommend giving it another look, Triplit's recent 1.0 release has up to 10x performance boost (https://www.triplit.dev/blog/triplit-1.0).

Since your use-case is data in the range of gigabytes, you could consider using duckdb-wasm. However I'm not sure how to best integrate this with collaboration / CRDTs (sqlRooms is also interesting prior art).

[isaachinman]

Yeah, I spent quite some time researching nearly all indexing options. Orama is in a different league (although it does have some warts).

We have hundreds of thousands of entities in Replicache, and index them via Orama. We're able to perform full-text search in single-digit ms.

We persist the Orama index as JSON, so computation only happens once per mutation.