Full text search: Difference between revisions

From Rixort Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 11: Line 11:


== PostgreSQL ==
== PostgreSQL ==
* [https://leandronsp.com/a-powerful-full-text-search-in-postgresql-in-less-than-20-lines A powerful full-text search in PostgreSQL in less than 20 lines]


== Apache Solr ==
== Apache Solr ==

Revision as of 08:51, 6 January 2022

Full text searching in web applications means searching documents which have content and some metadata (usually at least a title). Examples include:

  • Blog posts
  • RSS feed items

MySQL

MySQL and MariaDB have the MATCH operator, which can perform basic full text searches.

Although older versions of MySQL only supported full text indexes on MyISAM tables, this is no longer the case and InnoDB tables can (and should!) be used.

PostgreSQL

Apache Solr