[PR #1616] [CLOSED] Postgres support: message cache (part 3/3) #1663

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/1616
Author: @binwiederhier
Created: 2/19/2026
Status: ❌ Closed

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

📝 Commits (5)

2716ede Extract message cache into message/ package with model/ types
0d1f344 fmt
9cc9891 Add postgres to pipeline
939b3d1 Fix lint, make pipeline use psotgres
9e4a48b Make server tests also run against postgres

📊 Changes

39 files changed (+8598 additions, -7103 deletions)

View changed files

📝 .github/workflows/release.yaml (+16 -0)
📝 .github/workflows/test.yaml (+17 -1)
📝 Makefile (+2 -0)
➕ message/store.go (+628 -0)
➕ message/store_postgres.go (+120 -0)
➕ message/store_postgres_schema.go (+90 -0)
➕ message/store_postgres_test.go (+120 -0)
➕ message/store_sqlite.go (+140 -0)
➕ message/store_sqlite_schema.go (+466 -0)
➕ message/store_sqlite_test.go (+459 -0)
➕ message/store_test.go (+767 -0)
➕ model/model.go (+205 -0)
📝 server/actions.go (+9 -8)
📝 server/log.go (+3 -2)
➖ server/message_cache.go (+0 -1104)
➖ server/message_cache_test.go (+0 -825)
📝 server/server.go (+43 -35)
📝 server/server_account_test.go (+605 -563)
📝 server/server_admin_test.go (+366 -342)
📝 server/server_firebase.go (+5 -4)

...and 19 more files

📄 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/1616 **Author:** [@binwiederhier](https://github.com/binwiederhier) **Created:** 2/19/2026 **Status:** ❌ Closed **Base:** `postgres-webpush+user` ← **Head:** `postgres-webpush+user+message` --- ### 📝 Commits (5) - [`2716ede`](https://github.com/binwiederhier/ntfy/commit/2716ede6e1dc92f07719aff48c2a6fa1415009e2) Extract message cache into message/ package with model/ types - [`0d1f344`](https://github.com/binwiederhier/ntfy/commit/0d1f3444f27000cbda102ca2bb64883a364b35dd) fmt - [`9cc9891`](https://github.com/binwiederhier/ntfy/commit/9cc9891f49102a5abbe67e65a50646e36ea80118) Add postgres to pipeline - [`939b3d1`](https://github.com/binwiederhier/ntfy/commit/939b3d1117484d99c77eacebaf8daf4a11ce5ef3) Fix lint, make pipeline use psotgres - [`9e4a48b`](https://github.com/binwiederhier/ntfy/commit/9e4a48b058b6ffde0d2ec9104d16b1a69af3c5df) Make server tests also run against postgres ### 📊 Changes **39 files changed** (+8598 additions, -7103 deletions) <details> <summary>View changed files</summary> 📝 `.github/workflows/release.yaml` (+16 -0) 📝 `.github/workflows/test.yaml` (+17 -1) 📝 `Makefile` (+2 -0) ➕ `message/store.go` (+628 -0) ➕ `message/store_postgres.go` (+120 -0) ➕ `message/store_postgres_schema.go` (+90 -0) ➕ `message/store_postgres_test.go` (+120 -0) ➕ `message/store_sqlite.go` (+140 -0) ➕ `message/store_sqlite_schema.go` (+466 -0) ➕ `message/store_sqlite_test.go` (+459 -0) ➕ `message/store_test.go` (+767 -0) ➕ `model/model.go` (+205 -0) 📝 `server/actions.go` (+9 -8) 📝 `server/log.go` (+3 -2) ➖ `server/message_cache.go` (+0 -1104) ➖ `server/message_cache_test.go` (+0 -825) 📝 `server/server.go` (+43 -35) 📝 `server/server_account_test.go` (+605 -563) 📝 `server/server_admin_test.go` (+366 -342) 📝 `server/server_firebase.go` (+5 -4) _...and 19 more files_ </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>