Re:It’s About Time for Time Series Databases
by rpedela on Thursday January 25, 2018 @05:52PM
(#16235497)
It is database per device and table per sensor, not just one table. With SQL you can do joins, aggregations, etc. If you just want to log it, sure use a log file. As soon as you want to use the data somehow, you need SQL or your own log file parsing and query code. Personally, I rather just use SQL.
[ Parent
| on HN ]
Re:It’s About Time for Time Series Databases
by creeble on Friday January 26, 2018 @01:01AM
(#16237319)
If you’re storing from multiple sensors with multiple write processess, you will have concurrency problems if they’re in the same db with SQLite.
I’m not referring to manipulating or even querying the data after it’s stored. I just don’t see how saving the original data in SQLite buys you anything, if it needs to be collected into a db for queries, etc, anyway.