News for hackers. Stuff that matters.

A comment on Creating an advanced search engine with PostgreSQL. Parent comment

Re:Creating an advanced search engine with PostgreSQL by worldsayshi on Thursday July 13, 2023 @04:29AM (#36706384)
CrateDB is very promising. It's not acid though.

Another potential of to use zombodb (haven't tried it myself).

[ Parent | on HN ]
Re:Creating an advanced search engine with PostgreSQL by baur on Thursday July 13, 2023 @05:03AM (#36706579)
Yep, CrateDB is not ACID but has eventual consistency at the row level.

I think for some use cases it's fine that some inserts are not visible in search results immediately. Also, once could tweak refresh_interval or use explicit refresh for "must be visible" inserts.

[ Parent | on HN ]