Can postgresql use console apps for calculations?

Question

I need to calculate a value for each row in my database. The calculation is quite involved, requiring lookup tables and parameters that are stored in the database too.

Now I know I can write an app, connect to the server, and calculate the value for each row - which is what I am doing now.

But is it also possible to do it the other way round? Namely, have the postgresql server pass the required info to a console app and receive the value to store? In which case you could have PostgreSQL automatically calculate the value each time a new row is inserted.

@Marc: Quite possibly - but what does that have to do with the question??? — Markus Winter, May 17 '23 at 09:01
@Ken: Triggers is how the calculation would be initiated - but the problem is not "how to set up a trigger" but "HOW do I get the calculation (which is done in the Console app) to run from PostgreSQL and return the value to it"? — Markus Winter, May 17 '23 at 09:04

score 0 · Answer 1 · answered May 17 '23 at 09:51

For This, We can use the NOTIFY and LISTEN commands in Postgres. This allows notifications to be sent to clients who are Listening and are connected to the database. So you can create a channel in your application for listening and create a trigger on insert and notify the value and the client in this case the console app to do something.

This is a good article I found how we can do this you can refer to it here

Can postgresql use console apps for calculations?

1 Answers1