Skip to content

Move stream cache to SQL database #4

@Dorge47

Description

@Dorge47

A SQL database seems like a much cleaner and more permanent way to cache data for videos/streams as well as channel metadata. Response objects from the YouTube API will be parsed and sent to the database using the nodejs driver for whatever database technology is used. A secondary system (another rpi) should be used to serve the database so that the performance of the main program is unaffected. It is currently unclear whether a relational or object-store database model would be a better fit. The structure of YouTube's API response is unlikely to change but not impossible. In the case of the channels themselves, there may also be a use case for storing information not found in the API response (such as birthdays or links to profiles on other platforms).

  • Choose a database technology
  • Implement the nodejs driver for the database language
  • Decide how frequently the local cache should be synced with the database (on data receive or every x minutes?)
  • Setup regular backups so that data can be backed up long-term and moved off of the machine's local storage

Metadata

Metadata

Assignees

Labels

transitionConversion of a significant part of the codebase from one system to another

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions