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

We'll be working on (3) soon and maybe (2) shortly after.

That’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!

Right 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.

Yes, we'll be adding a way to choose the index type. It's even more relevant now that we've exposed range types.

Will 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.