Science Score: 44.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (6.6%) to scientific vocabulary
Repository
An SQLab adaptation of SQL Island
Basic Info
- Host: GitHub
- Owner: laowantong
- License: cc-by-sa-4.0
- Language: Jupyter Notebook
- Default Branch: main
- Homepage: https://github.com/laowantong/sqlab
- Size: 3.74 MB
Statistics
- Stars: 3
- Watchers: 2
- Forks: 1
- Open Issues: 0
- Releases: 7
Metadata Files
README.md
🏝 SQLab Island
Credits
This is an adaptation of SQL Island, a simple game designed to teach SQL, distributed under the MIT License on GitHub by its main author, Johannes Schildgen (Regensburg University of Applied Sciences, Germany).
The original game was adapted by Aristide Grange (University of Lorraine, France) to demonstrate the use of SQL Adventure Builder, or SQLab, a system enabling teachers to create standalone educational games for learning SQL. This system lives in a separate repository with the explanation of its principles.
Versions
To play SQLab Island, you just need to download a dump of the self-contained database and import it into your favorite SQL database management system (DBMS). There are currently three versions, all of them in English:
MySQL
- Download dump.sql (right-click and "Save link as...").
- On the command line, create a new database called
sqlab_island, populate it and connect to it:bash read -p "Username: " USERNAME mysql -u "$USERNAME" -p < dump.sql mysql -u "$USERNAME" -p sqlab_island - On the MySQL prompt, access the first episode of the adventure:
sql SELECT decrypt(42)
MariaDB
- Download dump.sql (right-click and "Save link as...").
- On the command line, create a new database called
sqlab_island, populate it and connect to it:bash read -p "Username: " USERNAME mariadb -u "$USERNAME" -p < dump.sql mariadb -u "$USERNAME" -p sqlab_island - On the MariaDB prompt, access the first episode of the adventure:
sql SELECT decrypt(42)
PostgreSQL
- Download dump.sql (right-click and "Save link as...").
- On the command line, create a new database called
sqlab_island, populate it and connect to it:bash read -p "Username: " USERNAME psql -U "$USERNAME" -f dump.sql psql -U "$USERNAME" sqlab_island - On the PostgreSQL prompt, access the first episode of the adventure:
sql SELECT decrypt(42)
SQLite
- Install
sqlpkg. - On the command line, install the required SQLite extensions:
bash sqlpkg install nalgeon/crypto sqlpkg install nalgeon/define sqlpkg install nalgeon/regexp sqlpkg install nyurik/compressions - Download dump.sql (right-click and "Save link as...").
- On the command line, launch SQLite:
bash sqlite3 - On the SQLite prompt, load the required extensions, read the dump and access the first episode of the adventure:
sql .load /path/to/.sqlpkg/nalgeon/crypto/crypto .load /path/to/.sqlpkg/nalgeon/define/define .load /path/to/.sqlpkg/nalgeon/regexp/regexp .load /path/to/.sqlpkg/nyurik/compressions/libsqlite_compressions .read dump.sql SELECT * FROM decrypt(42)
Disclaimer and potential issues
The present adaptation of SQL Island includes a few changes in the game's content to be compatible with SQLab. Any bug or problem is the sole responsibility of the adapter, and should be reported in the issues of SQLab itself.
Owner
- Name: Aristide
- Login: laowantong
- Kind: user
- Location: Metz, France
- Company: Université de Lorraine
- Repositories: 3
- Profile: https://github.com/laowantong
Citation (CITATION.cff)
# This CITATION.cff file was generated with cffinit.
# Visit https://bit.ly/cffinit to generate yours today!
cff-version: 1.2.0
title: SQLab Island
message: >-
If you use this dataset, please cite it using the metadata
from this file.
type: dataset
authors:
- given-names: Aristide
family-names: Grange
email: aristide.grange@univ-lorraine.fr
affiliation: 'LCOMS EA7306, Université de Lorraine, Metz, France'
orcid: 'https://orcid.org/0000-0001-5777-4603'
repository-code: 'https://github.com/laowantong/sqlab_island'
repository: 'https://github.com/laowantong/sqlab'
license: CC-BY-SA-4.0
date-released: '2024-03-03'
GitHub Events
Total
- Release event: 1
- Watch event: 3
- Push event: 24
- Pull request review event: 2
- Pull request event: 2
- Fork event: 1
- Create event: 1
Last Year
- Release event: 1
- Watch event: 3
- Push event: 24
- Pull request review event: 2
- Pull request event: 2
- Fork event: 1
- Create event: 1
Issues and Pull Requests
Last synced: 12 months ago
All Time
- Total issues: 0
- Total pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Total issue authors: 0
- Total pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 0
- Pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Issue authors: 0
- Pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
Pull Request Authors
- Dracaukwak (1)