Global event for any state change

Hi all

I'm developing a database for the state of my devices over time (After all, how smart is a house if it doesn't remember anything?)

At the moment I have a python script that runs every 15 secs and posts every state of every device to my web service.

As you can imagine, that's both massively inefficient, and not granular enough. If a door sensor opens and closes in between that 15 sec interval, it will never be recorded in the DB.

Ideally, what I would like is a way to run a script when *any* device's state changes, as long as I can also find out which device / state changed

Can anybody suggest how this can be achieved?

Thanks!

Head to this page and have a look at the subscribeToChanges() method.

If you run sqllogger ALL that info is in the database
Why do you need another database?


Sent from my iPhone using Tapatalk

[jay (support)]

Karl's correct - the included SQL Logger plugin does this.

Darn it!

I wish I has asked this question before spending my weekend coding!

LOL!

And from experience : use Postgres much more robust and scalable than SQLite


Sent from my iPhone using Tapatalk