petre2dor / piGarden

Irrigation system powered by raspberry pi. work in progress...
GNU General Public License v3.0
7 stars 0 forks source link

Stats tables #2

Closed petre2dor closed 8 years ago

petre2dor commented 8 years ago

How to save data like temperature, humidity, wind? I am starting to think that one table like this would do:

stats

type: temp|wind|humidity value: 12.2 date: timestamp data: more data in JSON format (in case we need details)

petre2dor commented 8 years ago

I created it and created two mock actions: https://github.com/petre2dor/piGarden/blob/master/scripts/updates/update-6.sql