..@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
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,
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
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
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
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
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
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
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.
>
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
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
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
12 matches
Mail list logo