pg_cron
Run periodic jobs in PostgreSQL (by citusdata)
pg_timetable
pg_timetable: Advanced scheduling for PostgreSQL (by cybertec-postgresql)
| pg_cron | pg_timetable | |
|---|---|---|
| 20 | 7 | |
| 2,558 | 1,018 | |
| 2.4% | 1.2% | |
| 5.8 | 7.8 | |
| 10 days ago | 9 days ago | |
| C | Go | |
| PostgreSQL License | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_cron
Posts with mentions or reviews of pg_cron.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-09.
-
Supabase Beta May 2023
[Postgres Extensions] pg_cron 1.5.2 (new projects only) now supports sub-minute schedules. PR
-
🏺Database Architecture - History Over State
(Your PostgreSQL installation might already have pg_cron available, but if not, you would need to install it)
- Edge Functions or Database Functions?
-
Upgrading to PostgreSQL 15 on Mac OS
I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.
-
PostgreSQL Functions in Typescript
Functions can be executed via a database query or on a regular schedule. Trigger functions are a special type of function that are covered in a previous article. They provide a way to execute an action based on a database event.
-
Pulling Cloud API data to PostgreSQL server (Supabase)
* extraction and loading: the psql-http PostgreSQL extension which is available in Supabase (but not all services like AWS RDS). Not sure how it works with OAuth but something to look into. * automation: use pg_cron to automate the ingest. * transformation: leverage Postgresql JSON functions.
- How to : trigger a MV refresh after another MV refreshed ?
-
Is it conventional to use Redis in an authentication service?
A low-level alternative is using a PostgreSQL-side facility like https://github.com/citusdata/pg_cron - this, however, requires installing a PostgreSQL extension.
- Como agendar execução de consultas e comandos pelo PostgreSQL no RDS
-
Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL
If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron
pg_timetable
Posts with mentions or reviews of pg_timetable.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-08-29.
-
Do I need to keep maintaining the partitions?
That's easily done with a cron job or something similar (e.g. pg_timetable)
- pg_timetable: Advanced Scheduling for PostgreSQL
-
PG_DBMS_JOB – An Open Source PostgreSQL extension for Oracle DBMS_JOB compatibility
When you are working on Oracle to PostgreSQL migrations, one of the Oracle packages that cause conversion issues is DBMS_JOB. Traditionally, we used extensions like : pg_agent, pg_cron or more recently pg_timetable for scheduling jobs. All of these tools or extensions use a cronjob like scheduling method which does not give a full compatibility of the features provided by Oracle DBMS_JOB. Translating calls to DBMS_JOB.SUBMIT() into a cron setting is more painful than being impossible when there is an execution interval lesser than a minute. There are several such DBMS_JOB compatibility issues including asynchronous scheduling which is not possible with the already existing extensions in PostgreSQL. MigOps hates to stay without Open Source solutions. So, we are announcing PG_DBMS_JOB extension for Oracle DBMS_JOB compatibility, released under PostgreSQL License. An interesting point here is that we have included full compatibility of Oracle DBMS_JOB in PG_DBMS_JOB PostgreSQL extension.
-
pgAgent install on Windows failing.
If you don't want to (or can't) use the Windows Scheduler, you might want to try out pg_timetable instead, which also offers Windows binaries.
- How to launch a thread/job from PL/pgSQL or otherwise from inside of the database?
-
Postgres as a Cron Server
Try pg_timetable
-
How to send email notifications with event triggers on PostgreSQL?
You better send emails periodically with cron-like scheduler. This one can do both cron and periodical jobs: https://github.com/cybertec-postgresql/pg_timetable
What are some alternatives?
When comparing pg_cron and pg_timetable you can also consider the following projects:
pg_dbms_job
pg_background - pg_background
groupcache - groupcache is a caching and cache-filling library, intended as a replacement for memcached in many cases.
Spring Boot - Spring Boot
prometheus - The Prometheus monitoring system and time series database.
docker-pg-cron - Dockerfile with extension pg_cron
jaeger - CNCF Jaeger, a Distributed Tracing Platform
Express - Fast, unopinionated, minimalist web framework for node.
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
pgweb - Cross-platform client for PostgreSQL databases