Closed johnboy14 closed 8 years ago
This story involves moving our bill and future user issue comments to MySQL. The new schema can be found in the following spec
https://docs.google.com/a/placeavote.com/document/d/1pRPeGteUMNblQgkitgh4aLnWPmf0elrs28_545VnMRU/edit?usp=sharing
Several data modelling techniques can be used with Relational databases for tree like data structures e.g. Adjacent lists and Closure tables but I would like to explore a different strategy and try to leverage the cache as much as possible.
Proposed Redis Data Model
https://drive.google.com/a/placeavote.com/file/d/0Byv1njCQKnxYNnRVQmNzRVQzWkk/view?usp=sharing
This story involves moving our bill and future user issue comments to MySQL. The new schema can be found in the following spec
https://docs.google.com/a/placeavote.com/document/d/1pRPeGteUMNblQgkitgh4aLnWPmf0elrs28_545VnMRU/edit?usp=sharing
Several data modelling techniques can be used with Relational databases for tree like data structures e.g. Adjacent lists and Closure tables but I would like to explore a different strategy and try to leverage the cache as much as possible.
Proposed Redis Data Model
https://drive.google.com/a/placeavote.com/file/d/0Byv1njCQKnxYNnRVQmNzRVQzWkk/view?usp=sharing