Å·±¦ÓéÀÖ

pgDay Paris 2019 presentation: How to write SQL queries?

The videos from are online, and
they look stunning! If you’ve been to the conference, you will be able to
enjoy great memories, and if you’ve not been there, you can now enjoy all
the fine content that was recorded there at the .



This year at pgday Paris I tried something new. My presentation was
interactive, and I’ve been writing queries together with the audience,
making mistakes, loosing keystrokes and having all the fun!



The idea behind looking like a fool writing queries in front of an audience
was to show the process behind those elegant queries that we tend to share
in one piece, on a slide where they shine, beautifully indented. We don’t
get to those queries writing them like we would prose. It takes multiple
iterations to get there. From something quite simple to something more and
more sophisticated, until we have exactly the result set we are interested
in.



 •  0 comments  •  flag
Published on December 25, 2019 13:15
No comments have been added yet.