sqlalchemy-dlock/db.docker-compose.yml at main · tanbro/sqlalchemy-dlock · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# run mysql, postgres, and mssql database service on local docker, for develop/test

name: sqlalchemy-dlock-db

services:
  mysql:
    image: mysql
    ports:
      - "127.0.0.1:3306:3306"
    environment:
      MYSQL_RANDOM_ROOT_PASSWORD: "1"
      MYSQL_DATABASE: test
      MYSQL_USER: test
      MYSQL_PASSWORD: test

  postgres:
    image: postgres:alpine
    ports:
      - "127.0.0.1:5432:5432"
    environment:
      POSTGRES_PASSWORD: test

  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    ports:
      - "127.0.0.1:1433:1433"
    environment:
      MSSQL_SA_PASSWORD: "YourStrongPassword123"
      MSSQL_PID: "Developer"
      MSSQL_TCP_PORT: "1433"
      ACCEPT_EULA: "Y"
    # Note: MSSQL container requires at least 2GB RAM to run properly

  oracle:
    image: container-registry.oracle.com/database/free:latest
    ports:
      - "127.0.0.1:1521:1521"
    environment:
      ORACLE_PASSWORD: "YourStrong@Passw0rd"
    # Note: Oracle Free container requires at least 2GB RAM to run properly
    #
    # IMPORTANT: Oracle Database Free (23c/23ai) does NOT support DBMS_LOCK.REQUEST
    # which is required for distributed lock functionality. This is a known
    # limitation of the Free/Express edition.
    #
    # For production use, a full Oracle Database (Enterprise/Standard Edition)
    # is required. Use a self-hosted runner or cloud database service.
    #
    # Connection string: oracle+oracledb://sys:YourStrong@Passw0rd@127.0.0.1:1521/?service_name=FREEPDB1