yesodweb / persistent

Persistence interface for Haskell allowing multiple storage methods.
MIT License
464 stars 294 forks source link

Full Text / Natural language query support #606

Open dfordivam opened 8 years ago

dfordivam commented 8 years ago

Many DBs support the full-text/natural language query natively. This is a feature request to add support for doing these queries.

These are the links with details of the native support.

Mysql Postgres MongoDB

Since this feature may not be available in all back-ends, special operators may be added for the relevant backends. I have tried mongoDBs $text in my sandbox and was able to get the query working fine. But I would like to hear from others, what is the roadmap of supporting such features.

gregwebs commented 8 years ago

I think each backend should welcome custom operators independently. Nobody will be satisfied with an attempt to unify this across backends. MongoDB has a lot of custom operators already such as anyEq and it shouldn't be hard to add $text.