pg_background
pg_cron
Our great sponsors
| pg_background | pg_cron | |
|---|---|---|
| 2 | 20 | |
| 130 | 2,545 | |
| - | 3.9% | |
| 5.1 | 6.1 | |
| 6 months ago | 5 days ago | |
| C | C | |
| GNU General Public License v3.0 only | PostgreSQL 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_background
- Pg_later: Asynchronous Queries for Postgres
-
How to launch a thread/job from PL/pgSQL or otherwise from inside of the database?
There is an extension which seems to be able to do that though.
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
What are some alternatives?
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
postgresml - The GPU-powered AI application database. Get your app to market faster using the simplicity of SQL and the latest NLP, ML + LLM models.
pg_dbms_job
Spring Boot - Spring Boot
docker-pg-cron - Dockerfile with extension pg_cron
Express - Fast, unopinionated, minimalist web framework for node.
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.
redroid-doc - redroid (Remote-Android) is a multi-arch, GPU enabled, Android in Cloud solution. Track issues / docs here
Visual Studio Code - Visual Studio Code
machinery - Machinery is an asynchronous task queue/job queue based on distributed message passing.
Pandas - Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more