DEV Community

Cover image for Trigger webhooks on database changes 🛎️ ⚡️
Mitch Patin
Mitch Patin

Posted on

Trigger webhooks on database changes 🛎️ ⚡️

We built an open source tool that brings real-time functionality to Postgres.

Many of the modern database platforms (Firebase, DynamoDB, Hasura, Supabase) offer some pretty awesome features; however, most teams are running their relational databases in AWS RDS (or a similar cloud offering). As a result, they’re left with a few choices: migrate their existing database to a new platform, build these capabilities out internally, or (most commonly) don’t take full advantage of the database.

Our utility for Postgres triggers webhooks when rows are inserted, updated, or deleted. It uses database triggers that send websocket messages to a Go application. This application then calls any configured webhooks with a JSON payload that includes specified values from the database row.

Inquery Data Flow

Use Cases

  • Send notifications: Slack, Email, Text Message, Push Notification
  • Call serverless functions: AWS Lambda, Google Cloud Functions, Azure Functions
  • Trigger analytics events: Segment, Mixpanel, Amplitude
  • Stream data real-time: Snowflake, BigQuery, Clickhouse, Redshift

Thanks for reading! I'd love any feedback or ideas - feel free to reach out!

🐱 Github
🦜 Twitter
🌐 Website
✉️ Email

Top comments (0)