Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover strategies for achieving near-zero downtime migrations in PostgreSQL using Python in this conference talk. Learn how to overcome the challenge of modifying large-scale database structures without significant service interruptions. Explore the latest improvements in PostgreSQL 9.4, including logical replication, and see how they can be leveraged alongside Python scripting with psycopg to minimize downtime during migrations. Gain insights into techniques being developed at orderbird for handling tables with millions or billions of records efficiently. Understand the advantages of SQL databases and how to mitigate their structural modification challenges in long-running projects.