[UPHPU] SQLite - Is it a strong alternative ?

[jtaber]

Roberto Mello wrote:
> On Sun, Jul 30, 2006 at 08:56:42PM -0600, jtaber wrote:
>   
>> Well, I expect it to be mostly run across the web from central server
>> and I do expect a fair amount of writing and updating to the db.  Have
>> been using postgresql but just ran into the situation of not many
>> hosting companies support postgresql and would rather utilize a totally
>> free solution vs MySQL so thought that SQLite might be a viable
>> option.   My application is pretty MVC so switching to another db is not
>> too big a deal.
>>     
>
> SQLite is great, but will lock on write. There are several places out
> there who host with PostgreSQL, and many many hosting companies where you
> can just stick your server with whatever you want.
>
> And PostgreSQL is just awesome :-)
>
>   
Thanks everyone for the good comments - my conclusion: SQLite would be
great for pretty simple, mostly read apps, apps that have little
concurrency on the write side, and for portable or distributed apps.  
Our app doesn't really fit that so Postgres or MySQL makes more sense
but I'm glad I've investigated it.

Actually we've been using Postgresql for other applications and do
really like it.  But it seems only few a individuals or real small
companies serve up postgresql and at prices much higher than the big
host firms (we've actually had excellent success with the big firms). 
And while the big host firms offer dedicated servers, it requires a)
server setup expertise and b) more costly (ie around $100/mo) while
shared MySQL options are about $5-10 / mo - big difference in the early
product startup days.  I think dedicated makes more sense as the
application gains a significant customer base but for now might have to
use MySQL.