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

2014-02-26 Thread Fabrice Triboix
..@sqlite.org> Sender: drhsql...@gmail.com Date: Wed, 26 Feb 2014 05:40:27 To: <ftrib...@falcon-one.com>; General Discussion of SQLite Database<sqlite-users@sqlite.org> Subject: Re: [sqlite] Question about how sqlite recovers after a power loss On Wed, Feb 26, 2014 at 3:33 AM, Fabr

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

2014-02-26 Thread Richard Hipp
abrice > > --Original Message------ > From: Simon Slavin > To: Fabrice Triboix > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Question about how sqlite recovers after a power loss > Sent: 18 Feb 2014 08:57 > > > On 18 Feb 2014, at 8:13am,

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

2014-02-26 Thread Fabrice Triboix
Hi Max, Many thanks for your input. This is probably how it works. Best regards, Fabrice --Original Message-- From: Max Vlasov To: Fabrice Triboix To: General Discussion of SQLite Database Subject: Re: [sqlite] Question about how sqlite recovers after a power loss Sent: 26 Feb 2014

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

2014-02-26 Thread Max Vlasov
On Wed, Feb 26, 2014 at 12:33 PM, Fabrice Triboix wrote: > > And even then, that would not explain why the journal file lingers after > re-opening the database. > I remember asking a similar question. As long as I remember, the main logical implication is that journal

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

2014-02-26 Thread Fabrice Triboix
Triboix To: General Discussion of SQLite Database Subject: Re: [sqlite] Question about how sqlite recovers after a power loss Sent: 18 Feb 2014 08:57 On 18 Feb 2014, at 8:13am, Fabrice Triboix <ftrib...@falcon-one.com> wrote: > Actually, the journal file does not get deleted when I do

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

2014-02-18 Thread Simon Slavin
On 18 Feb 2014, at 8:13am, Fabrice Triboix wrote: > Actually, the journal file does not get deleted when I do a SELECT just after > opening the database. Depending on your journal mode (I think), the journal file should be deleted, but then it will immediately be

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

2014-02-18 Thread Fabrice Triboix
org> Sender: drhsql...@gmail.com Date: Sat, 15 Feb 2014 09:57:03 To: <ftrib...@falcon-one.com>; General Discussion of SQLite Database<sqlite-users@sqlite.org> Subject: Re: [sqlite] Question about how sqlite recovers after a power loss On Sat, Feb 15, 2014 at 9:55 AM, Fabrice Triboi

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

2014-02-15 Thread Kees Nuyt
On Sat, 15 Feb 2014 14:55:48 +, "Fabrice Triboix" wrote: > Hi Richard, > > All right, many thanks for that. So if I do, say, > a SELECT just after opening the database, that's > when the recovery will actually take place and > the journal file will be replayed and

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

2014-02-15 Thread Richard Hipp
On Sat, Feb 15, 2014 at 9:55 AM, Fabrice Triboix wrote: > Hi Richard, > > All right, many thanks for that. So if I do, say, a SELECT just after > opening the database, that's when the recovery will actually take place and > the journal file will be replayed and deleted. >

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

2014-02-15 Thread Fabrice Triboix
bject: Re: [sqlite] Question about how sqlite recovers after a power loss On Fri, Feb 14, 2014 at 10:13 AM, <ftrib...@falcon-one.com> wrote: > Hello, > > I would like to understand better at which moment does sqlite recovers > from a previous power loss. > > Let's take the followin

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

2014-02-15 Thread Richard Hipp
On Fri, Feb 14, 2014 at 10:13 AM, wrote: > 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

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

2014-02-15 Thread ftriboix
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