nasandre/dnd-character-generator
1
0
Fork 0
Code Issues 4 Pull requests 1 Projects 1 Releases Packages Wiki Activity

Store and retrieve normalised data in a PostgreSQL database. #6

New issue
Closed
opened 2026-08-04 16:38:41 +00:00 by nasandre · 2 comments
nasandre commented 2026-08-04 16:38:41 +00:00
Owner
Copy link
No description provided.
nasandre commented 2026-08-06 07:21:09 +00:00
Author
Owner
Copy link

Change the backend data storage to a PostgreSQL database for both the web app and the mcp server. This version allows you to:

  • Store and retrieve normalised data in a PostgreSQL database.
  • Store all data in the database
  • Migrate from JSON to database
  • Cache API/scraped/document data in the database to avoid redundant requests.
  • Fallback to APIs/scraping if data isn’t found in the database
Change the backend data storage to a PostgreSQL database for both the web app and the mcp server. This version allows you to: - Store and retrieve normalised data in a PostgreSQL database. - Store all data in the database - Migrate from JSON to database - Cache API/scraped/document data in the database to avoid redundant requests. - Fallback to APIs/scraping if data isn’t found in the database
nasandre commented 2026-08-07 14:09:23 +00:00
Author
Owner
Copy link

Resolved and deployed. The backend now runs a storage engine with a PostgreSQL database mode:

  • storage.mode = "db" on boot; normalized app data (settings, characters, campaigns, parties, encounters, homebrew, lore, users, documents) persisted in PostgreSQL (the servarr-stack postgres container, via the servarr_default Docker network).
  • Cache + fallback paths in place; API/scrape/doc data cached in the DB, with fallback to live sources when not found.
  • Verified live on https://dndgen.tabletopamsterdam.nl (and http://192.168.50.213:8870): GET /api/health returns {"status":"ok","storage":{"mode":"db","database":"postgres","jsonFallback":true}}; settings, auth providers, and dnd/classes endpoints all return 200.
  • Also fixed the nginx reverse-proxy URI mangling that was 404ing every /api/* route and breaking the container healthcheck.

Commits: 7fc3b2d, a6495ea, d317478 (branch features/postgresql).

This completes the milestone. mcp-server JSON document storage is being handled separately.

Resolved and deployed. The backend now runs a storage engine with a PostgreSQL database mode: - `storage.mode = "db"` on boot; normalized app data (settings, characters, campaigns, parties, encounters, homebrew, lore, users, documents) persisted in PostgreSQL (the servarr-stack `postgres` container, via the `servarr_default` Docker network). - Cache + fallback paths in place; API/scrape/doc data cached in the DB, with fallback to live sources when not found. - Verified live on `https://dndgen.tabletopamsterdam.nl` (and `http://192.168.50.213:8870`): `GET /api/health` returns `{"status":"ok","storage":{"mode":"db","database":"postgres","jsonFallback":true}}`; settings, auth providers, and dnd/classes endpoints all return 200. - Also fixed the nginx reverse-proxy URI mangling that was 404ing every `/api/*` route and breaking the container healthcheck. Commits: `7fc3b2d`, `a6495ea`, `d317478` (branch `features/postgresql`). This completes the milestone. mcp-server JSON document storage is being handled separately.
Sign in to join this conversation.
develop
Branches Tags
Clear current reference
main
feature/shops
feature/harvest-flow
feature/monster-harvesting-data
feature/crafting-harvesting
bugfix/character-generator
feature/battle-mode
feature/languagetool-spellcheck
map-editor
features/postgresql
fixes
features/loremanager
develop
worldmanager
master
Clear current reference
No results found.
Labels
Clear labels
No items
No labels
Projects
Clear projects
No items
No project
DND 5.5e Manager
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
nasandre/dnd-character-generator#6
No description provided.