<--- Back to all connectors

PostgreSQL

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. Streamkap can connect to PostgreSQL by connecting to a replication slot, which in turn looks at PostgreSQL publications. By reading the PostgreSQL change logs, real-time change data capture has less impact on your database while allowing you to sync your data in real-time to support your use cases.

Add Connector
View Documentation

The PostgreSQL Destination connector supports idempotent write operations by using upsert semantics and basic schema evolution

The PostgreSQL Destination connector supports idempotent write operations by using upsert semantics and basic schema evolution.

The following features are supported:

  • Consuming complex Debezium change events
  • At-least-once delivery
  • Multiple tasks
  • Data and column type mappings
  • Primary key handling
  • Delete mode
  • Idempotent writes
  • Schema evolution
  • Quoting and case sensitivity

‍

Marcin Migda

Staff Data Engineer

"Streamkap was 4x faster and had 3x lower total cost of ownership than our previous solution"

Why Streamkap?

Reliable

Serverless platform providing enterprise reliability and scale.

Affordable

Only pay for GB into Streamkap.

Longterm

Retain data for as long as you need.

Flexible

Read once, write to many destinations.

Explore more connectors

DuckDB

DuckDB is a fast, embeddable, and open-source analytical database. It can run on a local machine, embedded in an application or in the cloud and excels at complex SQL queries on various file formats (like CSV and Parquet), and integrates seamlessly with languages like Python and R.

Explore more
Destination

MotherDuck

MotherDuck is DuckDB in multiplayer mode. A serverless data warehouse with all the power of DuckDB and the scale of the cloud. Streamkap supports MotherDuck as a destination.

Explore more
Destination

DynamoDB

DynamoDB is a serverless, NoSQL database service from Amazon that enables you to develop modern applications at any scale. DynamoDB is scalable, fast and flexible. Streamkap can connect to via DynamoDB streams for real-time change data capture. For historical data, Streamkap uses DynamoDB’s S3 export feature for cost-efficient backfilling of data.

Explore more
Source
Explore All Connectors