RE: MySQL vs postgres

["Will Fitzgerald" <fitzgerald@xxxxxxxxxxxx>]

> -----Original Message-----
> From: imago [mailto:imago@imago3d.com]
> Sent: Monday, June 12, 2000 8:47 AM
> To: members@kalamazoolinux.org
> Subject: Re: MySQL vs postgres
>
>
> My application would benifit by record locking so I am thinking
> postgres is the right tool to use.
>
> As a novice user of linux, SQL type db's apache and php, I have
> noticed that the books I have aimed at getting the php web system
> environment compiled, installed and running say little or nothing
> about postgres. They giveexplicit commands and directions to use
> MySql!
>
> Why is this? Heavy traffic on web applications, like a real time
> auction, hopefilly will have many concurrent users and overlapping
> sessions working on the same records in the same tables.  Seems to
> me record locking is essential for accuracy and efficienncy.
>
> Are there other issues why MySQL is the db of choice for people who
> write the php books?
>
> imago
>
>
>

I think this is largely analogical. MySQL is to real databases what PHP
is to real computer languages: sloppy but fast and easy to learn.