docker-compose.yml

version: '3'
volumes:
  mssql:
  mssqllatin:
  mysql:
  mysql8:
  psql96:
  psql13:
  mariadb:
  cockroachdb:
  oracle18:
  cassandra:
  bigquery:
  firebird:

services:

  oracle18:
    image: gvenzl/oracle-xe:18
    environment:
      ORACLE_PASSWORD: example
      ORACLE_DATABASE: sakila
      APP_USER: beekeeper
      APP_USER_PASSWORD: example
    volumes:
      - oracle18:/opt/oracle/oradata
      - ./dev/docker_oracle_init:/docker-entrypoint-initdb.d
    ports:
      - 1521:1521

  psql15:
    image: postgres:15
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: saklia
    volumes:
      - psql13:/var/lib/postgresql/data
      - ./dev/docker_psql_init:/docker-entrypoint-initdb.d
    ports:
      - 5434:5432

  psql13:
    image: postgres:13
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: saklia
    volumes:
      - psql13:/var/lib/postgresql/data
      - ./dev/docker_psql_init:/docker-entrypoint-initdb.d
    ports:
      - 5433:5432
  psql:
    image: postgres:9.6
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: saklia
    volumes:
      - psql96:/var/lib/postgresql/data
      - ./dev/docker_psql_init:/docker-entrypoint-initdb.d
    ports:
      - 5432:5432
  mariadb:
    image: mariadb
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example
      MYSQL_DATABASE: test
    ports:
      - 3307:3306
    volumes:
      - mariadb:/var/lib/mysql
      - ./dev/docker_mysql_init:/docker-entrypoint-initdb.d
  mysql8:
    image: mysql:8.0.21
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example
      MYSQL_DATABASE: test
    ports:
      - 3308:3306
    volumes:
      - mysql8:/var/lib/mysql
      - ./dev/docker_mysql_init:/docker-entrypoint-initdb.d
  mysql:
    image: mysql:5.7.22
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example
      MYSQL_DATABASE: test
    ports:
      - 3306:3306
    volumes:
      - mysql:/var/lib/mysql
      - ./dev/docker_mysql_init:/docker-entrypoint-initdb.d
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2017-latest-ubuntu"
    volumes:
      - mssql:/var/opt/mssql/data
      - ./dev/docker_sqlserver:/docker_init
    restart: always
    environment:
      ACCEPT_EULA: "Y"
      MSSSQL_PID: "Express"
      SA_PASSWORD: "Example@1"
    ports:
      - 1433:1433
    command: sh -c ' chmod +x /docker_init/entrypoint.sh; /docker_init/entrypoint.sh & /opt/mssql/bin/sqlservr;'
  sqlserverlatin:
    image: 'mcr.microsoft.com/mssql/server:2017-latest-ubuntu'
    volumes:
    - mssqllatin:/var/opt/mssql/data
    - ./dev/docker_sqlserver:/docker_init
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: Example@1"
      MSSQL_COLLATION: Latin1_General_CS_AS
      MSSQL_PID: "Express"
    ports:
      - 1434:1433
    command: sh -c ' chmod +x /docker_init/entrypoint.sh; /docker_init/entrypoint.sh & /opt/mssql/bin/sqlservr;'
  cockroachdb:
    image: cockroachdb/cockroach:v22.1.1
    volumes:
      - cockroachdb:/cockroach/cockroach-data
    ports:
      - 26257:26257
    command: start-single-node --insecure
  cassandra:
    image: cassandra:latest
    entrypoint: ["/docker-entrypoint.initdb.d/entry.sh"]
    ports:
      - 9042:9042
    volumes:
      - cassandra:/var/lib/cassandra
      - ./dev/docker_cassandra_init:/docker-entrypoint.initdb.d
# use keyspace; describe tables; # get all the tables for a specific keyspace
# select * from system_schema.keyspaces; # gets all keyspaces
# https://www.folkstalk.com/2022/09/get-all-keyspaces-in-cassandra-with-code-examples.html
# Create keyspace https://www.tutorialspoint.com/cassandra/cassandra_create_keyspace.htm
  bigquery:
    image: ghcr.io/goccy/bigquery-emulator:latest
    volumes:
      - ./dev/docker_bigquery:/data
      - ./dev/docker_bigquery:/docker_init
    ports:
      - 9050:9050
      - 9060:9060
    entrypoint: sh -c 'chmod +x /docker_init/data.sh; /docker_init/data.sh'
  firebird:
    image: jacobalberty/firebird:v4.0.1
    volumes:
      - ./dev/docker_firebird:/docker_init
    ports:
      - 3050:3050
    environment:
      - ISC_PASSWORD=masterkey
      - EnableLegacyClientAuth=true
    command: sh -c 'chmod +x /docker_init/entrypoint.sh; /docker_init/entrypoint.sh & /usr/local/firebird/docker-entrypoint.sh firebird;'
  libsql:
    image: ghcr.io/tursodatabase/libsql-server:latest
    platform: linux/amd64
    ports:
      - 8081:8080
      - 5001:5001
      # environment:
    #   - SQLD_NODE=primary
    # volumes:
    #   - ./dev/docker_libsql:/var/lib/sqld