News for hackers. Stuff that matters.

A comment on PgCompute: New PostgreSQL Client-Side Extension for Database Functions.

Re:PgCompute: New PostgreSQL Client-Side Extension for Datab... by franckpachot on Thursday September 07, 2023 @11:15AM (#37420171)
This is incredibly awesome. When Oracle started to talk about Javascript in the database (around 2016), with GraalVM and MLE, it was clear for me that the goal was not to deploy stored procedures in Javascript but, at some point have the JS function called in the application and transparently run close to data. They will probably go there but that will take time.

I'm so happy to see this idea in Open Source with PostgreSQL! The best of both worlds: defined the business logic in the app but run it close to data for performance.

[ Parent | on HN ]
Re:PgCompute: New PostgreSQL Client-Side Extension for Datab... by magden on Thursday September 07, 2023 @11:18AM (#37420214)
Yeap, that was the main reason for building this client-side extension/module - so that we, developers, can execute the functions from the application source and our preferred IDEs.
[ Parent | on HN ]