[PR #1094] feat: add MySQL support to the application #1052

New Issue

OVERLORD · 2026-02-05T18:50:59+03:00

OVERLORD commented

2026-02-05 18:50:59 +03:00

📋 Pull Request Information

Original PR: https://github.com/pocket-id/pocket-id/pull/1094
Author: @jeboehm
Created: 11/13/2025
Status: 🔄 Open

Base: main ← Head: main

📝 Commits (1)

f145a13 feat: add MySQL support to the application

📊 Changes

15 files changed (+441 additions, -28 deletions)

View changed files

📝 .github/workflows/e2e-tests.yml (+26 -1)
📝 backend/go.mod (+3 -0)
📝 backend/go.sum (+6 -0)
📝 backend/internal/bootstrap/db_bootstrap.go (+9 -0)
📝 backend/internal/common/env_config.go (+6 -1)
📝 backend/internal/common/env_config_test.go (+21 -0)
📝 backend/internal/service/app_config_service.go (+1 -1)
📝 backend/internal/service/custom_claim_service.go (+9 -2)
📝 backend/internal/service/e2etest_service.go (+16 -5)
📝 backend/internal/service/oidc_service.go (+12 -5)
📝 backend/internal/service/user_group_service.go (+20 -2)
📝 backend/internal/service/user_service.go (+6 -2)
📝 backend/internal/service/webauthn_service.go (+34 -9)
➕ backend/resources/migrations/mysql/20241211111554_init.up.sql (+244 -0)
➕ tests/setup/docker-compose-mysql.yml (+28 -0)

📄 Description

Updated CI/CD workflow to include MySQL in the database matrix for end-to-end tests.
Added MySQL image caching and loading steps in the workflow.
Integrated MySQL database support including migration handling and environment configuration.
Created initial MySQL migration files for database schema.
Updated environment configuration tests to validate MySQL settings.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/pocket-id/pocket-id/pull/1094 **Author:** [@jeboehm](https://github.com/jeboehm) **Created:** 11/13/2025 **Status:** 🔄 Open **Base:** `main` ← **Head:** `main` --- ### 📝 Commits (1) - [`f145a13`](https://github.com/pocket-id/pocket-id/commit/f145a13be507a6f3b9d687d5eaac1432232c63a0) feat: add MySQL support to the application ### 📊 Changes **15 files changed** (+441 additions, -28 deletions) <details> <summary>View changed files</summary> 📝 `.github/workflows/e2e-tests.yml` (+26 -1) 📝 `backend/go.mod` (+3 -0) 📝 `backend/go.sum` (+6 -0) 📝 `backend/internal/bootstrap/db_bootstrap.go` (+9 -0) 📝 `backend/internal/common/env_config.go` (+6 -1) 📝 `backend/internal/common/env_config_test.go` (+21 -0) 📝 `backend/internal/service/app_config_service.go` (+1 -1) 📝 `backend/internal/service/custom_claim_service.go` (+9 -2) 📝 `backend/internal/service/e2etest_service.go` (+16 -5) 📝 `backend/internal/service/oidc_service.go` (+12 -5) 📝 `backend/internal/service/user_group_service.go` (+20 -2) 📝 `backend/internal/service/user_service.go` (+6 -2) 📝 `backend/internal/service/webauthn_service.go` (+34 -9) ➕ `backend/resources/migrations/mysql/20241211111554_init.up.sql` (+244 -0) ➕ `tests/setup/docker-compose-mysql.yml` (+28 -0) </details> ### 📄 Description - Updated CI/CD workflow to include MySQL in the database matrix for end-to-end tests. - Added MySQL image caching and loading steps in the workflow. - Integrated MySQL database support including migration handling and environment configuration. - Created initial MySQL migration files for database schema. - Updated environment configuration tests to validate MySQL settings. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

OVERLORD added the pull-request label 2026-02-05 18:50:59 +03:00

OVERLORD referenced this issue

2026-02-05 18:51:35 +03:00

[PR #1164] [MERGED] feat: restrict oidc clients by user groups per default #1079

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/pocket-id-pocket-id#1052