spiffbot/docs/sqlite.md

This file will store any corrections or nuance about using sqlite.

Boolean

Due to a restriction of sqlite, we must use Integer data types to represent a boolean value.

To do so the value must be either 0 meaning false, or 1 meaning true.

The database accessor will do this conversion for you automatically, so this will only matter to people working on the database accessor.