Best Database specifications for my IOT solution
0
votes
2
answers
92
views
i'm working on a IOT environment that basically is a sensor that can **measure more then 300 times a second**. We receive this measurements remotely using **MQTT protocol**. I want to set up **a painel** where i can **watch in real time the measures** my sensor is doing, i can do this with MQTT with no problem at all. But someone have ever done this using some database function? I know there are something called **"Queue watch"** for database that can do something similar.
The problem starts when i need to **store those measurements**, because i need to do analysis on them, draw graphics, and things like that.
As i'm not familiar with databases, **there is a lot of data to store** ( i imagine ) **what would be the best database environment** for this kind of thing?
------------------------
----UPDATE1 -----
*How many do you need to store? Last hour? Last day? Last decade? – **Basil Bourque***
As it's a service for clients, i would say that the lest month of measurements would be "hot data", i want to make them easily accessible and as fast as possible and anything older then that i can store as "cold data" just for eventual analysis, or any request for old measurements from clients.
------------
Asked by Bruno Cerk
(103 rep)
May 20, 2018, 05:22 AM
Last activity: Mar 30, 2025, 04:47 AM
Last activity: Mar 30, 2025, 04:47 AM