[PR #1614] [CLOSED] Postgres support: user management (part 2/3) #1664

New issue

Closed

opened 2026-05-07 01:03:08 +02:00 by BreizhHardware · 0 comments

BreizhHardware commented

2026-05-07 01:03:08 +02:00

Owner

📋 Pull Request Information

Original PR: https://github.com/binwiederhier/ntfy/pull/1614
Author: @binwiederhier
Created: 2/18/2026
Status: ❌ Closed

Base: postgres-webpush ← Head: postgres-webpush+user

📝 Commits (6)

60fa50f Merge branch 'main' into postgres-webpush+user
07c3e28 Refactor user package to Store interface with PostgreSQL support
909c3fe Add Store-level unit tests for SQLite and PostgreSQL backends
1abc100 Re-org
e3a402e Make user tests work for postgres and sqlite
ae5e1fe Merge branch 'postgres-webpush' into postgres-webpush+user

📊 Changes

15 files changed (+4242 additions, -2238 deletions)

View changed files

📝 cmd/user.go (+17 -8)
📝 server/server.go (+12 -2)
📝 user/manager.go (+115 -1070)
📝 user/manager_test.go (+1211 -1105)
➕ user/store.go (+986 -0)
➕ user/store_postgres.go (+292 -0)
➕ user/store_postgres_schema.go (+113 -0)
➕ user/store_postgres_test.go (+208 -0)
➕ user/store_sqlite.go (+273 -0)
📝 user/store_sqlite_schema.go (+178 -37)
➕ user/store_sqlite_test.go (+180 -0)
➕ user/store_test.go (+619 -0)
📝 user/types.go (+14 -0)
📝 webpush/store_postgres.go (+11 -7)
📝 webpush/store_sqlite.go (+13 -9)

📄 Description

Parts

Part 1: web push (#1611)
Part 2: user manager (#1614)
Part 3: message cache (#1616)

_{🔄 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/binwiederhier/ntfy/pull/1614 **Author:** [@binwiederhier](https://github.com/binwiederhier) **Created:** 2/18/2026 **Status:** ❌ Closed **Base:** `postgres-webpush` ← **Head:** `postgres-webpush+user` --- ### 📝 Commits (6) - [`60fa50f`](https://github.com/binwiederhier/ntfy/commit/60fa50f0d5115ba330a3fce07bce090ec7aeb97b) Merge branch 'main' into postgres-webpush+user - [`07c3e28`](https://github.com/binwiederhier/ntfy/commit/07c3e280bf670597dfb3cbc1f5ad678cef6faaf4) Refactor user package to Store interface with PostgreSQL support - [`909c3fe`](https://github.com/binwiederhier/ntfy/commit/909c3fe17bbfe0629e78826ad2e2031320dd23b8) Add Store-level unit tests for SQLite and PostgreSQL backends - [`1abc100`](https://github.com/binwiederhier/ntfy/commit/1abc1005d01b7660ec58d4c0932d66c84a073982) Re-org - [`e3a402e`](https://github.com/binwiederhier/ntfy/commit/e3a402ed959f55100fd326e11039ca88219d96dd) Make user tests work for postgres and sqlite - [`ae5e1fe`](https://github.com/binwiederhier/ntfy/commit/ae5e1fe8d8f6edb5a545fb9bf60f7f7877c14f4c) Merge branch 'postgres-webpush' into postgres-webpush+user ### 📊 Changes **15 files changed** (+4242 additions, -2238 deletions) <details> <summary>View changed files</summary> 📝 `cmd/user.go` (+17 -8) 📝 `server/server.go` (+12 -2) 📝 `user/manager.go` (+115 -1070) 📝 `user/manager_test.go` (+1211 -1105) ➕ `user/store.go` (+986 -0) ➕ `user/store_postgres.go` (+292 -0) ➕ `user/store_postgres_schema.go` (+113 -0) ➕ `user/store_postgres_test.go` (+208 -0) ➕ `user/store_sqlite.go` (+273 -0) 📝 `user/store_sqlite_schema.go` (+178 -37) ➕ `user/store_sqlite_test.go` (+180 -0) ➕ `user/store_test.go` (+619 -0) 📝 `user/types.go` (+14 -0) 📝 `webpush/store_postgres.go` (+11 -7) 📝 `webpush/store_sqlite.go` (+13 -9) </details> ### 📄 Description ## Parts - Part 1: web push (#1611) - Part 2: user manager (#1614) - Part 3: message cache (#1616) --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>