8 ms·
I have written time series logging db with sqlite believe that approach has following advantages: System performance scales well with latest SSD HW.
by tkinom 5y ago
I have written time series logging db with sqlite believe that approach has following advantages:
System performance scales well with latest SSD HW.
As compare to cloud base approach that is limited by network/cloud speed.
One can store logs per day / week / year in separate db files as needed.
Backup of small db files for last few days/weeks are trivial with rsync.
Love to hear other pro/con arguments from folks who use Timescale type approach.
- ignoramous 5y agoTry timeseries with duckdb.org or Clickhouse Local? We use the former for analytical queries (queries over columns instead of rows), at which it is better than Sqlite3.