Design a statistics caching solution
Task description
Create a design for a solution to cache the necessary information to generate all statistics we need. For this issue, you can ignore the implementation in API calls, just focus on what data we need to store and how. Look at the April 2nd meeting notes to see what statistics we need. Figure out what data we would need to store to display all the statistics, including data for filtering and searching. Figure out a way to store this data. Is this in the SQL database as tables or as raw bytes, or is this in a file or NoSQL database. Create a list of pros and cons and pick the most appropriate solution for GitBull. Also figure out the schema for the data.
Deliverables
- A proposed way to store the caches and an explanation of how you came to that conclusion.
- One of the following.
- A SQL database schema
- A JSON schema
- A different format? -> Detailed description