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