Support unavailable
Please try again later

Seamless integration of Python and PostgreSQL

by Hannu Krosing for EuroPython 2012

Presenting a better way of using PostgreSQL from python with

  • Simple to use way to avoid moving data back and forth to client for just for processing
  • while still maintaining your code in client code and getting all the benefits of server-side programming with ease of Python.
  • access to data without writing SQL for simple usage
  • while SQL is still available where appropriate, like complex data analysis

This is achieved by the following:

  • decorators which ship python code to be executed in database, with potentially 100x speedup for some use cases
  • direct building of query plans bypassing SQL generation and parsing

Some more infrastructure is presented which is needed for using code-shipping in more complex scenarios like django

  • extra import hooks in server for loading python modules from caller (client)
  • extra import hooks for importing modules from database
  • loadatstartup modules for pl/python
  • ways to scale this type of application by sharding (a.k.a. horisontally scaling) it using pl/proxy


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

New comment

60 minutes (inc Q&A)

Tagged as

postgresql nosql django data-analysis sql cloud
Our Sponsors
Python Experts
SSL Matrix
Wanna sponsor?