pg_cron
Run periodic jobs in PostgreSQL (by citusdata)
machinery
Machinery is an asynchronous task queue/job queue based on distributed message passing. (by RichardKnop)
| pg_cron | machinery | |
|---|---|---|
| 20 | 14 | |
| 2,558 | 7,313 | |
| 2.4% | - | |
| 5.8 | 5.3 | |
| 10 days ago | 10 days ago | |
| C | Go | |
| PostgreSQL License | Mozilla Public License 2.0 |
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
machinery
Posts with mentions or reviews of machinery.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-24.
- Looking for library recommendations: Django -> Golang port
-
Are there any actively maintained or official Golang libraries for managing work queues?
I've had this project starred for a while but haven't used it: https://github.com/RichardKnop/machinery
- Looking for a mature distributed task queuer/scheduler in go
- What would be a good message broker internal to my program?
-
Golang task queue
I had a look at: 1. machinery - https://github.com/RichardKnop/machinery 2. go-celery - https://github.com/gocelery/gocelery 3. asynq - https://github.com/hibiken/asynq 3. taskq - https://github.com/vmihailenco/taskq
-
is there any go library that allows running background tasks after a specified period of time?
you mean a scheduler? try RichardKnop/machinery or hibiken/asynq
-
Using a High-Level RabbitMQ Client in Go
I use this one: https://github.com/RichardKnop/machinery
-
Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL
I’ve also used https://github.com/RichardKnop/machinery for for a few projects and it’s solid.
- Distributed asynchronous tasks?
-
Any one knows a job worker project (like Celery) + distributed cron written in Go
Machinery is an asynchronous task queue/job queue based on distributed message passing.
What are some alternatives?
When comparing pg_cron and machinery you can also consider the following projects:
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
Asynq - Simple, reliable, and efficient distributed task queue in Go
pg_dbms_job
gocelery - Celery Distributed Task Queue in Go
pg_background - pg_background
celery - Distributed Task Queue (development branch)
Spring Boot - Spring Boot
go-nsq - The official Go package for NSQ
docker-pg-cron - Dockerfile with extension pg_cron
temporal - Temporal service
Express - Fast, unopinionated, minimalist web framework for node.
Confluent Kafka Golang Client - Confluent's Apache Kafka Golang client