As I mentioned in another response, I truly dislike SQLite, based on my
experience with it on my Garmin GPS.

I'm still not sure why - my experience has been very good.  What bad
experiences have you had?
~~
Mark Moulding


My Garmin has had data integrity issues in its database.  Plus, lack of
*convenient* tools, and having to rummage around here and there to find
them.

On top of that, this will be part of an online web app some day, so
having the database in the address space of the web server is probably
not a Good Thing.

I haven't used SQLite in an embedded environment yet. I wonder if it tends to thrash certain areas of the data file (which would cause flash wear problems). I appreciate the data point...

And yes, SQLite was not intended for a high-volume multi-access environment, and my experience is definitely from embedded up through low multi-user local network applications. I'm sure there are many good reasons why MySQL has become the standard for web server applications. I originally understood - perhaps erroneously - that this was to be a smallish, local application, and for me (and the smallish types of systems I tend to build), I'd prefer to avoid the headache of administering the MySQL subsystem.

But I stand by my statements about the separate, non-editable keys... :-)
~~
Mark Moulding

Reply via email to