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.
