Overview
Explore advanced database programming techniques with Python in this 31-minute EuroPython Conference talk. Delve into the Python DB-API 2.0 interface for popular database backends, focusing on production-relevant topics such as locks, distributed transactions, and transaction isolation. Learn about common transaction mistakes, best practices, and how to handle transactions across multiple databases. Discover techniques for concurrent database access, query optimization for performance and complexity, and strategies for high availability and failover. Gain insights into OLTP vs. OLAP databases, record ID creation, and result set scrolling. Master schema introspection and the handling of multiple result sets to enhance your database programming skills with Python.
Syllabus
Intro
Concepts of the Python DB-API 2.0
Transactions: Common Mistakes
Transactions: Best Practices
Transactions across Databases
Distributed Transactions
Concurrent Database Access
Transaction Isolation: Typical Levels
Optimized Databases: OLTP vs. OLAP
Query Optimizations: Performance
Query Optimizations: Complexity
Tips & Tricks: Record ID Creation
Tips & Tricks: High Availability
High Availability: Failover
Thank you for listening
Taught by
EuroPython Conference