[sqlite] Bug in sqlite? Can't read tables just after creating them

Hi, I found a problem in sqlite. In essence, here is what my code does: 1 - It opens a database file 2 - If it doesn't find certain tables, it assumes this is a new one and creates the necessary tables and add a few entries in one of them (let's call it mytable) 3 - It queries mytable by doing

[sqlite] Question about how sqlite recovers after a power loss

Hello, I would like to understand better at which moment does sqlite recovers from a previous power loss. Let's take the following scenario: - sqlite3_open() - BEGIN TRANSACTION; - INSERT INTO SomeTable VALUES ("blah", "blah", blah"); => Power loss! - sqlite3_open() What I notice, is that t