build: Run all supported versions of MySQL / PostgreSQL

kyleconroy · kyleconroy · commit 067bb17eef2e · 2023-07-14T12:30:33.000-07:00
MySQL 5.7, 8.0
PostgreSQL 11, 12, 13, 14, 15
diff --git a/docker-compose.yml b/docker-compose.yml
@@ -10,6 +10,16 @@ services:
       MYSQL_ROOT_PASSWORD: mysecretpassword
       MYSQL_ROOT_HOST: '%'
 
+  mysql5:
+    image: "mysql/mysql-server:5.7"
+    ports:
+      - "3305:3306"
+    restart: always
+    environment:
+      MYSQL_DATABASE: mysql
+      MYSQL_ROOT_PASSWORD: mysecretpassword
+      MYSQL_ROOT_HOST: '%'
+
   postgresql:
     image: "postgres:15"
     ports:
@@ -19,3 +29,43 @@ services:
       POSTGRES_DB: postgres
       POSTGRES_PASSWORD: mysecretpassword
       POSTGRES_USER: postgres
+
+  postgresql14:
+    image: "postgres:14"
+    ports:
+      - "5414:5432"
+    restart: always
+    environment:
+      POSTGRES_DB: postgres
+      POSTGRES_PASSWORD: mysecretpassword
+      POSTGRES_USER: postgres
+
+  postgresql13:
+    image: "postgres:13"
+    ports:
+      - "5413:5432"
+    restart: always
+    environment:
+      POSTGRES_DB: postgres
+      POSTGRES_PASSWORD: mysecretpassword
+      POSTGRES_USER: postgres
+
+  postgresql12:
+    image: "postgres:12"
+    ports:
+      - "5412:5432"
+    restart: always
+    environment:
+      POSTGRES_DB: postgres
+      POSTGRES_PASSWORD: mysecretpassword
+      POSTGRES_USER: postgres
+
+  postgresql11:
+    image: "postgres:11"
+    ports:
+      - "5411:5432"
+    restart: always
+    environment:
+      POSTGRES_DB: postgres
+      POSTGRES_PASSWORD: mysecretpassword
+      POSTGRES_USER: postgres
