gt;
>>
>>
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd
>> Sent: Tuesday, December 11, 2012 1:00 AM
>> To: General Discussion of SQLite Database
>> Subject: Re: [sq
r the error
> locally much more quickly with stack protection on then in a random system.
>
>
>
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd
> Sent: Tuesday, December 11, 2012 1:00 AM
On 11 Dec 2012, at 6:00pm, Roger Binns wrote:
> Chances are that whatever corrupts your databases would also corrupt the
> backups. Here is something the Windows team found:
>
> http://blogs.msdn.com/b/oldnewthing/archive/2005/04/12/407562.aspx
Right. I don't have experience with motherboar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/12/12 03:46, dd wrote:
> But in customers place, I am getting corruptions.
Chances are that whatever corrupts your databases would also corrupt the
backups. Here is something the Windows team found:
http://blogs.msdn.com/b/oldnewthing/archiv
eral Discussion of SQLite Database
Subject: Re: [sqlite] table backup
Hi Roger,
I don't have any clue. Two databases are corrupted. First one, while
inserting 20,000 records suddenly sqlite thrown disk io error at 4,000
record. No clue.
Second database corrupted when my application cr
On 11 Dec 2012, at 11:46am, dd wrote:
> I tested with millions of records. Sqlite is stable and reliable. It is
> suitable for my application. So, I have chosen.
> But in customers place, I am getting corruptions. Within 6 months I got 4
> corruptions.
That is a good test. My conclusion is tha
I tested with millions of records. Sqlite is stable and reliable. It is
suitable for my application. So, I have chosen.
But in customers place, I am getting corruptions. Within 6 months I got 4
corruptions. I do integrity check when app launch. But, critical data is
there with corrupted database. H
On 11 Dec 2012, at 7:00am, dd wrote:
> I don't have any clue. Two databases are corrupted. First one, while
> inserting 20,000 records suddenly sqlite thrown disk io error at 4,000
> record. No clue.
>
> Second database corrupted when my application crashed. But that time,
> second database w
Sorry, but the virtual table extensions I have written are all proprietary.
Gunter
-Ursprüngliche Nachricht-
Von: dd [mailto:durga.d...@gmail.com]
Gesendet: Dienstag, 11. Dezember 2012 08:00
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] table backup
Hi Roger,
I
Hi Roger,
I don't have any clue. Two databases are corrupted. First one, while
inserting 20,000 records suddenly sqlite thrown disk io error at 4,000
record. No clue.
Second database corrupted when my application crashed. But that time,
second database was not opened.
So, I am planning to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/12/12 21:44, dd wrote:
> Sometimes, sqlite databse corrupts.
That is the problem you need to fix. If you have a system that is
unreliable then it will also corrupt your backups.
http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://www.sq
durga.d...@gmail.com]
Gesendet: Montag, 10. Dezember 2012 06:45
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] table backup
Sometimes, sqlite databse corrupts. So, I want to take online backup of
specific table. Not entire database. Any best solution?
On Sun, Dec 9, 2012 at 11:29 PM
Sometimes, sqlite databse corrupts. So, I want to take online backup of
specific table. Not entire database. Any best solution?
On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/12/12 10:35, dd wrote:
> > i mean, for every write oper
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/12/12 10:35, dd wrote:
> i mean, for every write operation in a table.
You should specify some of your other constraints and exactly what it is
you are trying to achieve (*not* how you are trying to achieve it).
The solutions range from impleme
i mean, for every write operation in a table.
On Sun, Dec 9, 2012 at 11:55 PM, dd wrote:
> Hi All,
>
> What is the best way to do online backup for a particular table for
> every write operation in a sqlite db. Not entire database.
>
> Best Regards,
> d
>
_
Hi All,
What is the best way to do online backup for a particular table for every
write operation in a sqlite db. Not entire database.
Best Regards,
d
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinf
16 matches
Mail list logo