this is the main branch were u have the clean ready to start template go to roadmap.md to see the current state of this project and were to go from here u have a complete base code section and ready for sql
This project is a hands‑on SQL learning environment built around a real MySQL database running in Docker, with Python as the main “workbench.” The goal is to practice writing raw SQL queries by hand (not hidden behind ORMs), see the results immediately in simple Python scripts, and then expose the same queries through FastAPI routes once they’re ready.
Right now, you have the full foundation in place:
- A MySQL 8.0 container running the classic
worldsample database (withcity,country,countrylanguage). - A working Python environment (venv) with
mysql-connector-python,fastapi,uvicorn, and.env‑based configuration. - A clean
Databasehelper class that lets you rundb.query("FULL SQL HERE", params)and get results back. - A
local/playground inside the project, where each file (inspect_db.py,1_basics.py, etc.) importsdband is ready for you to type full SQL queries and print results. - A FastAPI app skeleton with router files that match the roadmap steps, ready to receive the queries you prove out in the local scripts.
So you’re no longer fighting setup or tooling—you’ve got a working DB, connection code, and local scripts. You’re at the point where you can focus purely on SQL: type queries, run them, inspect the output, and gradually turn them into API endpoints as you progress through the roadmap.