pg_cron
cadence
pg_cron | cadence | |
---|---|---|
21 | 19 | |
2,575 | 7,881 | |
3.1% | 1.8% | |
5.8 | 9.7 | |
16 days ago | 4 days ago | |
C | Go | |
PostgreSQL License | MIT License |
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
-
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
cadence
- Show HN: Hatchet – Open-source distributed task queue
-
Ask HN: Who is hiring? (December 2023)
Uber | Software Engineers | Hybrid (Denmark) | https://www.uber.com/dk/en/careers/locations/aarhus/
Work with an amazing team responsible for the infrastructure software that makes Uber’s data centers around the world reliable and scalable. If you want to solve the toughest engineering challenges alongside some of the smartest people in the industry, Uber Aarhus is the right place for you.
The team in Aarhus build and operate the stateless and stateful compute platforms used by nearly every other engineer in the company (Up - https://www.uber.com/en-GB/blog/up-portable-microservices-re... and Odin - https://www.uber.com/en-GB/blog/how-uber-optimized-cassandra...) as well as other related infrastructure projects such as Cadence - https://github.com/uber/cadence.
- Cadence – Fault-Tolerant Stateful Code Platform by Uber
-
Best way to schedule events and handle them in the future?
May be this..https://cadenceworkflow.io/
- Mandala: experiment data management as a built-in (Python) language feature
-
are you interested in an end to end queue/pubsub & worker platform
a managed esb orchestration for example is exactly same as step functions and workflow engines like cadence - https://github.com/uber/cadence
-
Why messaging is much better than REST for inter-microservice communications
Having done a reasonable amount of messaging code in my time, I would say the final form of this sort of thing might look more like Cadence[0] than anything like this.
[0] https://github.com/uber/cadence
-
cadence VS javactrl-kafka - a user suggested alternative
2 projects | 2 Feb 2023
- Fault-Tolerant Stateful Code Platform
-
[P] My co-founder and I quit our engineering jobs at AWS to build “Tensor Search”. Here is why.
Emit events from your primary DB (postgres, etc.) to something like kafka or rabbitmq and then catch that in your search engine. There's also some end-to-end solutions like temporal (temporal.io) or cadence (https://cadenceworkflow.io/)
What are some alternatives?
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
temporal - Temporal service
pg_dbms_job
Flowable (V6) - A compact and highly efficient workflow and Business Process Management (BPM) platform for developers, system admins and business users.
pg_background - pg_background
gocelery - Celery Distributed Task Queue in Go
Spring Boot - Spring Boot
Asynq - Simple, reliable, and efficient distributed task queue in Go
docker-pg-cron - Dockerfile with extension pg_cron
docker-compose - Temporal docker-compose files
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.
Faktory - Language-agnostic persistent background job server