Indigo Domotics

siclark wrote:

And one thing I wish I had done from the start, it you want to store device state history for plotting and historical analysis the highly suggest you a up postgresapp from the start and don't use sqllite.

Can you tell me why Postgres.app (PostgreSQL) not SQLite please?

I was looking through the plugins last night to start tracking data from my energy meter. I will investigate further:

• Grafana
• INDIGOplotD
• SQL Logger
• Thingspeak

My original thoughts were to get the data into a file whereby I can use Excel or Numbers for charting. What do others suggest?

Dual wrote:

Awesome help. Thanks. I will not forget that now.

Has bitten me more than once.

Can you tell me why Postgres.app (PostgreSQL) not SQLite please?

PostgresSQL is a far more robust database than SQLite. More reliable, better at handling more data, multiple simultaneous access, etc. It used to be that setting it up was a chore as it had to be installed as a full server, but the App took that server install and packaged it into a simple app interface.

SQLite dB is just a single file.
Any corruption likely kills the the whole database

That can happen with an uncontrolled shutdown.

I had that several times.

With Postgres never for 2+ years.


Sent from my iPhone using Tapatalk

Yes. If you ever have to pull the plug on a non responsive Mac or have a power failure it could corrupt your entire history. As it's a single file time machine won't be able to back it up either.
Post great just much more stable. Set and forget.
Grafana comes with influx dB such I also use but postgres is there as the ultimate catch all long term dB.


Sent from my iPhone using Tapatalk

I just put the Postgre Db as a separate VM. I used Linux as the OS; so it takes very little resources. Anything I do on the Indigo side of things (patching, etc.) doesn't directly impact the Db.

I put mine on an old server-class machine with Ubuntu as well, works out great... However, for the average user the Postgres app is a decent alternative.

I'm tempted to install SQL Server on that same Ubuntu box and test that out, though would have to modify the SQL Logger plugin to accommodate it. But that is beyond the average user too I guess, so the app would still be the easiest.

Indigo 7.3 (and 7.3.1) are now available and have support for the Dome Siren (DSM01) and Ring Contact Sensor (4SD1S70EN0) modules.

Thanks Matt. I have upgraded both houses to 7.3 and re-synced those devices. Works great.


Sent from my iPhone using Tapatalk

FYI, How to use the v1 Ring Keypad with the Match Raw Packet Z-Wave event type