
IndigoSqlClient -- logging changes to SQLite or PostgreSQL
IndigoSqlClient
The IndigoSqlClient can be used to efficiently save Indigo Device state changes, Variable value changes, and Event Log messages to either a SQLite database or a PostgreSQL database. IndigoSqlClient is a seperate process that Indigo Server can automatically launch (and terminate) that hooks into all device state and variable value change messages from the Indigo Server. This allows Indigo to integrate with other applications or systems, and allows for historical data tracking. You can, for example, use PHP to dynamically generate graphs or charts of device states (like temperature) stored in a PostgreSQL database.
By default, OS X 10.5 and higher includes the libraries needed to use SQLite, which makes
configuring SQLite simple.
Although more complicated, we have also put together basic instructions for users
needing to use PostgreSQL.