Re:IoT on QuestDB
by g8oz on Saturday June 06, 2020 @11:09AM
(#23439699)
Any performance metric comparisons available?
[ Parent
| on HN ]
We ran this experiment Vs influx some time ago for ingestion here https://medium.com/questdb/speeding-up-influx-line-protocol-...
In terms of queries, see our previous post on HN to get a sense https://news.ycombinator.com/item?id=22803504
Ingestion rate is pretty good in Influx and we are happy with that for now. If QuestDB is better I definitely won't complain. The issues with Influx is data integrity and also the difficulty in manipulating time series data if that becomes an issue (e.g turning all "0" string values into a 0i). How does QuestDB fare in this regard?
Re:IoT on QuestDB
by bluestreak on Saturday June 06, 2020 @04:20PM
(#23441945)
We take data integrity very seriously. This is one of the reasons QuestDB actually exists. We haven't had reports of data corruption or loss yet. We can commit durably if needed too.
To manipulate data we support "add" and "delete" column on the fly. We can also add column replace and type change if needed. This is pretty easy to do.
PostgreSQL wire is in beta. It works with JDBC driver and we will add metadata support quite soon.