Question-and-Answer Resource for the Building Energy Modeling Community
Get s tarted with the Help page
Ask Your Question

Revision history [back]

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 SQLite Manager

Then go to 'Browse & Search' to see all data in each table and/or view. Browse & Search

It is also possible to test SQL queries in SQLite Manager against the database. SQL query

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.

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 SQLite Manager

Then go to 'Browse & Search' to see all data in each table and/or view. Browse & SearchBrowse & Search

It is also possible to test SQL queries in SQLite Manager against the database. SQL querySQL query

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.