I've just looked at your SQL Logger plugin for the first time (using Postgres, if that matters), and I've got a bunch of questions. (Surprised? )
What is the typeval column in the eventlog_history?
Does the logger write any device configuration to the database? I.e. is the state of the Indigo device database reflected there? Any data that lets me translate id numbers to device names?
Any way to just get some device state logs, instead of all or none?
Any way to put all the device states into one table (or at least all devices of the same type)? Giving each temperature sensor its own table makes it rather unpleasant to write a query for all temperatures in the house.
Any way for my plugin to use your plugin's connection to write its own data to the database? Any way for my plugin to query the database?
Is there a supported way to use the SQL module (short of ripping a copy out of your plugin and sticking it into mine)?
Nice plugin, by the way.
Cheers
-- perry