Skip the Queue! Event-Driven Apps for Everyone with Postgres!
summary
Claim: you can skip an external queue for many workflows by using Postgres-native event behavior instead of Kafka/Rabbit. Demo shows Hura/Hyera creating GraphQL/REST APIs, registering Postgres DML triggers and event table captures, and piping JSON CDC rows to HTTP handlers; Postgres sustains ~20,000 TPS in the talk. Tools shown: Postgres triggers + foreign data wrappers (multicorn), Hura’s event processor. Result: a paid→shipped pipeline built with two HTTP handlers that executes and updates rows end-to-end.
AI-written summary · about
chapters (14)
- 0:00Introduction and setup
- 1:06About the speaker and Hasura
- 2:28Embrace boring tech with Postgres
- 3:11What is event-driven programming?
- 4:36Challenges with event-driven systems
- 6:41When to skip the queue
- 7:48Postgres as a queue alternative
- 10:55Event triggers in Postgres
- 13:24Hasura’s event-driven approach
- 15:29Live demo setup
- 16:11Creating instant APIs with Hasura
- 19:00Building event handlers
- 22:53Testing the event flow
- 24:39Summary and takeaways
related talks
23mPostgres as a Message Broker
29mPostgreSQL queues done right with PgQ
48mUsing Asynchronous Message Queues with PostgreSQL
23mRethinking Message Queues: PostgreSQL's Role
30mQueues in PostgreSQL
44mPushy Postgres and Python
43mJust Use Postgres.
44mBuilding a Distributed Queue with Delayed Jobs on PostgreSQL