test_db

test_db is a repository and a Docker image with various example databases:

MySQL
PostgreSQL
- World
- Pagila
MongoDB
- Monila (converted from Pagila)

They can be used for example, tests, etc.

Docker image is build on top of busybox to make it explorable. It also exposes /test_db as a volume that can be mounted into MySQL/PostgreSQL/MongoDB containers for initializing databases on start-up. See docker-compose.yml for examples and images documentation for docker-entrypoint-initdb.d initialization scripts.

Changelog

v1.2.1 - 2021-11-26

The same as 1.2.0 but with linux/arm64/v8 variant.

v1.2.0 - 2021-10-20

Updated MySQL databases:
- World and World X from September 2016 to December 2019;
- Sakila from 1.0 to 1.2:
  - files were renamed to 01-sakila-schema.sql and 02-sakila-data.sql to make them compatible with the official mysql Docker image's initialization scripts.
- datacharmer/test_db a.k.a. Employees to 1.0.7;
Updated PostgreSQL databases:
- Pagila from 0.10.1 to 2.1.0:
  - files were renamed to 01-pagila-schema.sql and 02-pagila-data.sql to make them compatible with the official postgres Docker image's initialization scripts;
  - pagila-insert-data.sql was removed as it contained the same data as (02-)pagila-data.sql;
  - please note that Sakila and Pagila databases have small differences, most notably in dates;
Added MongoDB Monila database:
- Converted from Pagila by a script in this repository.

v1.1.0 - 2019-06-13

Added PostgreSQL databases: World and Pagila.

v1.0.0 - 2018-02-21