Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

For the record, the problem was that django (by default) starts a transaction before handing an http request, then commits it after the request is handled. Since we were in the middle of a transaction, all the python/django code we wrote saw the state of the DB as it was partially through a

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

Simon, Thank you for your response. The callback function is called when Django's table object's delete method is called, and not by sqlite's DELETE command. I do not know what callback functionality is provided by sqlite, but I don't believe it is being used in this case. We have solved

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

Jean-Christophe, Thanks for your response. The backup feature looks promising. If we can figure out how to access it within Django then it looks like it is what we need. Kevin Yoo Certification Lead Wurldtech Security Technologies 1680-401 West Georgia St. Vancouver, BC, V6B 5A1   Phone:

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

On 15 Jun 2011, at 10:38pm, Jean-Christophe Deschamps wrote: >> and >> when the callback function is entered, Django claims that the DELETE >> statement has been executed. Is this the callback function called /by/ the DELETE command ? If so, it's called before the DELETE command is

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

Kevin, >I have confirmed that the DELETE does indeed delete the record, but >only after Django's delete callback has completed. If what you say is >true, that DELETEs are proceed immediately, then the only other >explanation is that Django, upon sending of the post_delete signal, >has not

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

Richard, Thank you for your response. I have confirmed that the DELETE does indeed delete the record, but only after Django's delete callback has completed. If what you say is true, that DELETEs are proceed immediately, then the only other explanation is that Django, upon sending of the

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

On Wed, Jun 15, 2011 at 1:39 PM, Sam Roberts 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

[sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

I'm posting this for one of my coworkers whos email isn't showing up. -- Forwarded message -- From: Kevin Yoo I am writing a Django app with sqlite. I am using Django’s database hook framework to perform certain actions on sqlite’s db file: namely, whenever