To do Upserts in SQLite, I'm doing INSERT OR IGNORE... then UPDATE. As a result, the row count of a successful Upsert may be 1 or 2. As a work around, to test for a success, use something like row count > 0 && row count <= 2