View unanswered posts | View active topics It is currently Mon Mar 22, 2010 9:49 am



Reply to topic  [ 3 posts ] 
 IndigoSqlClient -- logging changes to SQLite or PostgreSQL 
Author Message
Site Admin
User avatar

Joined: Jan 27, 2003
Posts: 7691
Location: Texas
Post 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.


Mon Apr 14, 2008 10:59 am
Profile WWW

Joined: Aug 05, 2007
Posts: 7
Post Re: IndigoSqlClient -- logging changes to SQLite or PostgreS
support wrote:By default, OS X 10.5 and higher includes the libraries needed to use SQLite, which makes configuring SQLite simple.

Matt,
what about Mac OS 10.4? How can I activate SQLite for Mac OS 10.4?


Wed May 21, 2008 9:36 pm
Profile
Site Admin
User avatar

Joined: Jan 27, 2003
Posts: 7691
Location: Texas
Post Re: IndigoSqlClient -- logging changes to SQLite or PostgreS
You will have to install python version 2.5 or greater for SQLite support on OS X 10.4. I've never done that, so I don't have step-by-step instructions. You might just want to try PostgreSQL if you are running 10.4. I have gotten that working before.

Regards,
Matt


Thu May 22, 2008 1:53 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.   Template designed by STSoftware.