LearnPG

LearnPG is a browser-based PostgreSQL learning platform that runs an actual Postgres engine inside your browser tab. Instead of connecting to a remote server or installing anything locally, the database executes right where you are, grading your queries instantly as you work through exercises.

The setup it replaces is familiar to anyone who has tried to learn SQL. Normally you'd spin up a local Postgres instance or connect to a sandbox server, write queries in a separate client, and flip between docs and terminal to check your work. LearnPG collapses that into one place. You read the lesson, write a query in the editor, run it, and see whether you got it right without context switching.

Under the hood it uses WebAssembly to compile PostgreSQL for the browser, which means you're running real Postgres syntax and behavior, not a simplified subset. Queries that would work on a production database work here, and queries that would fail there fail here the same way. That makes the feedback loop closer to real work than tools that only simulate SQL.

It's built for beginners and intermediate learners who want hands-on practice without DevOps overhead. If you're picking up Postgres for the first time, it gets you running queries in seconds. If you already know some SQL but want to cement specific topics like joins, window functions, or CTEs, you can drill those exercises without setting up test data yourself.

What makes it different from other SQL trainers is the engine choice. Many interactive SQL courses run SQLite or a proprietary interpreter because it's lighter to embed. LearnPG bets that running real Postgres is worth the extra weight because the syntax, error messages, and edge cases match what you'll see in production. That matters if you're learning Postgres specifically rather than generic SQL.

The platform appears to be free. There's no mention of paid tiers, subscriptions, or gated content on the landing page. Because everything runs client-side, there's no server cost per user, which probably makes a free model sustainable. If you need a certificate or structured curriculum beyond the exercises, you'll have to look elsewhere, but for raw practice with immediate feedback, it does the job.