On Fri, Jan 21, 2011 at 9:18 PM, Artur Reilin wrote:
> > We've thought about that before, but never could come up with a
> reasonable
> > suggestion.
> >
>
> Something like an hash key in every db and also in a journal, if it is
> created, the same key as well. So if the db hash key and journal h
> We've thought about that before, but never could come up with a reasonable
> suggestion.
>
Something like an hash key in every db and also in a journal, if it is
created, the same key as well. So if the db hash key and journal hash key
doesn't match, the journal will not be used.
___
Richard,
On Jan 21, 2011, at 5:41 PM, Richard Hipp wrote:
> On Fri, Jan 21, 2011 at 8:27 PM, James Berry wrote:
>
>> (1) Is there any API I can/should use to predictably get the name of
>> the journal file so that I can delete it, without "knowing" what is should
>> be?
>>
>
> The name
On Fri, Jan 21, 2011 at 5:33 PM, Pavel Ivanov wrote:
>> (2) Are there any changes that can/should be made
>> to sqlite3 so that it can identify the bogus journal in this
>> scenario and discard it?
>
> Define the word "bogus". How should SQLite understand that the journal
> and the database
On Fri, Jan 21, 2011 at 8:27 PM, James Berry wrote:
> I ran into an interesting problem today having to do with a left-over
> journal file.
>
> When I first initialize my app, my general strategy is this:
>
>- Delete src.db, tmp.db, dst.db
>- Copy a static copy of my database (src
On 22 Jan 2011, at 1:27am, James Berry wrote:
> - Delete src.db, tmp.db, dst.db
> - Copy a static copy of my database (src.db) to a well-known temporary
> place (tmp.db).
> - Make some changes to the database (add some indexes, etc)
> - If everything has succeeded, copy t
> (1) Is there any API I can/should use to predictably get the name of
> the journal file so that I can delete it, without "knowing" what is should be?
Suffix -journal is hardcoded and won't change in the future to keep
compatibility (journals left by any previous version should be read by
I ran into an interesting problem today having to do with a left-over journal
file.
When I first initialize my app, my general strategy is this:
- Delete src.db, tmp.db, dst.db
- Copy a static copy of my database (src.db) to a well-known temporary
place (tmp.db).
- Make
8 matches
Mail list logo