Logging Event data into a SQL Database

Indigo has the ability to log data into either SQLite databases (10.5 or greater) or PostgreSQL databases. You can choose to log device changes, variable changes, and/or event log data. The latter can generate quite a large amount of data, and the client doesn't attempt to delete any data, so you'll need to periodically purge data yourself.

SQLite Configuration

In Indigo Pro on Leopard (10.5.x) systems, the SQLite libraries are built-in, so having Indigo log into a SQLite database is Simple:

  1. Open the config file (/Library/Application Support/Perceptive Automation/Indigo 4/IndigoSqlClient/IndigoSqlClient.conf) in your favorite text editor and make sure that database_type = sqlite. You can also specify what is written out to the database: by default, device changes and variable changes are logged (they have a non-zero value) and all events in the event log are NOT logged (it is set to zero). You can also change the name of the database (default is sqlite_db), but it's not recommended. NOTE: the database file is stored in the same directory as the config file. Save any changes you made.
  2. Turn on the Log Device state history to SQLite or PostgreSQL option in the Start Local Server… dialog from the Indigo 4 menu

PostgreSQL Configuration

Follow these directions to enable PostgreSQL logging. This How-to level of difficulty is Hard.

sql_logging.txt · Last modified: 2019/01/25 22:53 (external edit)

© Perceptive Automation, LLC. · Privacy