On this episode of "things you didn't know your database could do", we're going to power live updates, real-time notifications, change history, and more from data you already capture.
We'll explore the power of change data capture for turning you database into an event hub for your app. We'll take a look how different databases approach the problem, then dive into PostgreSQL to see it in action. Spoiler: we're going to trick the database into replicating itself to code that we control, making every change in the database available to our app. As crazy as that sounds, it's actually a proven, reliable solution with several tools available to implement it for us. We'll take a look at those too so you can start building database event driven apps today.
By the end of this talk, you'll understand the benefits of change data capture, learn how to implement it through logical replication, and see how to put it into practice in your app to power all your event-driven workflows.