July 1999 - Zope - Zope lists

Re: [Zope] ODBC DA for unix coming?
by Christopher Petrilli 19 Jul '99

19 Jul '99

> Well, I know that mxODBC > (http://starship.python.net/crew/lemburg/mxODBC.html) is a python DB > API 2.0 interface that works on top of the free IODBC > (http://www.iodbc.org) > > I don't really know what I'm talking about - but it would be > really nice to have an ODBC interface. The Cold Fusion guys at work > seem to be able to get Cold Fusion to work with any DB ("OH, we'll > just use the ODBC driver.") Some day, I hope to sell them Zope. There are three levels really to ODBC: 1. The "ODBC adapter" (such as mxODBC, etc) 2. The manager (such as iODBC) 3. The database driver (such as Oracle, etc.) At least this has been my understanding I've been operating under. I just looked at iODBC, and I don't see anything in it to let it talk to say, Microsoft SQL Server (an ODBC only database, unless you know that it's really only Sybase underneath :-). How would I do this? Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli(a)digicool.com http://www.digicool.com

2 2

Re: [Zope] ODBC DA for unix coming?
by Christopher Petrilli 19 Jul '99

19 Jul '99

> > > I was just wondering if there are plans for DC to release an ODBC DA > for unix? Well, in many ways the SOLID DA is ODBC :-) The problem is more that we don't have any ODBC drivers on UNIX to try and test things with, it should be a trivial effort otherwise. I know there have been some efforts at a free ODBC implementation, but I've not seen any give fruit. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli(a)digicool.com http://www.digicool.com

2 1

RE: [Zope] Newbie looking for tutorial
by Michel Pelletier 19 Jul '99

19 Jul '99

> -----Original Message----- > From: Ryan Grace [mailto:grace@laurel.humboldt.edu] > Sent: Monday, July 19, 1999 1:23 PM > To: zope(a)zope.org > Subject: [Zope] Newbie looking for tutorial > > > Hi All. > > Well, I've downloaded and installed Zope on my Linux box, but > I can't find > much in the way of examples to follow to learn how to use it. > Does anyone > know of a good (or otherwise) beginning Zope tutorial? > Thanks in advance. > Zope is pretty large and complex. You won't find one tutorial to teach it all to you. This is sort of like asking for a Linux Managment tutorial when you've never used Unix. The topic is too broad. The Zope Content Managers Guide: http://www.zope.org/Documentation/Guides/ZCMG/ZCMG-HTML/ZCMG.html has a good beginners tutorial for creating simple Zope content. -Michel > Ryan > grace(a)humboldt.edu > > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: [Zope] MySQLDA performance
by erikm＠islandnet.com 19 Jul '99

19 Jul '99

>Erik Myllymaki wrote: >> >> I have been doing some tests (admitedly incomplete and unscientific) with >> Zope and a MySQL database. >> >> Using ZServer to parse a simple page with one "included" file = 18 hits per >> second(hps). >> Using PHP3 and Apache to parse a like page with the same "inlcuded" file = >> 16 hps >> >> Using ZServer w/ a Z SQL method to display a table (select * from ) = 3 hps > >:( > >> Using PHP3 and Apache to display the same table = 13 hps. >> >> Looking at the MySQL logs, they both keep a persistent connection. > >Only one? I'd expect Zope to create multiple connections if it was under load. > >> Why is >> it so much slower with Zope?They are delivering the exact same content with >> each request. The parsers are doing the same job at the surface, although I >> don't have a full grasp of what goes on beneith... >> As a parser, they are similar in speed, but with the database connection, >> ZServer falters. >> >> I tried starting ZServer with "-t 1" as I read in a previous post, but the >> result was similar. >> >> Testing done using Pounder II. > >How many rows are in the table? What DTML did you use to display the >results? I notice that the mySQL extension module used in ZMySQLDA >doesn't release the Python global interpreter lock, which could >negatively impact performance. > >Jim This is the DTML that I used:  <h2></h2> <p> This is the  Document. <br> <HR>  <HR> <table>  <tr>  <td></td>  </tr>  </table> <hr> </p>  The table has 65 rows, and is quite narrow (8 fields, no large text fields). I am using Zope-2.0.0a3, MySQL 3.21.33c and the latest python MySQL module. erik myllymaki erikm(a)islandnet.com

1 0

RE: [Zope] Problems with Zope 2.0.0a4
by Michel Pelletier 19 Jul '99

19 Jul '99

> -----Original Message----- > From: Alexander Graefe [mailto:wa0191@stud.uni-wuppertal.de] > Sent: Monday, July 19, 1999 1:22 PM > To: zope(a)zope.org > Subject: Re: [Zope] Problems with Zope 2.0.0a4 > > > On Sun, Jul 18, 1999 at 03:40:59PM -0400, michel(a)digicool.com wrote: > > > This kinda looks like an Apache error, are you sure it's a > Zope error? > > Is there a traceback if you run Zope with the Z_DEBUG_MODE env > > variable set? > > > > Are you using ZServer (z2.py)? > > I wasn't using ZServer, but I am now, much less hassle than trying to > coax Apache to play nice. :) > > And somehow I have the feeling that ZServer is a lot faster than > Apache + pcgi. > This is because Zope can run in multi-threaded mode with ZServer. ZServer *also* supports PCGI in multi-threaded mode, if you use the old way without ZServer, however, Zope will single thread. This was probably what you were doing. -Michel > Bye, > LeX > > -- > Today's excuse: > global warming > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Newbie looking for tutorial
by Ryan Grace 19 Jul '99

19 Jul '99

Hi All. Well, I've downloaded and installed Zope on my Linux box, but I can't find much in the way of examples to follow to learn how to use it. Does anyone know of a good (or otherwise) beginning Zope tutorial? Thanks in advance. Ryan grace(a)humboldt.edu

1 0

Re: [Zope] Problems with Zope 2.0.0a4
by michel＠digicool.com 19 Jul '99

19 Jul '99

Alexander Graefe <wa0191(a)stud.uni-wuppertal.de> writes: > Hi there. > > Since I read that Zope2 is the way of the future, I decided to try it > out. I was pretty amazed by Zope1, so I thought it could only get > better... > Well, now if I try to delete something from the Zope-Root, I get > > Method Not Allowed > > The requested method POST is not allowed for the URL /Zope. > This kinda looks like an Apache error, are you sure it's a Zope error? Is there a traceback if you run Zope with the Z_DEBUG_MODE env variable set? Are you using ZServer (z2.py)? -Michel

2 1

Re: [Zope] ODBC DA for unix coming?
by Roman Milner 19 Jul '99

19 Jul '99

>>>>> "CP" == Christopher Petrilli <petrilli(a)digicool.com> writes: CP> Well, in many ways the SOLID DA is ODBC :-) The problem is CP> more that we don't have any ODBC drivers on UNIX to try and CP> test things with, it should be a trivial effort otherwise. CP> I know there have been some efforts at a free ODBC CP> implementation, but I've not seen any give fruit. Well, I know that mxODBC (http://starship.python.net/crew/lemburg/mxODBC.html) is a python DB API 2.0 interface that works on top of the free IODBC (http://www.iodbc.org) I don't really know what I'm talking about - but it would be really nice to have an ODBC interface. The Cold Fusion guys at work seem to be able to get Cold Fusion to work with any DB ("OH, we'll just use the ODBC driver.") Some day, I hope to sell them Zope. ^Roman

1 0

ODBC DA for unix coming?
by Roman Milner 19 Jul '99

19 Jul '99

I was just wondering if there are plans for DC to release an ODBC DA for unix? Thanks, ^Roman

1 0

RE: [Zope] DTML methods title
by Brian Lloyd 19 Jul '99

19 Jul '99

> How can I set a title to a DTML method ? It always gets > the title from > the calling object, which is normal, but there are some > things (such as > Catalog search results) which have to be done as methods and > getting the > folder title isn't a very nice thing. > > -Petru In a DTML Method, you can use  to get the title of the DTML Method itself. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0