Realtime search capability

Hello all, Big fan of Supabase and its philosophy! I wanted to throw an idea out there that might be of use. Most full-text search implemented across various web apps is currently done with Elasticsearch. However, for many simple to moderately-complex use cases this is overkill, and another dependency to learn and maintain for developers. Many don't know that Postgres has powerful full-text search capability on its own with tsvector and other features like trigram indexes. What really got me interested in using Postgres for search was this great article: Here is a relevant quote about the motivation: > Searches were fast but some pages turned out to be slow. This was because the materialized views were recreated by every trigger (create, update, delete) of one entity and building the materialized view could take up to 3 seconds. > ...Since the triggers, and thus the refreshes, are happening in the same transaction as the statement, all create/update/delet…