[OT] Re: [Rails] mysql vs postgres

[Ara.T.Howard]

On Thu, 10 Mar 2005, Michael Koziarski wrote:

>> Not a bad idea.
>>
>> When would you probably "need" to have a full-fledged RDMBS with a
>> Rails app?  (you'll note I inserted that qualifier to keep this OT :-)
>
> 2 or more web servers would probably be a PITA with sqlite,  NFS sucks etc.
> etc.  But if your app needs two servers,  it's probably already big enough
> to have hit some of the concurrency problems  already.
>
> If you want other applications to read your data, sqlite could be a problem.
>
> On the whole though,   you can do sqlite in development and switch to mysql
> once your app is reasonably complete.

this is all true.  however i should point out to that sqlite is quite capable
with only a little bit of additional coding to acheive concurrency: as we
speak i'm running tens of thousands of jobs through an nfs mounted sqlite
'queue' with 50, or more, applications accessing the db.  my point being that
sqlite is quite useable in production environments if you understand it well.
i my case working with some of it's limitations was easier than using our
mysql dbs.

-a
-- 
===============================================================================
| EMAIL   :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE   :: 303.497.6469
| When you do something, you should burn yourself completely, like a good
| bonfire, leaving no trace of yourself.  --Shunryu Suzuki
===============================================================================