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 | 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 (coming soon) |
| SQLab Club | An adaptation of PostgreSQL Exercises by Alisdair Owens | English | PostgreSQL | Sources + SQLab database (coming later) |
| SQLab Corbeau | An original adaptation of the movie Le Corbeau by Henri-Georges Clouzot (1943) | French | MySQL | SQLab database (coming later) |
How can I create my own SQLab adventure?
The sqlab command-line tool is not required to play, but is necessary to create a new adventure.
pip install sqlab
The documentation is not yet available. In the meantime, you may explore the repository of SQLab Island. The provided dataset and Jupyter notebooks serve as source material for the generation of the SQLab database.
1 maintainer
Metadata
1 maintainer
Release files for sqlab 0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlab-0.tar.gz | 35.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlab-0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 81.3 kB
Release files / sqlab-0.tar.gz
| Download URL | sqlab-0.tar.gz |
|---|---|
| Size | 35.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
4030f0c90fdf0330deb54607421e98aa7702050f3382790800e28db900253e8e
|
|
BLAKE2b-256 checksum How to use checksums |
9c30209d353133a5609041d355efc7bb7c440939995b45b75458dedb44a72dc7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.3.2 CPython/3.9.13 Darwin/21.6.0
|
Release files / sqlab-0-py3-none-any.whl
| Download URL | sqlab-0-py3-none-any.whl |
|---|---|
| Size | 45.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
51fa98c751f992fb52b1faaac2e538d79f7d3c739e6a56f46aad90050fb79099
|
|
BLAKE2b-256 checksum How to use checksums |
8234452ccf924f2222dbe24e16d07e9f8f226a86dc1955feb125cc1d8cba37a1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.3.2 CPython/3.9.13 Darwin/21.6.0
|
