PostGIS and Stored Functions in… Python?
This week, I had the oppourtunity to work with Schuyler in writing stored procedures in Postgres/PostGIS for the first time.
At first, we were writing in plpgsql, but found it didn’t suit our needs… and switched to Python.
Yes, Python. Our database now has stored procedures which decode a cPickle pickle structure from a column (go go unstructured data) and return the output of a key/value pair (based on the key).
It was a very weird thing to see this actually work.