Advent of SQL

👋 Maker here! Really excited to share this project with the Product Hunt community. The idea sparked when I was diving deep into learning databases recently and I thought "what if we had something similar to advent of code, but focused purely on SQL?" There's something oddly satisfying about solving puzzles with just SQL - it's like solving a puzzle where you have to describe the solution rather than build it. Some fun details about the project: • Each puzzle has a test case to validate your solution • The challenges range from "morning coffee" difficulty to "okay, I need to draw this one out" • All puzzles are tested against PostgreSQL, but the solutions should work in most SQL databases I'll be around all day to answer questions, chat about the challenges, or geek out about databases in general. Would love to hear what kinds of SQL puzzles interest you most! P.S. For the curious devs - I built this using Elixir/LiveView, which turned out to be perfect. The whole thing is surprisingly snappy! 😊

Great way to increase your SQL skills. Difficulty depends on what experience you already have and used to work with (e.g. if you parse XLM every day or just once every 5 years :-))

Really great project! I've been doing the challenges every day, and the difficulty is just right. I'm learning a few new concepts (XML parsing, Array Types / parsing) - and the instructions make it really easy to get setup and tackle the challenges! The User Experience for importing the data is great! I'm one to typically fumble with psql commands, but each exercise makes it clear how to get started. And there's a sample dataset provided.

Good daily tasks for learning (PostGreSQL) SQL.