Assume I build a IoT gateway (Linux OS) for collecting data from sensors. Data is store on database, and can be viewed via a web server implement on this gateway. Storage is not much, about 2GB. Which database is a good choice for this situation? RDBM or NoSQL or Time series? In my positon, I think no need both NoSQL and Time series, just going on with traditional RDBM. Is it good? Please give me some advices.
Add more info:
- Each sensor will send temperature, voltage, etc.
- Data visualization for each sensor in one hour, one day or one month. (I think it is good for the max period is in one month)
- And track all every single value. Example: gateway want to read data from a sensor in a moment, but it could not get for some reasons (sensor is die, disconnect to network, etc). So, this moment will be track and set it's value to null (or a value point out that could not get data from sensor in that moment). When you view data visualization, you will know in that time, it was a problem with sensor or network.