August 1999 - Zope - Zope lists

Re: [Zope] Which database?
by Christopher Petrilli 31 Aug '99

31 Aug '99

> I'd like to use MySQL because of it's integration with Zope > and web in general... and then it's a nice product too. MySQL's biggest failing is it's total lack of transactions, which can be a serious issue if you have heavy use of your system for updating. It's really best used in a 99%+ read-only environment in my opinion. I guess I just don't trust non-transactional relational databases. > My collegeague is obsessed with security so he on the > PostgreSQL wagon. Main issue for him is transaction control. > I say: heavy hardware and light usage means no need for > transaction control in my world. PostgreSQL is slow, unfortunately, otherwise, it's a good product from what I've seen, and certainly is improving with time. > My boss says: go with Oracle or Informix. Our company > already has licenses for these products. > I think they are too heavy, too big and too closed. That's > bad. Honestly, I don't see "closed" as an issue here. Do you really expect to make changes to the database code? Even if Oracle released all the source code, I only think a small handful of people would ever understand the internals of a query path optimizer. The issue also might be that if you plan to integrate with multiple other systems in the future (which is always a good thing for keeping data rational) then certainly you could face integration problems with non-"standard" databases. It's your call, but I don't think that "open source" should be a judgement criteria of any weight on a database. It's opaque for a reason. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli(a)digicool.com http://www.digicool.com

1 0

Re: [Zope] Tiny Table
by Rik Hoekstra 31 Aug '99

31 Aug '99

> -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > wombat_harness(a)hotmail.com > Sent: Tuesday, August 31, 1999 3:23 PM > To: zope(a)zope.org > Subject: [Zope] Tiny Table > > > Hey everyone, > > not sure if i have posted this one before, but does anyone have any > idea how to dynamically change the contents of a tinytable from a DTML > document? I really need to be able to add data into the table without > adding it manually.. > > Any thoughts?? > Not about TinyTable, but you may obtain a similar effect using XML Document (see for example the Tree example which comes with the XML Document product). Rik Hoekstra > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: [Zope] Re:Re: [Zope] Which database?
by Anthony Baxter 31 Aug '99

31 Aug '99

>>> "Suder Steen SFS" wrote > If I can administer both DB's from within Zope, then I'll choose PGSQL becaus e you say they're equally easy to work with an PGSQL has transaction control. > Can I administer DB's from within Zope? > > PGSQL's advantage is transaction control and MySQL's would be tools and > userbase, right? Don't underestimate transactions - does the Zope Mysql interface do rollback if a page is partially rendered? Databases with transactions (particularly when they're supported by Zope :) make life _so_ much easier - you don't have to worry about what happens if one SQL Method fails, but there's been previous ones in the same DTML Method that might or might not have succeeded... Anthony

2 1

I'm sorry...
by Steen Suder 31 Aug '99

31 Aug '99

Hi, A mailinglist member put to my attention that my mail demanded "Read Receipts" on read. This is, off course, a very impolite behaviour from my side. I apologize! Due to the mailserver software my employer uses, it is enabled per default and I can't disable it. Now I found an open SMTP relay internally on our network so now the trouble should have been settled. -- Best regards / Mvh., Steen Suder Linux Systems Administrator Use "sfs @T sciatl DOD dk" for email or remove TOC from email address

1 0

Performance of webserver?
by Suder Steen SFS 31 Aug '99

31 Aug '99

Hi, One of the last questions for now, I'd like to know the answer for is: What is the performance of the webserver in Zope 2? I'd like to compare to Apache on Linux (our Zope will be running on one of these). HW is PII400 and 256MB RAM. Can the webserver be used in productionenvironment? How much load can it take compared to Apache before I need to upgrade hw? The same? Half? Double? I ask because if an upgrade will be impending due to the performance of Zope's webserver, then I might as well go the Apache way now. I'd like to spare that effort, though. Best regards, Steen Suder DK

1 0

Which database?
by Suder Steen SFS 31 Aug '99

31 Aug '99

Hi, I'm implementing a little Zope 2 solution here in my IT dept. and we're having discussions on which database to use. Scenario: 4-5 adms/real users, upto 250 client users. Adms will enter PC regs., user regs and so on. Clients will enter suppport issues, follow their issue's progress and browse diff. IT support info. So it's no big thing at all. We plan to run the thing on RedHat Linux 6.0. Hardware is a PII 400, 256MB RAM, RAID5 for data etc. I'd like to use MySQL because of it's integration with Zope and web in general... and then it's a nice product too. My collegeague is obsessed with security so he on the PostgreSQL wagon. Main issue for him is transaction control. I say: heavy hardware and light usage means no need for transaction control in my world. My boss says: go with Oracle or Informix. Our company already has licenses for these products. I think they are too heavy, too big and too closed. That's bad. I'd like some thoughts on this issue. Best regards, Steen Suder IT tech. apprentice

2 2

SQL INPUT Wizard Error
by Kent Sin 31 Aug '99

31 Aug '99

Dear, I got the error Error Type: AttributeError Error Value: manage_addZSQLMethod I am running Zope 2 b6 on win98. The database in use is MySQL. Does anyone known what is happening? Rgs, Kent Sin ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

PNG image import incorrect
by Li Dongfeng 31 Aug '99

31 Aug '99

I'm using ZOPE 2.0.0b5, and tried to upload a PNG image to a ZOPE folder. When I tried to view it, the image cannot show properly. A check of its property page in ZOPE discovered that ZOPE erroneously calculatedd the width and height of the image(with height of 1229472850). The image was converted from a PostScript file with ghostscript, and it displays properly in other applications(eg. netscape). If I manually modify its width and height in ZOPE's property page, the image shows properly. Anyone know what's the problem? Li

3 3

ANNOUNCE: beehive releases mkproduct
by Mark Pratt 31 Aug '99

31 Aug '99

hello all, we have decided to open source mkproduct which together with skeletons can seriously reduce your time spent building zope products. mkproduct is used extensively at beehive to rapidly build prototypes. do check out our documentation availible in both german and english. get mkproduct at www.zope.de/software/mkproduct this is beehive's way of saying thanks to all the nice people in the zope community! regards, mark, basti, katrin, alex -------------------------------------------------------------- mark pratt (managing director) mark(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

1 0

Squish dot
by Grant Street 31 Aug '99

31 Aug '99

Hello does squish dot work on 1.10? I looked in the release notes but could not find any thing. I've installed Squish dot on 1.10 and it works fine if you're connected as manager but any other user is met with with the following web page. I have installed squish dot 1.1.4 and 1.1.5, reinstalled and changed directories the squish site is in. Any Clues? Grant -------------------------------------------------- <HTML><HEAD><TITLE>Fabba's Web Site</TITLE> <base href="http://localhost:9673/fab/"> </HEAD><BODY BGCOLOR="#FFFFFF"> You are not authorized to access <em>leftbox_items</em>. <p><a href="http://www.zope.org/Credits"><img src="http://localhost:9673/p_/ZopeButton" width="60" height="82" border="0" alt="Powered by Zope"></a></p> </BODY></HTML>

2 1