After performing DELETE queries on my SQLite3 DB, I noticed it took affect in the RSR view, but not in the actual database. I thought maybe everything is in a transaction, so I made the query COMMIT; and got the message back "cannot commit, no transaction is active." Despite the error message, this did cause the deleted to propagate to the actual database.
In Crunchyfrog things works as expected.