What language do you use for PostgreSQL triggers and stored procedures? *

Question

PostgreSQL is interesting in that it supports several languages for writing stored procedures. Which one do you use, and why?

Answer

Skype uses PostgreSQL together with python, and they have improved PL/Python to it's current state so I would doubt that python support is far behind perl. They have written queuing/replication system on top of those bindings, after all :-) Take a look: http://wiki.postgresql.org/wiki/Skytools

From a quick look in documentation, python seems to have less documentation than perl bindings, but I would suggest to just stick with language you are most comfortable with.

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/1970/" >What language do you use for PostgreSQL triggers and stored procedures?< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.