PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform. PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has powerful add-ons such as the popular PostGIS geospatial database extender. It is no surprise that PostgreSQL has become the open source relational database of choice for many people and organizations.
Decodable + Postgres
Decodable can output to a Postgres database as a sink. To use Postgres as a source you'll need to use the Postgres CDC (Change Data Capture) connector which converts table changes into a stream of change records. Decodable is a convenient way to populate Postgres tables with data sourced from a range of source systems including messaging systems such as Kafka, a REST API or a CDC source. Decodable transports the data and provides a SQL-based transformation to ensure that the data arrives at Postgres for ingestion in an optimized form.
In this video series, we show how to ingest data via Postgres CDC, process it on the Decodable platform, and load it back into Postgres and other external systems.