re: Why Use PostgreSQL functions for your application development VIEW POST


There are a lot of advantages to keeping biz logic in the db, but balanced with version control issues and mental context switches.

I like Node a lot, and I find plv8 to be a natural fit. While you don't get cached execution plans, you do get a lot of ease with json manipulation.

Additionally, in some cases you can see massive performance benefits by preventing a round trip to / from the app server.

To make my life even easier, I wrote pgproxy, github.com/claytongulick/pgproxy a little utility that let's you write functions normally in node, but execute them with plv8 on the PG server.

Code of Conduct Report abuse