SQLite reliability - Re: cctalk Digest, Vol 15, Issue 24

[Toby Thain]

On 2015-09-24 5:37 PM, mark at markesystems.com wrote:
>>> I don't know what you're looking at for the front end of this project,
>>> but have you considered SQLite for the database engine back end?  If
>>
>> No, I would not consider it.  I have experience with it on my Garmin GPS
>> unit.  I really dislike it.
>
> Wow - I'm quite surprised at that. ...
>
> I have used it on PC platforms, and have been quite impressed with how
> robust the database structure is. ...
> I use it for industrial automation applications, and have tested it a
> lot to see if I could corrupt the database.  Basically,  unless I
> deliberately mangled the container file, I couldn't get it to fail
> non-gracefully, even by turning of the power while writing the file.
> (This was not a full, rigorous failure study, but I've got a lot of them
> out there now, and although I get plenty of support calls a screwed-up
> database is never the root cause.)

Dr Richard Hipp has often spoken about the software engineering 
practices they use to make SQLite robust.

It is something they particularly care about.


--Toby


>
> Just my experience...
> ~~
> Mark Moulding
>