3 ms·
So I want to store historical sensor data, like room temperature, for many sensors across many rooms. And then events that happen less frequently. Hourly. Dail
by whiddershins 5y ago
So I want to store historical sensor data, like room temperature, for many sensors across many rooms.
And then events that happen less frequently. Hourly. Daily.
There is no need to ever change that data, only append to it.
Does anyone here know what I should be looking at for append-only data storage technologies?
- rzzzt 5y ago"Time series database" and "log-structured storage" might be two keywords for starting points.
- jasonwatkinspdx 5y agoFor industrial scale Kafka et all. For more modest scale you could use something like lmdb, where append only hits a happy case optimization.
- mbrodersen 5y agoJust use a single file on disk. Or (if you worry about things getting corrupted) SQLite.