Get the latest tech news

How to run cron jobs in Postgres without extra infrastructure


I had the pleasure to spend nearly 3 years working on live video infrastructure at TV2 Norway. As you know, when it comes to infrastructure, time IS money. Everything needs to be just-in-time, especially when it comes to provisioning costly components like encoders. For example, if there's a major live sports match scheduled, you want to ensure the streaming infrastructure is set up just minutes before kickoff, and torn down shortly after the final whistle blows.

For example, if there's a major live sports match scheduled, you want to ensure the streaming infrastructure is set up just minutes before kickoff, and torn down shortly after the final whistle blows. But sometimes you're just working on your trusty little Node app, and all you really need is something simple — like sending a daily reminder to users about today's coding challenge. Profile settings page with email summary toggle As we've seen, scheduling doesn't have to mean spiraling into infrastructure complexity — especially when you're looking for a lightweight solution.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Photo of cron jobs

cron jobs

Photo of extra infrastructure

extra infrastructure

Related news:

News photo

Show HN: PgDog – Shard Postgres without extensions

News photo

Postgres with data branching and PII anonymization

News photo

The fastest Postgres inserts