search

Muhuru-Bay-Microgrid / muhuru-bay-dashboard

Spring Boot Vaadin dashboard app for the Muhuru Bay Micro-grid Project
0 stars 0 forks source link

Decide on our database and design. #6

Open zkendall opened 10 years ago

zkendall commented 10 years ago

Ron is interested in amazon's SimpleDB. But there are a lot of free alternatives. Something like Redis might fit the bill.

rpomeroy commented 10 years ago

It's free up to a certain limit. I considered Redis first actually. Also we will need to integrate with Simple Queue Service and Glacier for cheap long term storage. Presumably there are "simple" paths to integrating these numerous Simple Things from Amazon :-)

rpomeroy commented 10 years ago

By adding the Spring Data SimpleDB template we'll try to insulate ourselves in case we need to switch to a different database. After reading the SimpleDB docs Matthieu committed I spotted some query return limits that gave me pause. It's probably OK near-term but could pose problems if we allow browsing the entire history. We'll probably need to design an aggregation scheme using another domain db.