version: '3'
volumes:
  mssql:
  mssqllatin:
  mysql:
  mysql8:
  mysql4.1:
  psql96:
  psql14:
  psql13:
  psql15_load_test_data:
  psql17:
  mariadb:
  cockroachdb:
  oracle18:
  cassandra:
  bigquery:
  firebird:
  mongodb:
  anywhere:
  redis:

services:
  anywhere:
    image: jaschweder/sybase
    platform: linux/amd64
    ports:
      - 2638:2638

  mongodb:
    image: mongo
    platform: linux/amd64
    environment:
      MONGO_INITDB_ROOT_USERNAME: beekeeper
      MONGO_INITDB_ROOT_PASSWORD: example
      MONGO_INITDB_DATABASE: sakila
    volumes:
      - ./dev/docker_mongodb_init:/docker-entrypoint-initdb.d
    ports:
      - 27017:27017

  oracle18:
    image: gvenzl/oracle-xe:18
    platform: linux/amd64
    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-load-test:
    image: postgres:15
    platform: linux/amd64
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: load_test_db
    volumes:
      - psql15_load_test_data:/var/lib/postgresql/data
      - ./dev/docker_psql_load_test_init:/docker-entrypoint-initdb.d
    ports:
      - 5435:5432
    shm_size: 2gb
    command: postgres -c shared_preload_libraries=pg_stat_statements -c max_connections=1000 -c shared_buffers=512MB -c work_mem=16MB

  psql15:
    image: postgres:15
    platform: linux/amd64
    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

  psql17:
    image: postgres:17
    platform: linux/amd64
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: saklia
    volumes:
      - psql17:/var/lib/postgresql/data
      - ./dev/docker_psql_init:/docker-entrypoint-initdb.d
    ports:
      - 5437:5432

  psql14:
    image: postgres:14
    platform: linux/amd64
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: saklia
    volumes:
      - psql14:/var/lib/postgresql/data
      - ./dev/docker_psql_init:/docker-entrypoint-initdb.d
    ports:
      - 5436:5432
  psql13:
    image: postgres:13
    platform: linux/amd64
    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
  trino:
    image: trinodb/trino:latest
    platform: linux/amd64
    ports:
      - "8090:8080"
    volumes:
      - ./dev/docker_trino/catalog:/etc/trino/catalog
    depends_on:
      - psql
      - mysql8
  psql:
    image: postgres:9.6
    platform: linux/amd64
    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
    platform: linux/amd64
    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
    platform: linux/amd64
    command: --default-authentication-plugin=mysql_native_password
    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
    platform: linux/amd64
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: example
      MYSQL_DATABASE: test
    ports:
      - 3306:3306
    volumes:
      - mysql:/var/lib/mysql
      - ./dev/docker_mysql_init:/docker-entrypoint-initdb.d
  mysql4.1:
    image: vettadock/mysql-old:4.1
    platform: linux/amd64
    ports:
      - 3309:3306
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2017-latest-ubuntu"
    platform: linux/amd64
    volumes:
      - mssql:/var/opt/mssql/data
      - ./dev/docker_sqlserver:/docker_init
    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'
    platform: linux/amd64
    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
    platform: linux/amd64
    volumes:
      - cockroachdb:/cockroach/cockroach-data
    ports:
      - 26257:26257
    command: start-single-node --insecure
  cassandra:
    image: cassandra:latest
    platform: linux/amd64
    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
    platform: linux/amd64
    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
    platform: linux/amd64
    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
  clickhouse:
    image: clickhouse/clickhouse-server
    platform: linux/amd64
    ports:
      - 8123:8123
    environment:
      - CLICKHOUSE_USER=username
      - CLICKHOUSE_PASSWORD=password
      - CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1
  redis:
    image: redis:latest
    ports:
      - 6379:6379
    volumes:
      - redis:/data
      - ./dev/docker_redis:/docker_init
    command: sh -c 'redis-server & sleep 3 && /docker_init/data.sh && wait'

  clickhouse25:
    image: clickhouse/clickhouse-server:25.6.1
    ports:
      - 8124:8123
    environment:
      - CLICKHOUSE_USER=username
      - CLICKHOUSE_PASSWORD=password
      - CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1

  surrealdb:
    image: surrealdb/surrealdb:latest
    user: "${SURREAL_UID}"
    command: start --log trace --user root --pass root --allow-all rocksdb:/mydata/surreal.db
    ports:
      - 8000:8000
    volumes:
      - ./surreal_data:/mydata

  surrealdb-seed:
    image: surrealdb/surrealdb:latest
    depends_on:
      - surrealdb
    command: import --conn http://surrealdb:8000 --user root --pass root --ns test --db test /seed.surql
    volumes:
      - ./dev/docker_surrealdb_init/seed.surql:/seed.surql:ro