3 ms·

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 lo

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 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 1y ago
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.