On 11/17/2005 at 00:54 Preston Z wrote:
>
>Anybody have a better way to tell if a db is garbage?
You will know in the real world because things don't work randomly and
the users will complain.
My experience is like yours, a corrupt database can be worked with much
like a normal one so long as you stay away from any parts that are
corrupt.
In addition to the list of causes, I would like to add the one that bit
us:
Not noticing that sqlite requires that each instance be used in exactly
one thread of your program. (Someone in our early design decided to
wrap sqlite in a singleton class and then left. Since things worked
and he was a good programer normally we didn't find the problem until
customers ran into corruption)
