Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic) https://ift.tt/KpnO4Q3

Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic) Hello HN! Keeping Elasticsearch or Algolia in sync with Postgres is a pain when your data spans multiple tables. Traditional CDC tools like Debezium capture table-level events but don’t help when you need to index a full entity composed of related records. That's why I built PG-Capture. PG-Capture lets you define a schema as complex as you need, aggregate table-level events, and reconstruct structured objects spanning multiple tables. It then publishes them as meaningful domain-level events to any queue (RabbitMQ, SQS, etc.). PG-Capture does NOT replace Debezium, it works on top of it (or any other event source). This keeps it flexible and tool-agnostic. I'd love to hear your thoughts! Does this solve a problem you've run into? Would you use something like this in your stack? Feedback is welcome! https://ift.tt/EYPbkZz March 1, 2025 at 04:18PM