[Zope] MySQL or PostGres

[Russell Hires]

I think that this might be better suited to the zope-db@zope.org list. 

And now, a comment: there's a good comparison that I got a link from 
linuxtoday.com : http://www.webtechniques.com/archives/2001/09/jepson/

HTH

Russell
On Monday 03 September 2001 12:17, you wrote:
> On 03 Sep 2001 08:33:29 +0100, Chris Withers wrote:
> > Which out of MySQL or PostGres would work better with Zope?
> > Which has the more stable DA and what one should I use in each case?
>
> I don't actually use PostgreSQL at this point, so I can't compare.
> ZMySQLDA 2.0.7 seems pretty stable, and it does support transactions if
> you use BDB or InnoDB tables. The InnoDB table support is still somewhat
> beta at this point, from what I can tell. However, lots of people seem
> to use ZMySQLDA without transactions and it works fine. It depends on
> your application.
>
> Some else made the inevitable car analogy. I would say MySQL is not so
> much a Ferrari but more like a dragster: Very fast, as long as you don't
> have to make any turns. I'm not sure what PostgreSQL would be; I hear
> version 7 is greatly improved over version 6.
>
> > (kinda OT for Zope, but which has the better full-text search
> > capability?)
>
> I believe MySQL-3.23 has a full-text search, but check the on-line
> documentation at http://www.mysql.com.