| ▲ | local_surfer 4 days ago | |
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 2 days ago | parent [-] | |
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. | ||