EuroPython 2014 - Advanced Database Programming
The Python DB-API 2.0 provides a direct interface to many popular database backends. It makes interaction with relational database very straight forward and allows tapping into the full set of features these databases provide.
This talk covers advanced database topics which are relevant in production environments such as locks, distributed transactions and transaction isolation. We also give advice on how to deal with common problems you face when working with complex database systems.
Talk Video
This talk was given at EuroPython 2014 in Berlin,Germany, by Marc-André Lemburg, CEO of eGenix.com.
Mr. Lemburg is available as Python coach and consultant, if you would like to get on-site help with your database projects.
Talk Agenda
Introduction to the Python DB API 2.0
Concepts of the Python DB-API 2.0
Database Connections: Connection objects
Database Queries: Cursor objects
Transactions
Transactions: Common Mistakes
Transactions: Best Practices
Transactions across Databases
Distributed Transactions
Two-Phase Commit APIs
Concurrent Database Access
Transaction Isolation (Introduction)
Transaction Isolation: Typical Levels
Transaction Isolation: Python APIs
Optimized Databases: OLTP vs. OLAP
Query Optimizations: Performance
Query Optimizations: Complexity
Tips & Tricks: Record ID Creation
Record ID Creation: Using the database
Record ID Creation: In Python
Tips & Tricks: Referential Contraints
Referential Contraints: Using the database
Referential Contraints: In Python
Tips & Tricks: High Availability
High Availability: Failover using the database
High Availability: Failover in Python
Talk Slides
The talk slides are available as PDF file:
Using the Talk Video Player
For the best viewing experience, please select 1080p HD quality by clicking on the small gear icon and then switch to full-screen mode by clicking on the rectangular bracket icon on the lower right side of the player.
(c) Copyright 2014 eGenix.com. All Rights Reserved.