Re: [sqlite] Re: fault tolerance

2006-08-17 Thread John Stanton
Your aim appears to be to have data recovery from hardware and operating system failures. That is beyond the power of Sqlite and needs to be designed into your system or the hardware. Logginjg or replication onto different media would provide the redundancy and diversity you seek. Olaf Beckm

Re: [sqlite] Cannot compile with SQLITE_OMIT_VIRTUALTABLE

2006-08-17 Thread Miguel Angel Latorre Díaz
Oops. Ok, I got it. Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: fault tolerance

2006-08-17 Thread Olaf Beckman Lapré
It depends on what gets corrupted. I found that alterring the data of the tables itself didn't result in crashes but SQLite is very sensitive to corrupted system tables and file headers. So the data is ussually recoverable as long as the database can be brought into a readable state. This means tha

Re: [sqlite] Cannot compile with SQLITE_OMIT_VIRTUALTABLE

2006-08-17 Thread drh
=?iso-8859-1?Q?Miguel_Angel_Latorre_D=EDaz?= <[EMAIL PROTECTED]> wrote: > Lattest cvs sqlite version: > If SQLITE_OMIT_VIRTUALTABLE is defined linker complains about: > > parse.obj : error unresolved external symbol _sqlite3VtabArgExtend in > function _yy_reduce > parse.obj : error unresolved e

[sqlite] Re: fault tolerance

2006-08-17 Thread Dave Dyer
> >Most of us use email clients that store our mail as simple text files. An >SQLite database is no more likely to get corrupted than any other file. I would stipulate that sqlite data is less likely to be corrupted due to bugs in sqlite itself, or due to power failure or gross program crashes.

[sqlite] Cannot compile with SQLITE_OMIT_VIRTUALTABLE

2006-08-17 Thread Miguel Angel Latorre Díaz
Lattest cvs sqlite version: If SQLITE_OMIT_VIRTUALTABLE is defined linker complains about: parse.obj : error unresolved external symbol _sqlite3VtabArgExtend in function _yy_reduce parse.obj : error unresolved external symbol _sqlite3VtabArgInit in function _yy_reduce parse.obj : error unreso

Re: [sqlite] Re: fault tolerance

2006-08-17 Thread Gerry Snyder
Olaf Beckman Lapré wrote: For me this is simply a must! I'm using SQLite in my e-mail client which I hope will be one of the first large scale deployments of SQLite where it will be used heavily on a daily basis. I think you are too late to claim this honor. If the database is corrupted then p

Re: [sqlite] Re: fault tolerance

2006-08-17 Thread Olaf Beckman Lapré
For me this is simply a must! I'm using SQLite in my e-mail client which I hope will be one of the first large scale deployments of SQLite where it will be used heavily on a daily basis. If the database is corrupted then people lose all their e-mails and that's simply intolerable! I can't release m