SQLite capabilities

edit

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.

From the Input Output Reference section for Output:Sqlite, "The description for SQLite outputs is described fully in the Output Details document." The Output Details and Examples document has over 20 pages detailing the contents of eqplusout.sql.

Here is the official SQLite Documentation: InputOutputReference.pdf

If you are looking for specific information that might not be documented, the easiest way is to open a database file up and start searching.

Check out the .schema and .table commands

I use grep to find information I need that isn't documented (Mac/Linux/Cygwin only):

sqlite3 -list DBNAME "SELECT * from TabularDataWithStrings" | grep -i "water"

Very powerful. Be sure to use the 'grep --color=auto' alias to make your searches pop.

I've noticed some bugs in the SQL output of E+ v8.2. Be warned. E+ v8.1 is more reliable in my opinion.

ScottB