SQLite reliability - Re: cctalk Digest, Vol 15, Issue 24
toby at telegraphics.com.au
Thu Sep 24 17:45:33 CDT 2015
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.
> Just my experience...
> Mark Moulding
More information about the cctech