Question-and-Answer Resource for the Building Energy Modeling Community
 | 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.
ScottB
