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

Revision history [back]

click to hide/show revision 1
initial version

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.