On Wed, Jun 15, 2011 at 1:39 PM, Sam Roberts <[email protected]> wrote:
> > It would appear that sqlite3 does not immediately write DELETEs to > disk. I have confirmed this behavior by pausing my Django app > immediately upon entrance into my database hook callback, running > sqlite in another process and examining the .db file on disk – the > deleted record is still present. > No. SQLite processes DELETEs as soon as they are entered, just like INSERTs and UPDATEs. I think you have an application bug. Perhaps the WHERE clause of the delete is not selecting any rows. Or perhaps you are rolling back the delete transaction without realizing. it. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
