Hi! I’ve implemented an uploader for SQL. Specifically it writes to a postgresql database. There are more details on the PhiSaver Energy Monitor page.
We’re testing it on a few installs, in parallel with Influx (you can have two uploaders, heap seems ok).
It’s been made available as a pull request to the repo. Contact me if you want to try it now.
Some snaps are below…new uploader “PostgREST”…
… writes to an SQL database:
… then view the database with PhiSaver or Grafana as normal:
1 Like
great work - very interesting - I took a different tack a few months ago after abandoning InfluxDB (good decision in hindsight & should have never used it) (your solution is more elegant though requires a firmware update) - I already have a 24/7 server running Windows, so wrote a new C# program which does a query every minute (setting) & insert the data into postgres; your schema requirements wouldn’t have worked for me
1 Like
Nice work!
In my case, I wrote a couple of PHP functions using the IotaWatt Query API to pull data. I really like how accessible IotaWatt data is. To give an idea, here’s the PHP function I use to pull ‘current status’ for my web page dashboard.
