234 points by timescale 6 months ago flag hide 27 comments
randomuser1 6 months ago next
Fantastic article! I've been looking for a scalable TSDB for IoT and this looks amazing.
actualuser 6 months ago next
@randomuser1 Agreed, especially when dealing with tens of thousands of concurrent IoT devices!
randomuser2 6 months ago next
@actualuser Absolutely! Using an open-source database like TimescaleDB makes things even better.
devopsguru 6 months ago next
@randomuser2 Shout out to TimescaleDB, the PostgreSQL TSDB. Highly customizable and no actual limits to scale.
anonymous 6 months ago next
Anyone else hate that InfluxDB's query language isn't its own but SQL-like? Makes me cringe!
ranty 6 months ago next
Having worked with both, I find that InfluxDB's community is much more mature, so yeah, just stick to their CLI or InfluxQL.
influxuser 6 months ago next
@ranty Granted, I agree their query language is weird, but it is easier and more flexible in many ways.
ranty 6 months ago next
@influxuser I just prefer having a uniform, standardized syntax discussing data and solutions.
influxuser 6 months ago next
@ranty Fair enough, I think it just comes down to personal preference and what you are used to.
randomuser5 6 months ago next
I agree, I've tried all three and TimescaleDB suited me best. However, depends on use-cases.
op 6 months ago next
@randomuser5 Definitely, I've seen general articles singing praises. But it's nice to hear use-cases.
randomuser5 6 months ago next
@op I find TimescaleDB to be the easiest in terms of SQL support and managing retention policies.
stackoverflowuser 6 months ago prev next
I had the same dilemma a few months ago. Ended up going with TimescaleDB, happy with it. Don't look back.
weighingoptions 6 months ago next
@stackoverflowuser Another vote for TimescaleDB! Thank you.
curious 6 months ago prev next
Which of these has the best support for data visualization? Just curious.
sciguy 6 months ago next
@curious All 3 support data visualization well, but InfluxDB has an all-in-one platform called InfluxDB Cloud (including its own UI).
curious 6 months ago next
@sciguy That seems convenient. How's the pricing? I hate checking sites, just tell me.
freetrial 6 months ago next
@curious The InfluxDB Cloud platform offers a free tier, $20/GB for the basic tier, and elite tiers beyond that.
expertdba 6 months ago prev next
Great to see the focus on IoT. I find Time-series databases (TSDB) to be very effective for similar real-time use cases.
op 6 months ago next
@expertdba OP here. Any recommendations for specific TSDBs you fancy?
opensourcer 6 months ago next
@op I recommend looking into Timescale, OpenTSDB, and InfluxDB. Each has its benefits.
happyhacker 6 months ago next
@op I personally like TimescaleDB and InfluxDB. The communities are large and helpful.
op 6 months ago next
@happyhacker I've heard of the customizability of TimescaleDB. But how well do all of these scale with IoT specifically?
scaledba 6 months ago next
@op OpenTSDB, TimescaleDB, and*/* InfluxDB scale nicely, provided you match the infrastructure or cloud offering to your IOT devices count.
op 6 months ago next
@scaledba Great to know! Luckily, IoT device count isn't huge yet, but planning is crucial.
anotherview 6 months ago next
@op I tend to find TimescaleDB's scalability and ease of use is unparalleled in most cases, IMO.
op 6 months ago next
@anotherview Will definitely look into that, comparing features is a must!