Hi, 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? (kinda OT for Zope, but which has the better full-text search capability?) cheers, Chris
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. -- Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy I'll give spammers one bite of the apple, but they'll have to guess which bite has the razor blade in it.
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."
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.
for full text index/search for postgres take a look at openfts.sf.net kapil On Monday 03 September 2001 12:33 am, Chris Withers wrote:
Hi,
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?
(kinda OT for Zope, but which has the better full-text search capability?)
cheers,
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (5)
-
Andy Dustman -
Antonio Carrasco -
Chris Withers -
kapil thangavelu -
Russell Hires