Re: PHP 5.0.0 Beta 1 : alternatives to MySQL?

How does Postgres compare to MySQL? I've been using MySQL for quite some time on sites with millions of hits a day without performance problems (the big upshot to MySQL is that select queries are very fast, the big downside is that insert and update queries are sometimes unstable, so you code for as few writes as possible). I've been telling people for 4+ years that it's the way to go - you can toss up 10 reasonable Linux servers and a load balancer for half the price you'd pay to deploy a couple comparable Windows servers. Serving dynamic web sites doesn't take a GUI and it's better to have many small, fast servers than one huge server... I've long advocated one very large box with a high-performance commercial database (DB2 or Oracle) and a large number of cheap Linux boxes in front of it processing page requests behind a common firewall and a load balancer. The sky is the limit with a setup like that, it's really cheap, and best of all - it's redundant. On Wed, 2003-07-02 at 12:05, Graham Clarke wrote: > Stan - We just jumped into RedHat & Postgres & love it. After years of MS > SQL, w2k server, etc... we started a project this spring where open source > server software was a must. for $600 I've got a used VALinux running > apache, postgres, & php. > > Postgres is really good. Fast and powerful. We now prefer it over MS SQL. > > It's definitely a change in mind set, but so much cleaner and more simple > than windows. Setting up PEAR was effortless. I could go on & on. Wish > I'd started using linux years ago. > > Graham > > > For > At 09:46 AM 7/2/2003 -0500, Stan Lemon wrote: > >Markus, > >I've been watching them talk about that for quite some time, and would > >love for them to finally do that. However, I question their (mid 2003) > >projection, and honestly think that we windowers are going to have to wait > >a big longer. > > > >- Stan > > > >P.S. How is it possible for me to get the SQLite dcumentation off of CVS, > >I've never touched CVS before so I'm starting anew. > > > >Markus Wolff wrote: > > > >>Stan Lemon wrote: > >> > >>>Postgre would hold a possibility if tere was a decent Win32 copy > >>>out. I've played with their current release, which you need to cygwin > >>>to run, I think I'd rather try compiling PHP w/ mySQL after that > >>>experience. It was horrible, no joke. (I would be interested in anyone > >>>who has somehow managed to get it wo work.) > >> > >> > >>The next Version of PostgreSQL (7.4, I believe) is supposed to have > >>native Windows support without the need for Cygwin and the like. I don´t > >>know when it´s gonna be out, though. > >> > >>Regards, > >> Markus > >> > > > > > > > >-- > >PEAR General Mailing List (http://pear.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > Graham Clarke > GrahamC@53Tech.com > www.53Tech.com > 603.643.9955 >