pg_cron
Run periodic jobs in PostgreSQL (by citusdata)
Faktory
Language-agnostic persistent background job server (by contribsys)
| pg_cron | Faktory | |
|---|---|---|
| 20 | 23 | |
| 2,558 | 5,503 | |
| 2.4% | 1.0% | |
| 5.8 | 7.7 | |
| 9 days ago | 2 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
Faktory
Posts with mentions or reviews of Faktory.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-24.
- Faktory: Language-agnostic persistent background job server
-
Ruby 3.3
Mike Perham (the sidekiq maintainer) also maintains the less well known faktory[0] which is language agnostic and has runners for both Ruby and Python
[0] https://github.com/contribsys/faktory
-
Software Disenchantment
Zen and the Art of Motorcycle Maintenance's entire thesis is "What is Quality?" How do you define it? How does it come about?
You can still get software quality but you have to be willing to devote time and effort to it. The binary for my modern, commercial background job engine written in Go, Faktory, is 5MB in size.
https://github.com/contribsys/faktory/releases/tag/v1.8.0
I know when I see an iOS app that is 5-10MB in size, I know it was crafted by someone who cares.
-
Building a PHP client for Faktory, Part 1
My recent queue foray put me on the scent of Faktory, a language-agnostic queue server made by Sidekiq's author. I noticed there wasn't a good PHP client (the one linked in the docs is pretty old), so I decided to build one.
-
What is the best task queue?
At work we use https://github.com/contribsys/faktory
-
New Gem for background job processing from Ruby/Rails -> Crystal
Have you heard of faktory before? Made by the sidekiq guy and allows you to d a similar thing.
- Are there any actively maintained or official Golang libraries for managing work queues?
-
Celery + RabbitMQ alternatives
I’ve started using Faktory with the Faktory Worker Python it also supports workers in any language.
-
Golang task queue
Try https://github.com/contribsys/faktory which is written in go but you interact with it as a service.
-
What are some popular background job processing frameworks in the Rust ecosystem?
There is faktory, from the author of Sidekiq, which is language-agnostic (the server is written in Go).
What are some alternatives?
When comparing pg_cron and Faktory you can also consider the following projects:
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
gocron - Easy and fluent Go cron scheduling. This is a fork from https://github.com/jasonlvhit/gocron
pg_dbms_job
temporal - Temporal service
pg_background - pg_background
go-quartz - Minimalist and zero-dependency scheduling library for Go
Spring Boot - Spring Boot
Asynq - Simple, reliable, and efficient distributed task queue in Go
docker-pg-cron - Dockerfile with extension pg_cron
Sidekiq - Simple, efficient background processing for Ruby
Express - Fast, unopinionated, minimalist web framework for node.
leprechaun - You had one job, or more then one, which can be done in steps