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

[cole at colejoplin.com]

I used SQLite when I worked at ContentWatch. It's great for small  
client apps with single user access. That's really what it was  
designed to do.

SQLite is very portable (single file db), very small, and has no  
config to set up. It's string sizes are only limited to memory (way  
cool). But there's no referential integrity. And column types are not  
enforced (which could be a problem if you have a string in an  
integer-"preferred" field and you want to transport to another db).

For web, multi-user access could be a problem, even for a business  
app. So, I really wouldn't use it for that. I'd just run with MySQL,  
because that's exactly what it was designed to do.

-- Cole



Quoting "D. Turnbull" <turnbud at gmail.com>:

> 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.
>>
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net