Amazing SQL your ORM can (or can't) do | PGConf EU 2019 | Louise Grandjonc

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
October 17, 2019

Amazing SQL your ORM can (or can't) do | PGConf EU 2019 | Louise Grandjonc

SQL can seem like an obscure and complex but powerful language. Learning it can be intimidating. As a developer, we can easily be tempted using basic SQL provided by the ORM. But did you know that you can use window functions in some ORMs? Same goes for a lot of other fun SQL functionalities.

In this talk we will explore some advanced SQL features that you might find useful. We will discover the wonderful world of joins (lateral, cross…), subqueries, grouping sets, window functions, common table expressions.

But most importantly this talk is not only a talk to show you how great SQL is. This talk is here to show you how to use it in real life. What are the features supported by your ORM? And how can you use them if they don’t support them?

Wether you know SQL or not, whether you are a developer or a DBA working with developers, you might learn a lot about SQL, ORMs, and application development using Postgres.


Citus Data

October 17, 2019