Postgres Full-Text Search: A search engine in a database
I used Postgres full-text search for mail log feature on my email forward app <a href="https://hanami.run" rel="nofollow">https://hanami.run</a><p>Essentially allow arbitraty query in from/to/subject/body. One thing that make full-text serch work great for me is that I don't need to sort or rank the relevant of query. I just show a list of email that match the query order by their id.<p>I also don't do pagination and counting, instead users has to load more paged and the ID of the email is pass to the query as a point to compare( where id < requests.get.before).<p>And with those strategy, full text search works great for us since we don't really want to bring in ElasticSearch because only about 20% of users use this features.