[tkinom]

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]

Try 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.