Demo datasets

SQLite datasets

Sakila

Inside the container on the path /mixql/samples/db/sakila.db is a port of the Sakila training database for SQLite. (Note: Data about the film_text table is not provided in the script files, thus the film_text table is empty. Instead the film_id, title and description fields are included in the film table.)

docker run -it --rm --name demo  \
    mixql/demo:0.4 \
    sqlite3 /mixql/samples/db/sakila.db

of via docker compose:

docker compose run demo sqlite3 /mixql/samples/db/sakila.db

Expected result

########################################################
** Entrypoint for mixql-platform-demo-0.4.0-SNAPSHOT
** Executing 'sqlite3 /mixql/samples/db/sakila.db'
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> select count(1) from actor;
200
sqlite> .quit

Titanic

In this repository on path samples/db/titanic.db is a popular dataset "titanic" from kaggle in .db format from davidjamesknight

docker run -it --rm --name demo  \
    -v "/$(pwd)/samples/db/:/mixql-host/samples/db"     \
    mixql/demo:0.4 \
    sqlite3 /mixql-host/samples/db/titanic.db

of via docker compose:

docker compose run demo sqlite3 /mixql-host/samples/db/titanic.db

Expected result

########################################################
** Entrypoint for mixql-platform-demo-0.4.0-SNAPSHOT
** Executing 'sqlite3 /mixql-host/mixql/db/titanic.db'
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> select count(1) from Observation;
891
sqlite> .quit