[Request] SQLite DB Support

[zero77]

Is your feature request related to a problem? Please describe.
Installing InfluxDB on a singular device or low powered devices like a raspberry pi or home router seems to much.

Describe the solution you'd like
For devices like these could you please support an SQLite DB file instead of InfluxDB

Additional context

[AnalogJ]

Hey @zero77 I'd be happy to consider a different timeseries database, if you have any suggestions.
Here's a link explaining why InfluxDB is necessary at the moment - https://github.com/AnalogJ/scrutiny/blob/master/docs/TROUBLESHOOTING_INFLUXDB.md#influxdb-troubleshooting

Closing for now, however feel free to comment if you have feedback

[zero77]

Hi @AnalogJ
i don't have anything against InfluxDB its a good choice.
But i would like to see a lighter weight option for low powered devices.

Here is some more info about SQLite:
https://dev.to/stephenc222/a-beginners-guide-to-sqlite-the-lightweight-database-solution-c37
https://db-engines.com/en/system/InfluxDB%3BSQLite
https://gosamples.dev/sqlite-intro/

[AnalogJ]

We already use sqlite as our database @zero77
InfluxDB is a timeseries database, and we use it to store (and aggregate) SMART metrics from each device over a long timeframe (years)

[zero77]

thanks for your response but unless i am doing something wrong i cannot see a way to run scrutiny without influxdb.
i have commented out all of the influxdb part in the config and get an error