Let's say we have the following Python code: import sqlite3 conn = sqlite3.connect('mydb.db') c = conn.cursor() c.execute("INSERT INTO ...") conn.commit() c.execute("INSERT INTO ...") conn.commit()
Can it be assumed that after conn.commit() has returned, fsync() has been called on the file and (assuming that fsync doesn't lie and doesn't just act as a barrier), the last inserted row has made its way to disk? Also, say that power is lost during the *second* conn.commit(). Is there a possibility that the database will be rolled back to the state before the first INSERT, or is it guaranteed that it will be rolled back to the state before the second INSERT? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users