24 ms·
Does EdgeDB support full text search queries?
by nikivi 4y ago
Does EdgeDB support full text search queries?
- 1st1 4y agoWill be a feature of 3.0 in 6 months. We want to do it right and allow transparent integration with things like elastic, as well as allowing faceted search.
- canadiantim 4y agoYeah I really want to use EdgeDB, but I need full text search somehow. Options would be: 1. Somehow being able to query underlying postgresql database using traditional postgres FTS queries 2. Something like ZomboDB to bring the data into ElasticSearch or other like PGroonga 3. Ideally there would be some kind of FTS within EdgeDB so no need for another service
- 1st1 4y agoWe'll be working on (3) soon and maybe (2) shortly after.
- canadiantim 4y agoThat’s great to hear. Option 3 is the best choice too as it allows for the FTS results to also be constrained by the object level security access logic. Thanks for the great work and replies!
- kardianos 4y agoRight now, I don't see a way to choose an index type. For instance, while I don't need full text search (stemming, etc), simple trigram (gist_trgm_ops) would be desirable.
- RedCrowbar 4y agoYes, we'll be adding a way to choose the index type. It's even more relevant now that we've exposed range types.