YeSQL is a new free set of 24 short, runnable PostgreSQL lessons covering SQL foundations, window functions, aggregation, joins, performance, and schema design. Each lesson pairs one concept with an editable, executable query running against real datasets (Formula 1, Chinook, and a custom 'magic' dataset) via PGlite, which runs Postgres compiled to WebAssembly directly in the browser with no signup or server round-trip. It serves as a prototype for making every query in the author's book, The Art of PostgreSQL, runnable inline. The piece also surveys similar PGlite-powered learning tools (Learn PSG, PSQLab, Codapi) and points to a companion Docker-based lab repo with a full local Postgres instance and EXPLAIN visualization.
Table of contents
Why I built itWhat’s coveredTwo lessons worth a lookGood companyRun a real Postgres server locally, with a query UI and EXPLAIN diagramsTry the free sample experienceQuestions this post answers
What is PGlite and how does it let me run PostgreSQL queries in the browser?
PGlite is PostgreSQL compiled to WebAssembly so it can run directly inside a browser tab without a server. Queries execute locally with no signup and no round trip to a backend, which is what powers interactive SQL lessons like YeSQL's 24 runnable examples against real datasets such as Formula 1 and Chinook data. daily.dev surfaces tools like PGlite for developers exploring browser-based database experimentation.
What are some free resources for learning practical SQL with real datasets instead of toy examples?
YeSQL offers 24 free runnable PostgreSQL lessons organized into SQL foundations, window functions, aggregation, joins, performance, and schema design, using real datasets like Formula 1 and a music-store schema. PGExercises offers a long, exercise-first problem set using a fictional country club dataset. Learn PSG and PSQLab are newer PGlite-based tutorials covering core SQL and pgvector. Developers comparing SQL learning resources can track new tools like these through daily.dev.