[Zope] MySQL and Zope

scott kaplan skaplan@wso.williams.edu
Fri, 29 Oct 1999 23:52:23 -0400 (EDT)


Under the interface to MySQL section of the products on zope.org
at
http://www.zope.org/Members/adustman/MySQLdb

it reads :
A patch is included which will update ZMySQLDA (which uses an older,
non-thread-safe MySQL interface) to use _mysql. It is expected that DC
will eventually incorporate this patch once it is fully tested. 

So i think this will patch up ZMySQLDA, to be all nice and thread safe,
but i haven't used it, so I can't be sure

scott kaplan
scott@drsource.com
skaplan@wso.williams.edu


On Fri, 29 Oct 1999, Jose de Leon wrote:

> Does this mean I can't use MySQL with Zope?  Is there an alternative
> database connector to MySQL?  I'm intending to create a rather large site
> with heavy dependence on MySQL.
> 
> I haven't yet looked at the source for ZMySQLda, (mainly because I can't
> find it either), but if I have to modify it to make it thread-safe I will.
> I just need some help setting up at least simple connection to MySQL
> database so I can have something to work with.
> 
> ----- Original Message -----
> From: Phil Harris <phil@wigwamweb.net>
> To: <flight@mathi.uni-heidelberg.de>; Jose de Leon <jadiel@thevision.net>
> Cc: <zope@zope.org>
> Sent: Friday, October 29, 1999 2:44 PM
> Subject: RE: [Zope] MySQL and Zope
> 
> 
> Gregor,
> 
> IIRC ZMySQLda is no longer 'supported' as it is not thread safe, that said I
> use it in a multi thread environment and it seems OK for simple selections.
> 
> HTH
> 
> phil
> phil@wigwamweb.net
> 
> > -----Original Message-----
> > From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> > flight@mathi.uni-heidelberg.de
> > Sent: 29 October 1999 22:11
> > To: Jose de Leon
> > Cc: zope@zope.org
> > Subject: Re: [Zope] MySQL and Zope
> >
> >
> > On Fri, Oct 29, 1999 at 02:02:19PM -0700, Jose de Leon wrote:
> > > But...I have yet to find any information on how to get Zope to
> > select and
> > > insert data to a MySQL database.  I've downloaded and attempted
> > to install
> > > MySQLdb from www.zope.org
> >
> > MySQLdb is only a Python MySQL module, to access MySQL databases from Zope
> > you need (also) the ZMySQLDA product.
> >
> > Strange coincidence: Just in this moment, I was about to write a
> > mail to the
> > list and ask why ZMySQLDA is no longer available on zope.org. IIRC, it
> > used to be on the old site.
> >
> > Gregor
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://www.zope.org/mailman/listinfo/zope
> >
> > (Related lists - please, no cross posts or HTML encoding!
> >
> > To receive general Zope announcements, see:
> > http://www.zope.org/mailman/listinfo/zope-announce
> >
> > For developer-specific issues, zope-dev@zope.org -
> > http://www.zope.org/mailman/listinfo/zope-dev )
> >
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
> 
> (Related lists - please, no cross posts or HTML encoding!
> 
> To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
> 
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )
> 
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
> 
> (Related lists - please, no cross posts or HTML encoding!
> 
> To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
> 
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )
>