Postgres has built-in Full Text Search which we can use instead of cobbling together our own with like. Postgres can do some basic searching using select and comparison tools like like. The LIKE operator as used in the query above will match only the term "Avengers%". For our experiments we'll use SQLite FTS5 and TypeSense TypeSense.
Table of contents
Search Engines: The Next GenerationA whirlwind tour through FTS in PostgresA working Postgres FTS setupComparable FTS enginesTesting our FTS solutionsAutomating our toilResultsWhat does the data tell us?Feedback from the other productsWrap-upMore Postgres resources1 Comment
Sort: