flh-raouf/td-bdd

BDD SQL Revision is a local web application built for students at the Higher National School of Computer Science in Algiers to practice SQL assignments from their databases course. It contains 26 exercises drawn directly from material given by the course professors, covering both creating database tables from scratch and writing queries to retrieve and analyze data. The exercises are built around a fictional Algerian mobile operator called DZTelecom, which has eight tables covering customers, subscriber phone lines, recharge events, services, usage records, mobile plans, plan features, and plan sign-ups. This gives students a realistic schema to work with rather than a toy example, and all 26 exercises are grounded in that same dataset. The interface includes a code editor with SQL syntax highlighting and autocompletion. You write a query, click Submit, and the app compares your results against the expected output by checking column names, row counts, and data values. It does not do simple text matching, so different valid ways of writing the same query can still pass. If your answer is wrong, you get specific feedback about what differs: which columns are off, how many rows are missing or extra, and any MySQL errors. Each exercise also has two or three progressive hints you can unlock, and the solution is available once you need it. There is also a table browser to explore the schema and a sandbox mode where you can run any SQL you want against the live local database without it being graded. Your progress is saved in browser storage so completed exercises stay marked across sessions. To run it, you need Docker (for the MySQL database), the Bun runtime, and a few setup commands to start the database, install packages, load the seed data, and launch the app. The whole stack runs locally on your machine on ports 3000 and 3001.