At the moment, Python is one of the most used programming languages in the world. It offers a nice set of characteristics to complement PostgreSQL. For example, if you need to write a relatively simple utility script, whose complexity extends beyond what you can easily do using Bash with psql, or you want to integrate your pre-existing database using an external system, or you want to write a fully production grade web service: chances are that Python might be a good tool to use. This is thanks to both its simple syntax and its wide range of libraries to choose from, to interact with external systems.
In this talk, we will take a look at the current techniques we can use to make Python and PostgreSQL speak to each other. We will explore how we can run simple queries, avoid the dangers of SQL injections, make the most of the rich type systems that the two technologies offer, deal with asynchronous messages and so on!
The talk will take into consideration psycopg2, the current industry standard module, which allows Python to interact with PostgreSQL. We will also take a look at the up and coming psycopg3 module, which is designed to make use of the functionalities available in the latest Python releases and communicate with the database in the most efficient way.
Registrations for Postgres London 2021 are open. Register now to reserve your spot.
WHERE: Virtual Event WHEN: Wednesday | May 12, 2021