4 ms·
Yeah 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 t
by canadiantim 4y ago
Yeah 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.