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 baur on Thursday July 13, 2023 @02:47AM (#36705785)
I'm wondering if CrateDB [https://github.com/crate/crate] could fit your use case without keeping 2 places to store and sync data.

It's a relational SQL database which aims for compatibility with PostgreSQL. Internally it uses Lucene as a storage and such can offer fulltext functionality which is exposed via MATCH.

[ Parent | on HN ]
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 ]