undefined | Better HN

0 pointsJamesBarney6y ago0 comments

I've been happy with influxdb, but I've also noticed that a lot of people switch to a time series database way before they need to. You can go pretty far with postgres/oracle/sql server, and it has the advantage you don't need to manage different databases.

0 comments

proverbialbunny6y ago

Thanks for the response. I've avoided influxdb because it drops data. Bar and tick data needs to be ACID or at least very close to ACID.

InfluxDB is great for server usage stats though.

JamesBarneyOP6y ago

I don't know much about bar or tick data. Mind going into more detail about dropping data?

We didn't really have a need for transactions because we were just recording a bunch of sensor data from oil and gas wells from the around the world and then running computations and then displaying and alerting on the results.

proverbialbunny6y ago

Bar and tick data is financial, so dealing with numbers. It has to be precise, like not 0.0000001 off and dropped data isn't the end of the world, but it's pretty bad.

j / k navigate · click thread line to collapse

0 pointsJamesBarney6y ago0 comments

0 comments

proverbialbunny6y ago

Thanks for the response. I've avoided influxdb because it drops data. Bar and tick data needs to be ACID or at least very close to ACID.

InfluxDB is great for server usage stats though.

JamesBarneyOP6y ago

I don't know much about bar or tick data. Mind going into more detail about dropping data?

proverbialbunny6y ago

Bar and tick data is financial, so dealing with numbers. It has to be precise, like not 0.0000001 off and dropped data isn't the end of the world, but it's pretty bad.

j / k navigate · click thread line to collapse