[esp-r] Sqlite results output: setup

[Amar Seeam]

Hi all,

I have compiled ESP-r with SQlite output and was wondering if there are
any examples or documentation on the data structure produced?

I am quite comfortable using SQLite through perl, and I am only
interested in querying for:

Zone Temperature
Zone Heating Load
Climate Temperature
Climate Direct Solar 

with one minute timesteps (my input is one minute imposed data).

Is this possible? And how can this be done ? I have successfully managed
to output CSV using input.xml- do I need to do something similar?

Thanks in advance.

Amar.