{"repo":"laowantong/sqlab","free":true,"listed":false,"github":"https://github.com/laowantong/sqlab","clone":"git clone https://github.com/laowantong/sqlab.git","description":"SQL Adventure Builder: transform a dataset and a collection of SQL exercises into a self-contained database","language":"Jupyter Notebook","stars":10,"topics":["database","education","game-engine","games","sql","text-adventure"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLab An SQLab adventure is a text-based game where the player evolves through a series of isolated or interconnected puzzles by crafting SQL queries. It consists in a standalone database encompassing the core dataset, a handful of stored procedures, and a table of encrypted messages (such as narrative elements, puzzle statements, answers, explanations, etc.). There is no requirement to wrap a dedicated application around this database to “run” the game. It can be played on any generic GUI such as DBeaver, phpMyAdmin, pgAdmin, or directly in a command-line interface. Each question comes with a unique formula, for example, salt 042(sum(hash) OVER ()) . Appended to the SELECT clause, this formula calculates a decryption token, which may unlock the next episode or, if the query is incorrect, a tailored hint (assuming the game's creator has provided one). In an educational context, this setup enables the students to learn and practice SQL without constant oversight. The instructor might stave off boredom by logging their queries and injecting new hints as needed, improving the game for all involved. Examples on GitHub Game Pitch Versions DBMS Included --- --- --- --- --- SQLab Island An adaptation of SQL Island by Johannes Schildgen English MariaDB, MySQL, PostgreSQL, SQLite Sources + SQLab database SQLab Sessform A set of independent exercises + Mortelles Sessions , a police investigation on a training company French MySQL, PostgresQL SQLab database SQLab Corbeau An original ada","default_branch":null,"files":null,"tree":[],"storefront":"/r/laowantong","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/laowantong/sqlab/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}