Given your summary of operations, things are not happening as they should. Yet, those operations are ones which are fundamental, common, well tested, and have been done by many applications using SQLite for many years. There is some, vanishingly small probability that the library is failing to adhere to the behavior documented for it. There is a higher probability, approaching 1.000..., that one or more of your operation summaries incorrectly summarizes what is actually being done. From what you have said so far, it is impossible for forum participants to see how your summaries fail to accurately describe the details of calls into the SQLite API. Further progress, here, must await your elaboration, in greater detail, of what you are doing rather than what you intended to do. (I presume your summaries reflect intent.)