update api to use sqlite3 integer types for booleans