This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

Learning advanced SQL the weird (and hard) way

Date: 2023-12-14
Time: 13:40–14:30
Room: Zenit

Have you ever tried your hand at Advent of Code, the annual online coding challenge that takes place during the holiday season? It's a fun and challenging way to test your coding skills and get into the holiday spirit. But what if we told you that there were ways to solve the problems using only SQL?

In this talk, I will explain my experience trying to solve the advent of Code challenges with SQL only (Postgres flavor). My rules, what I learned, the hard parts, the easy parts, my tips, and my tricks (should you want to try it yourself) but overall how much it enlightened my use of Postgres and SQL.

Whether you're a seasoned Advent of Code veteran or a newcomer to the challenge, whether your SQL skills are basic or advanced, I hope that attendees will come away with a newfound appreciation for the power and flexibility of SQL, as well as some ideas for how to incorporate them into their own coding practices.


This session has been made available on:


The following slides have been made available for this session:


Lætitia AVROT