search

BPChain / meta

Meta-Repository for Wiki and User Stories
MIT License
4 stars 0 forks source link

Select SQL database technology for API-Server #76

Closed t-lichtenstein closed 6 years ago

t-lichtenstein commented 6 years ago
bisbaldi commented 6 years ago

Mongo (-) Mongoose can have difficult to undetstand syntax (-) Aggregator Query (-) Performance (Logs) ? (+) Easy to adapt to new chains/metrics (+) Bad written queries are not the DBs fault (+) Gather Json Data

Postgresql (+) Easier to aggregate data ? (+) Lots of data, all the same structure --> SQL (+) Performance ? (-) JSON parsing (-) Migration necessary for adding new chains/metrics (-) Does it really add value? (-) Takes longer than anticipated --> another refactoring sprint blocking feature development