ROUNDUP: Data Logging and Charting Solutions

charts
logging
data

(codersaur) #1

There’s loads of data logging and charting solutions, so I thought I’d create an index. Reply with any solutions I’ve missed and I will update this post.

Amazon DynamoDB [cloud (free/paid)]:

Elastic Stack (LogStash+Beats+Elasticsearch+Kibana) [private (free) / cloud (paid)]:

Can’t see a specific thread on the community, but here’s a github link:

Google Sheets [cloud (free)]:



GroveStreams [cloud (free/paid)]:


InfluxData TICK Stack (Telegraf+InfluxDB+Chronograf+Kapacitor ) + Grafana [private (free) / cloud (paid)]:


Initial State [cloud (free/paid)]:


PlotWatt [cloud (free/paid)]:

Note: PlotWatt is discontinuing its support for 3rd party residential energy monitors on March 31st, 2017


ThingLayer [cloud (free)]:

Discontinued??

ThingSpeak [cloud (free/paid)]:


Xively [cloud (??)]:


SQL (MySQL, PostgreSQL , SQLite, SQL Server) [private (free/paid) / cloud (paid)]:

Various discussion but no working examples just yet…



Any way to track and record temperature readings?
Power Meter Logging SmartApps (PlotWatt, ThingSpeak, SmartEnergyGroups)
Web Dashboard
Is it possible to get history graphs of temperature and similar?
I need help keeping a history
App that collects data from smart devices then POSTs data to third party?
Google cloud integration?
Time logging in smartthings?
Starting Home Power Project : One Question i can't seem to answer
Temperature line graphs
Any compatible smart power outlets that do historical energy monitoring?
Power/Energy Monitoring?
Is there ST or Webcore action feed available?
Z-wave current sensor--smartapp to display current usage?
Energy monitoring?
Kind of a nerd thing but..... ST Data Dump?
Logging from Multipurpose sensor to sheet
Forwarding Events to ReST endpoint
NVenergy meter usage download?
Aeotec home energy meter V1(DSB09104-ZWUS) log to spread sheet
eGauge energy meter
Iris user looking for help with Aeotec by Aeon Labs v5 energy graphing
Iris user looking for help with Aeotec by Aeon Labs v5 energy graphing
Device state monitoring
How do you get your graphs for energy/temp sensors?
#2

Nice work!

There are a few more listed on the quick browse list in the community created wiki on the list for “logging” under smart apps.

For example, SmartEnergyGroups (SEG), and IOT logger.

http://thingsthataresmart.wiki/index.php?title=How_to_Quick_Browse_the_Community-Created_SmartApps_Forum_Section

I like the visuals in your post and the grouping by third-party solution, and I also realized after seeing it that it may not have been intuitive that the logging discussions were in the smartapp section of the quick browse lists, so I’ve added the same list to the project report section as well. :sunglasses:


(codersaur) #3

I’ve added all these, plus included info on hosting and subscription options.


(Štěpán Šanda) #4

@zcapr17 Do you have any comparsion which one of those two is better? Simple Event Logger or Log events to Google Sheets Some advantages / disadvantages?


(codersaur) #5

Sorry, I’ve never really looked at them. Logging to Google sheets is a relatively primitive solution when you can set up a much more powerful and customisable solution using InfluxDB with Grafana in under an hour, so I’ve done the latter. :wink:

That said, if anyone wants to post a comparative review I’ll try my best to integrate it into the roundup. Keep in mind that everyone has a different definition of what is better though.


(Štěpán Šanda) #6

Well, you are right. But the problem is, that you have to have running linux machine. The cheapest solution that I can think of is to buy Raspberry Pi and configure it. On the other hand the Google Sheet is completely free solution and it requires almost zero configuration. Plus graph can be exported from Google Sheet as image and then used in SmartTiles which can be a nice bonus.


(codersaur) #7

Both InfluxDB and Grafana publish Windows binaries now, as well as docker images too. Plus there’s various cloud-hosting options available. So you can host pretty much anywhere you want.

If you really don’t want to spend any time or money on a server, then yeah, Google sheets is a good simple option. I would also consider Initial State.


(Ron Talley) #9

I have a Pi3 running 4 services related to SmartThings. I have at least 30 or more metered outlets. Can my Pi3 handle all of this data with the additional services running using InfluxDB?


(Ben Dixon) #10

I’m looking into a free option for logging electricity use. I have a nextcloud\owncloud (personal cloud) instance running on one of my servers.

I ran across an app that can be added called “Sensor Logger”. Has anybody used this? Does this look like it might be possible to use with smartthings?

https://apps.nextcloud.com/apps/sensorlogger


(ActionTiles.com co-founder Terry @ActionTiles; GitHub: @cosmicpuppy) #11

Yes. You should be able to post to this API using a SmartApp.


#12

Has anyone tied this into RRD-Tool for graphs? or started the process to build it? I am an old school network guy who has been building bandwidth and network utilization graphs for 15 years with RRD Tool. Would be great to have a way to integrate this into SmartThings.


#13

Is this tread still actively being updated? It looks Initial State might be dead…


(ActionTiles.com co-founder Terry @ActionTiles; GitHub: @cosmicpuppy) #14

Where did you get the impression they were “dead”?

They pivoted away from the consumer/small-developer market for a while, and then came around and added affordable (?) plans again.

Did they withdraw their SmartThings integration?


#15

Good question, looked like thier domain was empty earlier today and now it’s loading. Disregard.


#16

Well since I just signed up to start using Initial State it appears their built in smartthings integration is down until “the beginning of 2019”.


(Jamie Bailey) #17

The new SmartThings integration to Initial State is now live.


(SP) #18

Great index

One more to it: https://www.hundredgraphs.com
Free


#19

How do you integrate ST to it?