# PyConFr 2018

DevFeed: [PyConFr 2018](<https://devfeed.tech/articles/pyconfr-2018-34661.md>)

Original publisher: [Read original article](<https://tapoueh.org/conf/pyconfr-2018/>)

Published: 2018-10-06T22:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Back end](<https://devfeed.tech/topics/backend.md>), [Python](<https://devfeed.tech/topics/python.md>), [integrity](<https://devfeed.tech/topics/integrity.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [integrity](<https://devfeed.tech/tags/integrity.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [processing](<https://devfeed.tech/tags/processing.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A PyConFr 2018 talk about using advanced SQL and PostgreSQL for application backends, including deciding which backend logic belongs in the database and which is easier to write as a SQL query.

## Source excerpt

Python is often used to maintain application backends. When the backend should implement user oriented workflows, it may rely on a RDBMS component to take care of the system's integrity. PostgreSQL is the world's most advanced open source relational database, and is very good at taking care of your system's integrity. PostgreSQL also comes with a ton of data processing power, and in many cases a simple enough SQL statement may replace hundreds of lines of code written in Python. In this talk, we learn advanced SQL techniques and how to reason about which part of the backend code should be done in the database, and which parf of the backend code is so easier to write as a SQL query.