24 Sep
2015
24 Sep
'15
3:45 p.m.
On 2015-09-24 5:37 PM, mark at markesystems.com wrote:
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
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.
Just my experience...
~~
Mark Moulding