Re: [GENERAL] web programming
Zope. http://www.zope.org Been using PostgreSQL behind Zope for a couple of sites for over 8 months now and it has been a pleasure. Cheers, J At 9:15 PM -0400 9/25/2000, Michelle Murrain wrote: >Hi folks, > >I thought (now that I've solved my DBD::Pg problem) that I'd ask a >fairly generic opinion question. I've been working with postgres and >php now for about 4 years, quite heavily in the last year. I'm sold >on postgres, and will continue to use it unless I have compelling >reasons not to. But I'm debating about continuing development using >php. > >1) I'm getting better and better at perl - and it's a much more >mature language than php. > >2) I've been learning a bit about jsp and java servlets - and that's >intriguing me a lot. > >So what's your favorite web programming language to use with >postgres, and why? Are there speed/performance issues I should think >about? I'm also beginning to get into XML, so there is another set >of things to think about. > >Thanks! > >Michelle >--- >Michelle Murrain, Ph.D. >President, Norwottuck Technology Resources >[EMAIL PROTECTED] www.norwottuck.com
Re: [GENERAL] Count & Distinct
Yup.. I (original poster) am using 6.5.3 and should/would/will head to 7.0.2 (already on another site in production). Just waiting for the time/need. Thanks to everyone for their help. J > From: "Ryan Williams" <[EMAIL PROTECTED]> > Date: Thu, 24 Aug 2000 12:08:46 -0700 > To: <[EMAIL PROTECTED]> > Subject: Re: FW: [GENERAL] Count & Distinct > > I'm running 7.0.2 (or at least I believe so). Is there something that /I/ > may be doing wrong? > > - Original Message - > From: "Ross J. Reedstrom" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 24, 2000 8:44 AM > Subject: Re: FW: [GENERAL] Count & Distinct > > >> On Thu, Aug 24, 2000 at 10:35:49AM -0700, Ryan Williams wrote: >>> I find that if I create the table described in the email, in psql I > recieve >>> 'ERROR: Attribute 'row' not found'... >>> >>> But this isn't exactly 'ERROR: parser: parse error at or near >>> "distinct"'... >> >> Right, that's the error you get from doing this in 6.5.x. The original >> poster has already been advised to upgrade to 7.0.2. >> >> Ross >> >> -- >> Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]> >> NSBRI Research Scientist/Programmer >> Computer and Information Technology Institute >> Rice University, 6100 S. Main St., Houston, TX 77005 > >
[GENERAL] 7.0 RPM?
I have been looking around for the RPM for 7.0 anyone have a quick link? Thanks, J
Re: [Zope] [GENERAL] PyGres DB Connection in Zope drops when manyUsers are added (UserDB) (UserDB)
Have you tried running AB against some of the pages and watching the connections happen? Also, try playing around with the cache. I found that I could change the load times and db performance by playing with Zope db caching. I would also hate to mention it but 7 is still beta. Can you try it on 6.5.3 and see if it still happens? J At 1:19 AM -0500 4/25/2000, Stephan Richter wrote: >Hello everyone, > >This is a help message to every mailing list, I think this issue >could be related to. We are in production and 5000 flyers (45000 >follow) were sent out and the site keeps giving problems. > >I use: >Zope 2.1.4, PyGres 2.x, Apache, and PostGres 7.0RC1 > >The issue: >It seems like that whenever "many" (10, I know that is not much) >people sign up at the same time on our Web Site >(http://www.plandepot.com), we loose the DB connection. The >connection is simple restored, when disconnecting and the >reconnecting the database. >Unfortunately I was unable to reproduce the error outside of >business hours, so I had never the chance to inspect the issue in >detail. I personally do not think it is PostGreSQL or Zope, since I >would have read more about it. >I have to mention, that PyGres is not thread safe and by default >Zope uses more than one thread if required. So could that be the >issue? How do I setup Zope in a way, that it uses only one thread? >Also, I do not use any of the caching features in Zope SQL Methods >either.