Call Me Back, Postgres

Explore the power of Postgres triggers as an alternative to Rails' Active Record callbacks in this 30-minute RailsConf 2022 talk. Discover how to implement callbacks at the database level using Postgres' trigger functionality, and learn to leverage Postgres' listen and notify features for creative solutions in data syncing and process management. Gain insights into making your Rails app the center of a complex system, seamlessly handling various processes regardless of app consumers. Delve into topics such as defining and applying trigger functions, broadcasting and listening for notifications, using Rails migrations, designing syncing processes, maintaining connections, logging triggers, avoiding continuous trigger loops, and solving edge cases. Walk away with valuable resources and practical knowledge to enhance your Rails application's functionality and efficiency.

Intro
About Me
Main Players
Key Connections
PG Triggers
Define a Function
Apply Trigger Function
PG Notify and Listen
Broadcast a Notification
Listen for Notifications
Using Rails Migrations
Syncing Process Design
Maintaining a Connection
Logging Triggers
Avoiding Continuous Trigger Loops
Selving for Edge Cases
Resources