Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
One possibility is to use sqlite-manager to view the sqlite file. This is usually the way I view the data and debug my queries, although there are many other resources for viewing and querying SQL files.
In Firefox, go to Tools... SQLite Manager
Then go to 'Browse & Search' to see all data in each table and/or view.
It is also possible to test SQL queries in SQLite Manager against the database.
This is a better Trial and Error approach to what data and reports are available in SQLite.
The SQLiteProcedures.hh and SQLiteProcedures.cc in EnergyPlus show explicitly what is output from EnergyPlus to the SQLite file.
| | 2 | No.2 Revision |
One possibility is to use sqlite-manager to view the sqlite file. This is usually the way I view the data and debug my queries, although there are many other resources for viewing and querying SQL files.
In Firefox, go to Tools... SQLite Manager
Then go to 'Browse & Search' to see all data in each table and/or view.
It is also possible to test SQL queries in SQLite Manager against the database.
This is a better Trial and Error approach to what data and reports are available in SQLite.
The SQLiteProcedures.hh and SQLiteProcedures.cc in EnergyPlus show explicitly what is output from EnergyPlus to the SQLite file.
