Python for PostgreSQL: how to use it, how to be good at it
Daniele is an Italian hacker currently living in London. Passionate of free-software technologies, he tried out Python and PostgreSQL one afternoon of many years ago and and he is still looking for new ways to make the two collaborate. He has been psycopg2 maintainer since 2010 and he is now implementing psycopg3 to make the best use of modern Python and PostgreSQL versions. When he is not hacking he enjoys to make photography and to play alternative 90's music on the ukulele.
Let's see, with practical examples, how to make Python and PostgreSQL talk to each other seamlessly: how to connect to a server, how to exchange data, manage transactions, passing parameters in a safe and expressive way, how to manage notifications.
We will cover psycopg2, the most used PostgreSQL adapter for Python, but also look and the up and coming psycopg3: what will remain the same, what will change, how to better organise a Python program to make the most of PostgreSQL.