Python & PostgreSQL, a Wonderful Wedding

FOSDEM 2015

Python and PostgreSQL, two tools we like to use for our projects but do you know everything about them? The talk will give an overview of psycopg2, SQLAlchemy, Alembic and PL/Python, these libraries can be used with PostgreSQL to improve the life of the Python developer.

Python and PostgreSQL, two tools we like to use for our projects but do you know everything about them?

The talk will give an overview of psycopg2, SQLAlchemy, Alembic and PL/Python, these libraries can be used with PostgreSQL.

psycopg2, the well known connector, this basic component is really useful, well documented and battle-tested and used by the most famous toolkits of the Python ecosystem.
SQLAlchemy, a Python SQL toolkit and Object Relational Mapper, you can use this library to create your models and interact with them.
Alembic, a lightweight database migration tool for usage with SQLAlchemy, allows to create some migration scripts for your project.
PL/Python, a procedural language for PostgreSQL, allows to write functions in the Python language.
MultiCorn, a Foreign Data Wrapper in Python

Please note that this talk replaces one entitled "TaskFlow: State Management Framework" which was to have been given by "Vishal Yadav". Regrettably "Vishal Yadav" has withdrawn from the event on account of an illness. We wish him/her a speedy recovery.

Speakers: Stéphane Wirtel