Sample Header Ad - 728x90

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