Back To Schedule
Wednesday, June 24 • 10:45am - 11:30am
The Art of PostgreSQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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.

avatar for Dimitri Fontaine

Dimitri Fontaine

PostgreSQL Major Contributor, Citus Data, Microsoft
Dimitri Fontaine is a PostgreSQL Major Contributor (Extensions, Event Triggers, etc) and maintains pgloader, your migration companion (see https://pgloader.io). Dimitri has authored “Mastering PostgreSQL in Application Development”, the book that teaches SQL to developers, available... Read More →

Wednesday June 24, 2020 10:45am - 11:30am EDT