https://pg-capture.onrender.com/

Skip to main content
 
PG-Capture LogoPG-Capture Logo
PG-CaptureDocumentation
GitHub

PG-Capture

Schema-based Change-Data-Capture for Postgres

Table-level event

{
  action: 'INSERT',
  table: 'book',
  data: { 
    id: '1', 
    title: 'The Hobbit', 
    authorId: '2' 
  }
}

Pg-Capture logo 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.

Eventually consistent

Keep Postgres as your primary database and sync complex schemas to
ElasticSearch, Algolia, Redis, or any other data store effortlessly.

Agnostic

PG-Capture is a minimalist utility that lets you use any service to
capture Postgres events (Debezium, WAL-listener...) and can publish
to any provider (RabbitMQ, Redis, ElasticSearch...).

Docs

  * Getting started
  * How does it work?

Socials

  * GitHub