Add database based response caching for repeater analytics run. #147
Description
Currently there is OkHttp caching enabled to cache GitHub API responses. However, I want to extend functionality to cache JSON responses in database like postgres as seen below:
- https://www.postgresql.org/docs/current/datatype-json.html
- https://hevodata.com/learn/inserting-json-into-postgresql/
- https://www.postgresql.org/docs/current/functions-json.html
- https://www.dbvis.com/thetable/json-vs-jsonb-in-postgresql-a-complete-comparison/
Make use of https://sqldelight.github.io/sqldelight/2.1.0/ library so that the implementation is easily portable.
Define new data base configs in the local.properties and use these for caching along side OkHttp Caching if those new configs are provided. Don't forget to update local_sample.properties that is used as sample.
Make sure after all changes you apply code formatter using ./gradlew formatKotlin and ./gradlew build
All new code should be documented briefly to indicated intention.