[Zope] MySQL or PostGres

Antonio Carrasco antoniojezu@hotmail.com
Mon, 3 Sep 2001 01:53:23 +0200


Hello all, (remember, iīm spanish)
----- Original Message -----
From: "Andy Dustman" <andy@dustman.net>
To: <zope@zope.org>
Sent: Monday, September 03, 2001 6:17 PM
Subject: Re: [Zope] MySQL or PostGres


> 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?

This is the same question iīm trying to answer. Iīm using ZPoPy_DA and Itīs
an stable version. I had problems with strings in ZSQLMethod but it has a
solution. Ok, I donīt know If it has more problems (is the name 'fixes' or
'bugs'?), but I have used it, and my Zope didnīt crash.

I havenīt use ZMySQLDA, but Andy does. I think you donīt have to worry about
DA, so if you want some tables with results of MySql or PostGres (Not Zope
DA) querys (selects, inserts, updates,...) and a very complete definition of
properties of each DB,  Iīll send you but out of this list, "not to waste
bandwitdth list". (somebody say it and i liked it!), and you can decide
later what is better for your project (or for you).


>
> 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.

Regards:
Antonio Carrasco
"If you look heedfully Reality, you will be able to see Pixels."