Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

PostgreSQL for Pythonistas

EuroPython Conference via YouTube

Overview

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.

Syllabus

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

Taught by

EuroPython Conference

Reviews

Start your review of PostgreSQL for Pythonistas

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.