Stream your PostgreSQL changes in minutes - Kafka Debezium Alternative
Kafka and Debezium could be a beast to set up. Try this alternative!
This video shows:
(1) how to replicate data from Postgres and create a real-time data pipeline
(2) how to capture every change event from your source and see in your target what the change events are: insert vs update vs delete.
🍺 If you've learned something new from this video, buy me a coffee to support this channel =)
https://bmc.link/jennyman
🏄🏻♂️ If you're interested in Surfshark, sign up via this link for an exclusive discount and free months:
https://get.surfshark.net/aff_c?offer...
Chapters:
0:00 Intro
1:20 How to replicate data from Postgres
7:35 Break
8:47 How to capture every change event from Postgres
In this demo, we use a PostgreSQL database as our source, and Google Sheet as our target.
PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard and offers many modern features:
complex queries
foreign keys
triggers
updatable views
transactional integrity
multi-version concurrency control
Also, PostgreSQL can be extended by the user in many ways, for example by adding new
data types
functions
operators
aggregate functions
index methods
procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic.
#data #postgres #postgresql #datapipeline