Support unavailable
Please try again later

pl/python now as powerful as C

by Hannu Krosing for

Until now some of the extensibility of PostgreSQL was reserved for C-langauge extensions only, as no PL-language (postgreSQLs “pluggable languages") could be used to create functions with most “pseudo types” - notably cstring and internal - which are required for things like type input output function, full-text search pre-processors and some more esoteric support functions for query optimisation.

In this talk I describe the support for types ‘cstring’ and ‘internal’ I am developing for pl/python in upcoming postgreSQL v9.3 version together with some examples of what new extensibility features of postgreSQL can now be easily developed in python.

As an example a pl/python wrapper for BSON binary objects is shown allowing you to store and index BSON (that is the only native datatype in MongoDB) objects and use them together with standard SQL types and PostgreSQL extension types in your SQL queries, taking full advantage of PostgreSQLs superior query optimization features.

in on Wednesday 3 July at 12:15 See schedule

Do you have some questions on this talk? Leave a comment to the speaker!

New comment

45 minutes (inc Q&A)

Tagged as

postgresql nosql database mongodb sql bigdata pl/python optimization pl/pythonu databases Full Text Search
Our Sponsors
Python Experts
SSL Matrix
Wanna sponsor?