[UPHPU] Re: SQLite - Is it a strong alternative?

[D. Turnbull]

SQLite is an interesting alternative, but it has some limitations. Last I
used it (about a year ago), it supported foreign-key syntax without actually
supporting foreign keys (I ended up simulating foreign-key behaviour with
stored procedures). And because its databases are simply files, it locks the
entire database every time you write to the file (meaning nobody can read
from the database until the write is done) -- of course, this means the
databases are uber-portable.

As to whether or not its a good alternative for you, only you can know that.
Search your feelings, there is good in you yet . . . use the SQL . . . and
so forth.

Dave


Subject: [UPHPU] SQLite - Is it a strong alternative ?
>
> I'm getting more and more convinced that simpler is better and usually
> more successful.  I appreciate the intro presentation we had several
> months ago.    The whole issue of low maintenance, easy backup, easy
> transportability  etc seems very appealing.  In that light (lite?), can
> SQLite really be used as a replacement for Postgres or MySQL  for a php
> driven web app ?   Has anyone here really put it to the test that way
> ?   We're not talking a massive consumer web service a la MySpace, just
> a normal business app.
>