Postgres Full-Text Search: A Search Engine in a Database
The Postgres Operator easily lets you automate your Postgres in Kubernetes, whether it's one or thousands of instances.
Integrated high availability PostgreSQL solution for enterprises with always on requirements.
Hardened, secure, access controlled PostgreSQL to meet advanced security requirements.
Later on, I worked with a client who wanted search functionality in an app, so “LIKE” and regex weren't going to cut it. What I had known all along was just pattern matching . It works perfectly fine for certain purposes, but what happens when it's not just a matter of checking for a straightforward pattern in a single text field?
For example, what if you wanted to search across multiple fields? How about returning possible matches even if the search term happens to be misspelled? Also, what if you have very large amounts of data to search on? Sure, you can create indexes for columns on which you want to query for pattern matches, but that will have limitations (for instance, the B-tree index doesn't work for col LIKE '%substring%').
