[PR #58] [MERGED] Adding PostgreSQL support #59

New issue

Closed

opened 2026-02-26 12:17:04 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 12:17:04 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/asalimonov/authelia-admin/pull/58
Author: @asalimonov
Created: 2/8/2026
Status: ✅ Merged
Merged: 2/8/2026
Merged by: @asalimonov

Base: main ← Head: feature/postgres

📝 Commits (10+)

3f099a7 feat: add pg and @types/pg dependencies for PostgreSQL support
2b4137e feat: restructure DatabaseConfig for PostgreSQL with proper address parsing
6970a97 feat: implement PostgreSQLAdapter class with full CRUD operations
9fadf76 feat: update createDatabaseAdapter factory to use PostgresConfig
958f3d5 feat: remove sqlite-only guards from page servers
9bf193c feat: replace dbPath with dbInfo in page servers for multi-backend support
13da21a feat: update Svelte templates for multi-backend database support
e67412d feat: update i18n messages for PostgreSQL support
c4ec1b5 feat: create Authelia PostgreSQL test configuration
8c035c0 feat: create PostgreSQL docker-compose test stack

📊 Changes

22 files changed (+1415 additions, -561 deletions)

View changed files

📝 CLAUDE.md (+18 -15)
📝 Dockerfile (+1 -1)
📝 Makefile (+37 -5)
📝 README.md (+10 -7)
➕ docker-compose.test-pg.yml (+131 -0)
📝 docker-compose.test.yml (+1 -1)
➕ docs/plans/20260208-postgresql-support.md (+200 -0)
📝 messages/en.json (+1 -5)
📝 messages/ru.json (+1 -5)
📝 package-lock.json (+482 -368)
📝 package.json (+8 -5)
📝 src/lib/server/database.ts (+340 -10)
📝 src/routes/(app)/banned/ip/+page.server.ts (+15 -30)
📝 src/routes/(app)/banned/ip/+page.svelte (+1 -12)
📝 src/routes/(app)/banned/users/+page.server.ts (+9 -24)
📝 src/routes/(app)/banned/users/+page.svelte (+1 -12)
📝 src/routes/(app)/totp/configurations/+page.server.ts (+8 -19)
📝 src/routes/(app)/totp/configurations/+page.svelte (+1 -12)
📝 src/routes/(app)/totp/history/+page.server.ts (+6 -17)
📝 src/routes/(app)/totp/history/+page.svelte (+1 -12)

...and 2 more files

📄 Description

https://github.com/asalimonov/authelia-admin/issues/35

_{🔄 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/asalimonov/authelia-admin/pull/58 **Author:** [@asalimonov](https://github.com/asalimonov) **Created:** 2/8/2026 **Status:** ✅ Merged **Merged:** 2/8/2026 **Merged by:** [@asalimonov](https://github.com/asalimonov) **Base:** `main` ← **Head:** `feature/postgres` --- ### 📝 Commits (10+) - [`3f099a7`](https://github.com/asalimonov/authelia-admin/commit/3f099a72c7bd189998c8e6c5f06cb4fa71c13e36) feat: add pg and @types/pg dependencies for PostgreSQL support - [`2b4137e`](https://github.com/asalimonov/authelia-admin/commit/2b4137e09d38f0946318d28be403de88c1ea000d) feat: restructure DatabaseConfig for PostgreSQL with proper address parsing - [`6970a97`](https://github.com/asalimonov/authelia-admin/commit/6970a9741b2116c6a3e17e5b81619f3760d84131) feat: implement PostgreSQLAdapter class with full CRUD operations - [`9fadf76`](https://github.com/asalimonov/authelia-admin/commit/9fadf769c69e4193801a3386ca6b4fd4f8ef36a2) feat: update createDatabaseAdapter factory to use PostgresConfig - [`958f3d5`](https://github.com/asalimonov/authelia-admin/commit/958f3d51fa2c4e6766ed24c4a213a987a6befb4b) feat: remove sqlite-only guards from page servers - [`9bf193c`](https://github.com/asalimonov/authelia-admin/commit/9bf193cc42dc5cc8ca54e895f53fae1aa980db29) feat: replace dbPath with dbInfo in page servers for multi-backend support - [`13da21a`](https://github.com/asalimonov/authelia-admin/commit/13da21a1c6315aabe654e88c9552dac80b546ff0) feat: update Svelte templates for multi-backend database support - [`e67412d`](https://github.com/asalimonov/authelia-admin/commit/e67412d3faf1b544f5068aa2ab181b592b8fd2e9) feat: update i18n messages for PostgreSQL support - [`c4ec1b5`](https://github.com/asalimonov/authelia-admin/commit/c4ec1b5e4172582805310ac5bb7cd9cad9099197) feat: create Authelia PostgreSQL test configuration - [`8c035c0`](https://github.com/asalimonov/authelia-admin/commit/8c035c0945065fa0dbe77e9defae3237af42b32f) feat: create PostgreSQL docker-compose test stack ### 📊 Changes **22 files changed** (+1415 additions, -561 deletions) <details> <summary>View changed files</summary> 📝 `CLAUDE.md` (+18 -15) 📝 `Dockerfile` (+1 -1) 📝 `Makefile` (+37 -5) 📝 `README.md` (+10 -7) ➕ `docker-compose.test-pg.yml` (+131 -0) 📝 `docker-compose.test.yml` (+1 -1) ➕ `docs/plans/20260208-postgresql-support.md` (+200 -0) 📝 `messages/en.json` (+1 -5) 📝 `messages/ru.json` (+1 -5) 📝 `package-lock.json` (+482 -368) 📝 `package.json` (+8 -5) 📝 `src/lib/server/database.ts` (+340 -10) 📝 `src/routes/(app)/banned/ip/+page.server.ts` (+15 -30) 📝 `src/routes/(app)/banned/ip/+page.svelte` (+1 -12) 📝 `src/routes/(app)/banned/users/+page.server.ts` (+9 -24) 📝 `src/routes/(app)/banned/users/+page.svelte` (+1 -12) 📝 `src/routes/(app)/totp/configurations/+page.server.ts` (+8 -19) 📝 `src/routes/(app)/totp/configurations/+page.svelte` (+1 -12) 📝 `src/routes/(app)/totp/history/+page.server.ts` (+6 -17) 📝 `src/routes/(app)/totp/history/+page.svelte` (+1 -12) _...and 2 more files_ </details> ### 📄 Description https://github.com/asalimonov/authelia-admin/issues/35 --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>