The Art of PostgreSQL | PostgresOpen 2019 | Dimitri Fontaine

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
September 13, 2019

The Art of PostgreSQL | PostgresOpen 2019 | Dimitri Fontaine

Applications nowadays are written with the help of many programming languages. 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, Java, PHP, Ruby, Javascript, you name it.

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 part of the backend code is better written as an SQL query.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

September 13, 2019
Tweet