Lee
Reputation: 8734
Rails full text search appropriateness for "standard" queries
Gems such as Ransack make it easy to search models, but obviously do not work so well for full text fields such as descriptions or comments, so I have been thinking of using pg_search for all my searching (don't want to mix and match search solutions if possible) against any text field (names, descriptions, comments etc) and always doing full text searches as I can then search against any text field and get better results. Are there any problems with using full text search in such a manner?
Upvotes: 1
Views: 192
Answers (1)
Lee
Reputation: 8734
OK months later when I have actually used full text, I can safely say you use full text when searching through unstructured text, and SQL LIKE for everything else!
Upvotes: 1
Related Questions
- How do I do full-text searching in Ruby on Rails?
- Proper full text index Rails/PostgreSQL/pg_search
- full-text mysql search in rails
- Ruby on Rails Full Text Search
- Rails Full Text Postgres search: are index in db mandatory?
- PostgreSQL full-text search: how do i scope it?
- Rails: searching with pseudo-relevancy
- Text search in Ruby on Rails
- MySQL full-text search in Rails?
- Rails - What Should I use for Search?