pg_cron: Cron-Jobs direkt in der Datenbank / Cron jobs directly in the database geoobserver.de/2026/09/22/p... via @crunchydata #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
September 22, 2026 at 7:18 AM
pg_cron: Cron-Jobs direkt in der Datenbank / Cron jobs directly in the database geoobserver.de/2026/09/22/p... via @crunchydata #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
PostgreSQL: Nicht nur eine Datenbank?! / Not just a database?! geoobserver.de/2026/09/24/p... #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
September 24, 2026 at 7:22 AM
PostgreSQL: Nicht nur eine Datenbank?! / Not just a database?! geoobserver.de/2026/09/24/p... #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
We’re excited to release pg_incremental today - a new extension for automated incremental updates. pg_incremental is like a supercharged pg_cron that runs data pipelines, data syncs, rollups, imports and exports.
www.crunchydata.com/blog/pg_incr...
www.crunchydata.com/blog/pg_incr...
pg_incremental: Incremental Data Processing in Postgres | Crunchy Data Blog
We are excited to release a new open source extension called pg_incremental. pg_incremental works with pg_cron to do incremental batch processing for data aggregations, data transformations, or import...
www.crunchydata.com
December 17, 2024 at 4:39 PM
We’re excited to release pg_incremental today - a new extension for automated incremental updates. pg_incremental is like a supercharged pg_cron that runs data pipelines, data syncs, rollups, imports and exports.
www.crunchydata.com/blog/pg_incr...
www.crunchydata.com/blog/pg_incr...
PgQue – Zero-bloat #Postgres #queue. One #SQL file to install. Requires pg_cron.
#PostgreSQL
#OpenSource Apache 2.0 lic
github.com/NikolayS/pgque
#PostgreSQL
#OpenSource Apache 2.0 lic
github.com/NikolayS/pgque
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. - NikolayS/pgque
github.com
April 21, 2026 at 7:31 PM
PgQue – Zero-bloat #Postgres #queue. One #SQL file to install. Requires pg_cron.
#PostgreSQL
#OpenSource Apache 2.0 lic
github.com/NikolayS/pgque
#PostgreSQL
#OpenSource Apache 2.0 lic
github.com/NikolayS/pgque
Great to see this ability for "creating processing pipelines for append-only streams of data...We believe it is a foundational building block for building IoT applications on PostgreSQL that should be available to everyone, similar to pg_cron, pg_parquet, and pg_partman."
We’re excited to release pg_incremental today - a new extension for automated incremental updates. pg_incremental is like a supercharged pg_cron that runs data pipelines, data syncs, rollups, imports and exports.
www.crunchydata.com/blog/pg_incr...
www.crunchydata.com/blog/pg_incr...
pg_incremental: Incremental Data Processing in Postgres | Crunchy Data Blog
We are excited to release a new open source extension called pg_incremental. pg_incremental works with pg_cron to do incremental batch processing for data aggregations, data transformations, or import...
www.crunchydata.com
January 2, 2025 at 9:48 AM
Great to see this ability for "creating processing pipelines for append-only streams of data...We believe it is a foundational building block for building IoT applications on PostgreSQL that should be available to everyone, similar to pg_cron, pg_parquet, and pg_partman."
#geoObserver - pg_cron: Cron-Jobs direkt in der Datenbank by geoobserver
https://geoobserver.de/2026/09/22/pg_cron-cron-jobs-direkt-in-der-datenbank/
https://geoobserver.de/2026/09/22/pg_cron-cron-jobs-direkt-in-der-datenbank/
September 22, 2026 at 6:35 AM
#geoObserver - pg_cron: Cron-Jobs direkt in der Datenbank by geoobserver
https://geoobserver.de/2026/09/22/pg_cron-cron-jobs-direkt-in-der-datenbank/
https://geoobserver.de/2026/09/22/pg_cron-cron-jobs-direkt-in-der-datenbank/
Well well well: www.crunchydata.com/blog/pg_incr...
Incremental pipelines come to Postgres via Crunchy Data! This is like "dbt incremental", not true incremental view maintenance like @materialize.com or Snowflake's dynamic tables, but it's a neat step towards IVM.
Incremental pipelines come to Postgres via Crunchy Data! This is like "dbt incremental", not true incremental view maintenance like @materialize.com or Snowflake's dynamic tables, but it's a neat step towards IVM.
December 19, 2024 at 5:08 AM
Well well well: www.crunchydata.com/blog/pg_incr...
Incremental pipelines come to Postgres via Crunchy Data! This is like "dbt incremental", not true incremental view maintenance like @materialize.com or Snowflake's dynamic tables, but it's a neat step towards IVM.
Incremental pipelines come to Postgres via Crunchy Data! This is like "dbt incremental", not true incremental view maintenance like @materialize.com or Snowflake's dynamic tables, but it's a neat step towards IVM.
Working on a little project and thought I could use dbt to create some downstream tables.
Just discovered pg_cron, and you know what? Using that instead of dbt is just one less dependency!
Just discovered pg_cron, and you know what? Using that instead of dbt is just one less dependency!
June 20, 2025 at 5:00 AM
Working on a little project and thought I could use dbt to create some downstream tables.
Just discovered pg_cron, and you know what? Using that instead of dbt is just one less dependency!
Just discovered pg_cron, and you know what? Using that instead of dbt is just one less dependency!
PostgreSQLベースのqueue実装。message queueというよりはKafkaに近い実装と。
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. - NikolayS/pgque
github.com
April 29, 2026 at 12:13 PM
PostgreSQLベースのqueue実装。message queueというよりはKafkaに近い実装と。
Some scheduled jobs don't need a separate worker, crontab, or K8s CronJob. If the work is already SQL, PostgreSQL can run it with pg_cron. Iyiola shows you how to schedule cleanup jobs, refresh materialized views, build rollup tables, manage permissions, & more.
www.freecodecamp.org/news/how-to-...
www.freecodecamp.org/news/how-to-...
June 20, 2026 at 4:01 AM
Some scheduled jobs don't need a separate worker, crontab, or K8s CronJob. If the work is already SQL, PostgreSQL can run it with pg_cron. Iyiola shows you how to schedule cleanup jobs, refresh materialized views, build rollup tables, manage permissions, & more.
www.freecodecamp.org/news/how-to-...
www.freecodecamp.org/news/how-to-...
It ships ready to run with:
🔹 pg_cron
🔹 pg_stat_statements
🔹 auto_explain
🔹 PostGIS
🔹 pg_trgm
Backfilled historical data + ongoing workload included.
One command and you’re up.
🔹 pg_cron
🔹 pg_stat_statements
🔹 auto_explain
🔹 PostGIS
🔹 pg_trgm
Backfilled historical data + ongoing workload included.
One command and you’re up.
February 16, 2026 at 8:00 PM
It ships ready to run with:
🔹 pg_cron
🔹 pg_stat_statements
🔹 auto_explain
🔹 PostGIS
🔹 pg_trgm
Backfilled historical data + ongoing workload included.
One command and you’re up.
🔹 pg_cron
🔹 pg_stat_statements
🔹 auto_explain
🔹 PostGIS
🔹 pg_trgm
Backfilled historical data + ongoing workload included.
One command and you’re up.
Simples e prático.
Continuo escrevendo o README, mas basicamente: uso Supabase Edge Functions, disparo com pg_cron, cache no Upstash.
Continuo escrevendo o README, mas basicamente: uso Supabase Edge Functions, disparo com pg_cron, cache no Upstash.
September 26, 2024 at 7:44 PM
Simples e prático.
Continuo escrevendo o README, mas basicamente: uso Supabase Edge Functions, disparo com pg_cron, cache no Upstash.
Continuo escrevendo o README, mas basicamente: uso Supabase Edge Functions, disparo com pg_cron, cache no Upstash.
#Durable, #fault-tolerant, long running #tasks inside #PG to make tasks more reliable when #workflow mostly lives inside #Postgres. Instead of #pg_cron. For #pipelines like Ingestion, Embeddings, etc.
#OpenSource #PostgreSQL license
github.com/microsoft/pg...
#OpenSource #PostgreSQL license
github.com/microsoft/pg...
GitHub - microsoft/pg_durable: PostgreSQL in-database durable execution
PostgreSQL in-database durable execution. Contribute to microsoft/pg_durable development by creating an account on GitHub.
github.com
June 7, 2026 at 10:51 PM
#Durable, #fault-tolerant, long running #tasks inside #PG to make tasks more reliable when #workflow mostly lives inside #Postgres. Instead of #pg_cron. For #pipelines like Ingestion, Embeddings, etc.
#OpenSource #PostgreSQL license
github.com/microsoft/pg...
#OpenSource #PostgreSQL license
github.com/microsoft/pg...
Something I've always found pride in is making developer tooling more accessible. You won't find many that think Postgres isn't powerful, but navigating it can be overwhelming. Scheduled jobs in a database aren't a "new thing", pg_cron has long been around but it wasn't always "friendly".
March 26, 2025 at 6:31 PM
Something I've always found pride in is making developer tooling more accessible. You won't find many that think Postgres isn't powerful, but navigating it can be overwhelming. Scheduled jobs in a database aren't a "new thing", pg_cron has long been around but it wasn't always "friendly".
Someone mapped Claude Code's 5 layers: memory, skills, hooks, subagents, plugins. I built 4 by accident, debugging my own personal OS for 6 months. Master Context file every agent reads. pg_cron firing hooks from inside Postgres. Turns out that's just systems design. #buildinpublic #devtools
July 16, 2026 at 10:00 AM
Someone mapped Claude Code's 5 layers: memory, skills, hooks, subagents, plugins. I built 4 by accident, debugging my own personal OS for 6 months. Master Context file every agent reads. pg_cron firing hooks from inside Postgres. Turns out that's just systems design. #buildinpublic #devtools
Some engineers love using the wrong tool for right task.
pg_cron is scheduled work inside Postgres: nightly cleanups, expiring rows, refreshing views. No network hop. While
Edge Functions handles event-driven work that reaches out: webhooks, APIs, emails.
#Postgres #Supabase
pg_cron is scheduled work inside Postgres: nightly cleanups, expiring rows, refreshing views. No network hop. While
Edge Functions handles event-driven work that reaches out: webhooks, APIs, emails.
#Postgres #Supabase
August 26, 2026 at 11:21 AM
TIL: Postgres has a builtin cron daemon called pg_cron. Learn something new everyday.
June 7, 2025 at 8:30 PM
TIL: Postgres has a builtin cron daemon called pg_cron. Learn something new everyday.
How does the differ from the pg_cron extension that was previously suggested to use with supabase?
December 6, 2024 at 5:16 PM
How does the differ from the pg_cron extension that was previously suggested to use with supabase?
PgQue – PgQ, universal edition
Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. github.com/NikolayS/pgque
Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. github.com/NikolayS/pgque
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. - NikolayS/pgque
github.com
April 19, 2026 at 9:50 AM
PgQue – PgQ, universal edition
Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. github.com/NikolayS/pgque
Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. github.com/NikolayS/pgque
Phoenix and Postgres is a fantastic combo
Postgres
🚀 DB
🚀 Vector search
🚀 NoSQL
🚀 Background jobs (pg_cron)
🚀 Full text search
🚀 Queue. (when using unlogged tables)
Phoenix
🔥 background jobs with genservers
🔥 channels for realtime
🔥 liveview
🔥 and more..
Postgres
🚀 DB
🚀 Vector search
🚀 NoSQL
🚀 Background jobs (pg_cron)
🚀 Full text search
🚀 Queue. (when using unlogged tables)
Phoenix
🔥 background jobs with genservers
🔥 channels for realtime
🔥 liveview
🔥 and more..
October 1, 2025 at 4:30 PM
Phoenix and Postgres is a fantastic combo
Postgres
🚀 DB
🚀 Vector search
🚀 NoSQL
🚀 Background jobs (pg_cron)
🚀 Full text search
🚀 Queue. (when using unlogged tables)
Phoenix
🔥 background jobs with genservers
🔥 channels for realtime
🔥 liveview
🔥 and more..
Postgres
🚀 DB
🚀 Vector search
🚀 NoSQL
🚀 Background jobs (pg_cron)
🚀 Full text search
🚀 Queue. (when using unlogged tables)
Phoenix
🔥 background jobs with genservers
🔥 channels for realtime
🔥 liveview
🔥 and more..
𝗩𝗜𝗕𝗘 𝗖𝗛𝗘𝗖𝗞: Positive
"Discovering pg_cron as Dependency-Free Alternative to dbt for Downstream Table Creation"
"Discovering pg_cron as Dependency-Free Alternative to dbt for Downstream Table Creation"
June 20, 2025 at 5:00 AM
𝗩𝗜𝗕𝗘 𝗖𝗛𝗘𝗖𝗞: Positive
"Discovering pg_cron as Dependency-Free Alternative to dbt for Downstream Table Creation"
"Discovering pg_cron as Dependency-Free Alternative to dbt for Downstream Table Creation"
"This extension helps you create processing pipelines for append-only streams of data, such as IoT / time series / event data workloads."
Nice! Not IVM, but should be enough for quite a few use cases.
Nice! Not IVM, but should be enough for quite a few use cases.
pg_incremental: Incremental Data Processing in Postgres | Crunchy Data Blog
We are excited to release a new open source extension called pg_incremental. pg_incremental works with pg_cron to do incremental batch processing for data aggregations, data transformations, or import...
www.crunchydata.com
December 19, 2024 at 12:42 AM
"This extension helps you create processing pipelines for append-only streams of data, such as IoT / time series / event data workloads."
Nice! Not IVM, but should be enough for quite a few use cases.
Nice! Not IVM, but should be enough for quite a few use cases.
PgQue: Zero-Bloat Postgres Queue | Discussion
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. - NikolayS/pgque
github.com
April 18, 2026 at 11:00 PM
PgQue: Zero-Bloat Postgres Queue | Discussion
After almost a year, Sabeo is back online.
It’s my small Wordle-inspired word game, in Spanish.
Some updates:
• Switched from a Golang cron to pg_cron on Supabase
• New ranking system
• The code is now on GitHub: github.com/kristiandrex...
You can play it here: sabeo.kristiandrex.com
It’s my small Wordle-inspired word game, in Spanish.
Some updates:
• Switched from a Golang cron to pg_cron on Supabase
• New ranking system
• The code is now on GitHub: github.com/kristiandrex...
You can play it here: sabeo.kristiandrex.com
Sabeo
Descubre la palabra en el menor tiempo posible
sabeo.kristiandrex.com
December 11, 2025 at 12:05 AM
After almost a year, Sabeo is back online.
It’s my small Wordle-inspired word game, in Spanish.
Some updates:
• Switched from a Golang cron to pg_cron on Supabase
• New ranking system
• The code is now on GitHub: github.com/kristiandrex...
You can play it here: sabeo.kristiandrex.com
It’s my small Wordle-inspired word game, in Spanish.
Some updates:
• Switched from a Golang cron to pg_cron on Supabase
• New ranking system
• The code is now on GitHub: github.com/kristiandrex...
You can play it here: sabeo.kristiandrex.com
PgQue: Zero-Bloat Postgres Queue
https://github.com/NikolayS/pgque
https://news.ycombinator.com/item?id=47817349
https://github.com/NikolayS/pgque
https://news.ycombinator.com/item?id=47817349
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick. - NikolayS/pgque
github.com
April 19, 2026 at 5:15 AM
PgQue: Zero-Bloat Postgres Queue
https://github.com/NikolayS/pgque
https://news.ycombinator.com/item?id=47817349
https://github.com/NikolayS/pgque
https://news.ycombinator.com/item?id=47817349