dinsdag 15 april 2014

Why I like PostgreSQL more than MySQL: fulltext search.

Yes, I  know MySQL has fulltext search too, but it's functionality is limited to doing a boolean search.

In PostgreSQL you get access to a much more usefull set of features, such as dictionaries that allow stemming (also finding 'swim' when you search for 'swimming') filtering stopwords, mathing on word proximity, etc.

For a practical implementation of a so-called "good enough" search engine in pure PostgrSQL, see this blogpost: http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/?utm_source=dbweekly&utm_medium=email