Investigate using Room for DB operations

### Expected Behaviour

### Actual Behaviour

### Reproduce Scenario (including but not limited to)

#### Steps to Reproduce

#### Platform and Version

#### Sample Code that illustrates the problem

#### Logs taken while reproducing problem

Start by reviewing the repository’s existing database operations and the Android/Kotlin implementation; no specific file, test, or entry point is identified in the issue. Done would require a documented decision on whether to use Room and a defined migration scope, but the issue provides no acceptance criteria.

Written by the indexing model from the issue text.