job – select * from depesz;

How can I send mail or HTTP request from database?

This question happens every now and then in one of PostgreSQL support places.

Whenever it happens, I just suggest to not try, as interacting with outside world from database can be problematic, and instead use LISTEN/NOTIFY.

But it occurred to me, that while I know how to do it, I don't think I actually did it. It being: handle listen/notify in real life code. So let's try. I will not be writing actual email sending or http requesting, but will make sure that my program will get, from database, information when NOTIFY happens. How hard could it be?

Continue reading How can I send mail or HTTP request from database?

How to run some tasks without user intervention, at specific times? – part 2

Couple of days earlier I wrote about tools to run tasks in db at scheduled times.

In writing this I missed pg_cron. So let's look into it now.

Continue reading How to run some tasks without user intervention, at specific times? – part 2

How to run some tasks without user intervention, at specific times?

Every now and then someone complains (me included) that PostgreSQL doesn't have job scheduler.

This is true, to some extent. I'll try to show you couple of approaches to solving this particular problem.

Continue reading How to run some tasks without user intervention, at specific times?

=$
|

Tag: job

How can I send mail or HTTP request from database?

How to run some tasks without user intervention, at specific times? – part 2

How to run some tasks without user intervention, at specific times?