/plushcap/analysis/supabase/postgres-as-a-cron-server

Postgres as a CRON Server

What's this blog post about?

Postgres, a powerful open-source relational database management system, can be extended to function as a cron server using the pg_cron extension. This allows users to schedule periodic tasks within their Postgres database, such as triggering webhooks at fixed times or intervals. The process involves enabling the extension and granting access to non-superuser roles for scheduling jobs. Additionally, another extension called pgsql-http can be used for sending HTTP requests from Postgres functions. This combination of features makes Postgres a versatile tool for managing various types of scheduled tasks.

Company
Supabase

Date published
March 5, 2021

Author(s)
Paul Copplestone

Word count
1199

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.