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…
PG-Capture – a better way to sync Postgres with Algolia (or Elastic) launched on March 1, 2025 with 56 votes, #515 of 7,215 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 1 year on.
In plain words
PG-Capture is a tool that syncs PostgreSQL data with search platforms like Algolia or Elasticsearch by handling complex, multi-table entities. It works alongside change data capture tools like Debezium, aggregating table-level events and reconstructing complete objects from related records across tables. The tool then publishes these as structured domain-level events to message queues such as RabbitMQ or SQS. It's designed for developers who need to index composite entities rather than individual tables.
written from the facts on this page · September 2026
From the sources
Description will go into a meta tag in <head />
{ action : 'INSERT' , table : 'book' , data : { id : '1' , title : 'The Hobbit' , authorId : '2' } } PG-Capture { table : 'book' , schema : { id : 'id' , title : 'title' , author : { type : 'many-to-one' , column : 'authorId' , references : 'author.id' , schema : 'name' , } } } Schema-level event { upsert : [ { id : '1' , title : 'The Hobbit' , author : 'J.R.R. Tolkien' } ] , delete : [ ] , } Getting started Schema-based Write your schema and let PG-Capture aggregate table-level events into high-level events to be used in your application. Keep Postgres as your primary database and sync complex schemas to ElasticSearch, Algolia, Redis, or any other data store effortlessly. PG-Capture is a…from pg-capture.onrender.com
In the maker’s words, at launch
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…
Does a similar job
all alternatives →
ElectricSQL, Postgres to SQLite active-active sync for local-first apps2023 · electric-sql.com · ▲617Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. It's an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser). Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting…
- PSPeerdb Streams – Simple, native Postgres change data capture2024 · ▲177
Hello HN, I am Sai Srirampur, one of the Co-founders of PeerDB. (https://github.com/PeerDB-io/peerdb). We spent the past 7 months building a solid experience to replicate data from Postgres to data warehouses. Now we're expanding to queues. PeerDB Streams provides a simple and native way to replicate changes as they happen in Postgres to Queues (Kafka, Redpanda, Google PubSub, etc). We use Postgres logical decoding to enable Change Data Capture (CDC). Blog post here: https://blog.peerdb.io/peerdb-streams-simple-native-postgres.... 10-min quickstart here:…
PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
PgCat, Postgres pooler with sharding, load balancing and failover2022 · github.com · ▲233PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
Pg_replicate – Build Postgres replication applications in Rust2024 · github.com · ▲216A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl
Bi-directional sync between Postgres and SQLite2023 · powersync.com · ▲356Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 23h ago · permit.petercai.com
- IV
Life & fun · 13d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 14d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 8d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 12d ago · carrierexplode.com
Life & fun · 22d ago · space.bl2.net
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, March 2025
the whole month →
Mimic Human Research & Save Findings in AI Knowledge Base
AI · 2025 · sider.ai
