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

[jtaber]

D. Turnbull wrote:
> 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.
I guess that means only 1 concurrent user if files are being written to
a lot unless we give each account (which will probably only have 1
concurrent user) it's own database.  Actually we have considered this
for added security reasons (clients will probably feel better if they
have their own database).  But not sure if a multi db strategy is good. 
I think other sites like 37signals backpack just use 1 master db.