breadlysm / varken Goto Github PK

Since the main program is seperated into individual files by program that return the data to be written to Influx, a translator method is needed to format that data to submit to postrgres.

This should accept the dictionary that are returned by the other functions and return data that #3 can submit successfully.

This functionality should be planned first as if it is not possible to do properly, the project is DOA.

Within the DBclass of #2 , a method is needed to take the data passed to it and write it to the appropriate Postgres table.

Is your feature request related to a problem? Please describe.
Limitation of Influx

Describe the solution you'd like
Within the varken.ini, the option should be available to use postgres or Influx. The option to use both should be considered a possibility.

Additional context
What I really want is the ability to splice the data into hourly buckets. What I want is 30 days of data that does not care about the data and aggregates only into quarter-hours. A true avg of when the server is used most. With Influxdb, detaching the date or rewriting the date doesn't appear possible. In postgres, I can take the times of the last 30 days and attach them to a now()::date to form a timestamp that is shows all 30 days of data and 'tricks' the time series into thinking it's today.

DB manager that can create tables if they don't exist and input any columns that are needed.