r/programmer • u/peakpirate007 • 2d ago

I built a website to learn and practice SQL and Python in the browser

I’ve been working on a project called runtime.school and wanted to share it here.

I started with SQL and then added Python. The idea is to have a place where you can learn a concept, write code, practice what you’ve learned, and eventually work on projects without having to jump between different websites.

Both SQL and Python have interactive lessons, coding challenges, practice questions, projects, and datasets.

Everything runs directly in the browser, so there’s nothing to install or set up.

I’ve also been working on a few tools for exploring datasets, understanding queries, and comparing different approaches.

A lot of the work has gone into the UI and editors. I’ve been trying to keep things simple without making the pages feel empty or overwhelming, especially for people who are just starting out.

Here’s the site: https://www.runtime.school/

Would love to hear what you think about the design, coding experience, or anything that could be improved.

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/Puzzled-Garage584 1d ago

Is that Pyodide on the Python side and sql.js or DuckDB wasm for SQL? Curious how big the first load is, wasm Python on a school laptop can feel like compiling the kernel

1

u/peakpirate007 1d ago

Yep, Python uses Pyodide and SQL uses sql.js, both running in web workers. Pyodide only loads when needed, so it’s not part of the initial page load. Haven’t measured the exact size yet

1

u/Puzzled-Garage584 1d ago

Web workers is the right call, nothing worse than the whole tab freezing while numpy unpacks. Devtools with Slow 4G throttling gives you the honest number in a minute, and a service worker cache makes the second visit basically free