Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic)

Re:Show HN: PG-Capture – a better way to sync Postgres with ... by srameshc on Tuesday March 04, 2025 @12:07PM (#43257366)

Thanks for sharing, even though I don't use Algolia or Elastic but I love the idea of tracking Postgres Triggers and sending it to the queue and sending wherever you need it. Brilliant !!

[ Parent | on HN ]

Re:Show HN: PG-Capture – a better way to sync Postgres with ... by nick-keller on Tuesday March 04, 2025 @01:45PM (#43258486)

Thanks! Syncing PG to another data store like Algolia or Elastic is just a very common use case that I use to pitch the idea. But Change-Data-Capture can be used for much more: emitting events when data changes, transforming data, caching data...

All of those use cases are really painful with raw table-level events.

[ Parent | on HN ]

Re:Show HN: PG-Capture – a better way to sync Postgres with ... by MarekDlugos on Tuesday March 04, 2025 @06:43PM (#43260960)

What do you use for search then? Out of curiosity.

[ Parent | on HN ]

Re:Show HN: PG-Capture – a better way to sync Postgres with ... by nick-keller on Wednesday March 05, 2025 @01:41AM (#43263585)

Today I use PG-Sync to index things in MeiliSearch and to populate cache in production.

[ Parent | on HN ]