PostgreSQL for Pythonistas

Explore PostgreSQL's advanced features and integration with Python in this 30-minute EuroPython 2013 conference talk. Dive into the history of PostgreSQL and discover why Python is an excellent choice for database programming. Learn about the PL/Python extension, logging techniques, exception handling, and the implementation of triggers and hooks. Examine practical use cases, including message queues with Redis, table creation, and data storage. Gain insights into Multicorn for foreign data wrappers and asynchronous queries in Django. Understand the limitations and explore the vibrant PostgreSQL community with its strong Python support.

Introduction
Who am I
History of PostgreSQL
Python
Why Python
PLL Python Extension
Power of 10
Logging
Raising exceptions
Triggers
Hooks
Use Cases
Limitations
ListenNotify
Message Queue
Wrappers
Redis
Create tables
Redis hash type
Agestore
Data Rapper
Multicorn
Multicorn Example
Multicorn with SQL
Async Queries
Django
PostgreSQL Community
Python Support