Re: [GENERAL] Performance PLV8 vs PLPGSQL

I think it's awesome that postgres allows you to code in different languages like this. It really is a unique development environment and one that is overlooked as a development platform.  It would be nice if more languages were delivered in the default package especially lua, V8 and mruby.

On Thu, Dec 29, 2016 at 9:31 PM, Chris Travers <chris.travers@gmail.com> wrote:

My recommendation.  See them as tools in a toolkit, not a question of what is best.

For places where you have SQL statements as primary do SQL or PLPGSQL functions.

For places where you are manipulating values (parsing strings for example) use something else (I usually use pl/perl for string manipulation but ymmv).

PLPGSQL works best where you have a large query and some procedurally supporting logic.  It becomes a lot less usable, performant, and maintainable the further you get away from that.

So there is no best just different tools in a toolkit.