Use SQLite DB instead of Google Sheets

[SilasBerger]

No description provided.

[SilasBerger]

Using either Google Sheets or Excel as a "DB" is useful, because you get a "free UI". However, it could also be worth considering moving to a real DB such as SQLite and build a simple Electron / Tauri UI instead. Moving to Excel doesn't seem to provide much of a benefit, since GCP API limits have never been an issue so far, and having the sheet accessible online through the GCP API is a large benefit.

[SilasBerger]

Formerly: "Consider moving away from Google Sheets to Excel

Rationale: Having the data live in Google Sheets comes with downsides such as Google API auth handling (consent screen, etc.), potential rate limiting, limited query options, etc. Moving forward, this should a desktop application, or at some point possibly also / only a web app, with a proper GUI. Having the data in Google Sheets is therefore no longer useful - especially since it doesn't provide a more convenient "share to" option, which may be a benefit of having the data available online.

[SilasBerger]

Additionally, it makes the setup process a lot easier: no GCP project, no setting up the Google Sheet with just the right format, etc.