Since it is inception, psycopg2 allowed seamless communication between Python and PostgreSQL. But after 15 years and numerous evolutions of both PostgreSQL and Python, a new challenge approached the project: How do we embrace the new ways of doing things while maintaining a stable codebase?

The answer? psycopg3. A unique occasion to rewrite the library without having to worry about backward compatibility.

This talk will go over all the hard design decisions that came with it:

• What do we keep the same or radically change?
• How do we make the migration from 2 to 3 as painless as possible?