GRI-1899: client state in SQLite through sqlx #164
No reviewers
Labels
No labels
Area/Backend
Area/Database
Area/Docs
Area/Frontend
Area/Infra
Area/Security
Area/Tests
Area/Tooling
Compat/Breaking
Kind/Bug
Kind/Documentation
Kind/Enhancement
Kind/Feature
Kind/Security
Kind/Testing
Lang/Python
Lang/Rust
Lang/Shell
Lang/SQL
Lang/TypeScript
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Reviewed
Confirmed
Reviewed
Duplicate
Reviewed
Invalid
Reviewed
Won't Fix
Routing
Auto
Routing
Hold
Routing
Human
Status
Abandoned
Status
Blocked
Status
Need More Info
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set
Reference
Grimoirix/grimoire-of-digital-signage!164
Loading…
Reference in a new issue
No description provided.
Delete branch "feature/GRI-1899-client-sqlite-state"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Closes #41 (board GRI-1899).
The client's state — identity, pinned key, last playlist, last media manifest — moves from
state.jsontoclient.db: SQLite throughsqlx, per ADR 0003.Storekeeps its API;openandupdateare nowasync.Session::on_textfollows.synchronous = FULL, one transaction per change, file mode0600.crates/client/migrations/0001_device_state.sql, run withsqlx::migrate!.state.jsonis imported once into an empty database, then renamedstate.json.imported. A corrupt one stops the start and is left alone.sqlxcarries only the shared features; the server addspostgres, the client addssqlite.plan/client/offline-first.md.Local gates (
--rust-only, front end untouched): all pass. The GTK binary was also checked withcargo clippy --features gtk-renderer.