What is the industry-standard way to sync Postgres with a search index like Meilisearch? WAL logical decoding or db triggers?
Generally the question is what is the best way to synchronize postgres with a search index (meilisearch or typesense in this case), and specifically, the question is why choose to use WAL logical decoding with replication for real-time synchronization, vs. keeping physical decoding and simply making a database trigger.