LizardByte / LizardByte/roadmap

Sunshine: use sqlite db for persistent data

Open
#87 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

6+ months C++ effort:Large LizardByte/Sunshine planned priority:Medium SQL
Dominant language
No language data
Stars
2
Forks
0
Avg merge
25m
Merged PRs (30d)
5

Description

### Is there an existing issue for this item?

- [x] I have searched the existing issues

### Repositories

LizardByte/Sunshine

### Languages/Skills/Technologies

C++, SQL

### Description

I believe it's a better practice to store data in a proper database instead of random json files.

#### Pros
- All data in one location
- Apps can have an actual ID (auto incrementing)
- No more boost json
- Can use db fixtures for unit testing different scenarios
- Can use proper migrations when the db structure changes, storing the db version in migration table... with up and down migrations. For down migrations Sunshine could download the downgrade SQL file from the git repo since it wouldn't be available in the previous versions of Sunshine.

#### Cons
- All data in one location
- SQL

### Estimated Effort

effort:Large

### Priority

priority:Medium

### Target Milestone

6+ months

### Dependencies

_No response_

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by inventorying Sunshine's current JSON and Boost JSON persistence, then outline the proposed SQLite schema and migration approach. Done means persistent data is consolidated in SQLite, application IDs and migrations are supported, and database fixtures can cover unit-test scenarios.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sql
Domain
backend, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.