[GH-ISSUE #14] Migrate to ORM and DB #9

New issue

Closed

opened 2026-10-15 13:01:27 +00:00 by bsakaguchi · 1 comment

bsakaguchi commented

2026-10-15 13:01:27 +00:00

Owner

Originally created by @salty2011 on GitHub (Jun 1, 2025).
Original GitHub issue: https://github.com/games-on-whales/wolfmanager/issues/14

Originally assigned to: @salty2011 on GitHub.

WolfManager currently stores all configuration in various toml files.

While this does make things simple for configuration, this starts creating large toml files once

you have several users each with secrets that should be encrypted
Storing details of owned games and who has those games
client pairing relationships and more

The proposed solution is to adopt an ORM and use a backend db like sqlite. This follow more standard patterns for NextJS based application and should make managing data more easy to perform.

Originally created by @salty2011 on GitHub (Jun 1, 2025). Original GitHub issue: https://github.com/games-on-whales/wolfmanager/issues/14 Originally assigned to: @salty2011 on GitHub. WolfManager currently stores all configuration in various toml files. While this does make things simple for configuration, this starts creating large toml files once - you have several users each with secrets that should be encrypted - Storing details of owned games and who has those games - client pairing relationships and more The proposed solution is to adopt an ORM and use a backend db like sqlite. This follow more standard patterns for NextJS based application and should make managing data more easy to perform.

bsakaguchi

2026-10-15 13:01:28 +00:00

closed this issue
added the
enhancement
label

bsakaguchi commented

2026-10-15 13:01:28 +00:00

Author

Owner

@salty2011 commented on GitHub (Jun 11, 2025):

Have created branch https://github.com/games-on-whales/wolfmanager/tree/feature/14-drizzle-orm-migration

Using Drizzle-ORM for common interface between UI and DB

Currently focusing on sqlite only in testing but have coded support for PostgreSQL and MySQL to test in the future
schemea has user,client,tasks,library tables (the other tables as for currently disabled features due to not implemented)

Whats working

[ x ] Pairing client and saving to database
[ x ] Pairing client when duplicate clientID is found, works but process is not as smooth id like as shows both clients as paired and then are removed. Good enough for now
[ x ] User Management: Create/Update/Delete
[ x ] User Authentication

Issues

CLIENT: Paired Client view is showing the DB UUID for client id instead of the Wolf Client ID
CLIENT: Duplicated client handing working but need better flow and warning messages
USER: Cannot toggle user to admin (no function)
Database migration does not work as expected, works if no existing database... Low priority as very few people are using WolfManager

@salty2011 commented on GitHub (Jun 11, 2025): Have created branch https://github.com/games-on-whales/wolfmanager/tree/feature/14-drizzle-orm-migration Using Drizzle-ORM for common interface between UI and DB - Currently focusing on sqlite only in testing but have coded support for PostgreSQL and MySQL to test in the future - schemea has user,client,tasks,library tables (the other tables as for currently disabled features due to not implemented) **Whats working** - [ x ] Pairing client and saving to database - [ x ] Pairing client when duplicate clientID is found, works but process is not as smooth id like as shows both clients as paired and then are removed. Good enough for now - [ x ] User Management: Create/Update/Delete - [ x ] User Authentication **Issues** - CLIENT: Paired Client view is showing the DB UUID for client id instead of the Wolf Client ID - CLIENT: Duplicated client handing working but need better flow and warning messages - USER: Cannot toggle user to admin (no function) - Database migration does not work as expected, works if no existing database... Low priority as very few people are using WolfManager

bsakaguchi referenced this issue

2026-10-15 13:01:48 +00:00

[PR #9] [MERGED] Refactor: WolfManager UI Overhaul and Documentation Update #36