The SQL Logger Plugin for Indigo automatically logs device state changes, variable value changes, and event log entries to either PostgreSQL or SQLite.

This allows Indigo to integrate with other applications or services, and allows for historical data recording. 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 using the SQLite option fast.

Although more complicated, we have also put together basic instructions for using the more powerful PostgreSQL database server (see the docs link above for more information).