Thread: Web server PostgreSQL interfaces
Was : [INTERFACES] Trying to find a PostgreSQL interface About Zope, that I didn't know about before today, has anyone usage information/examples, or experience he/she can talk about. I think that it includes the parts I was wondering for : resusable SQL queries repository, and transaction/session management. Has anyone used this product or compared it with others, and even have pointers to other free products like this one ? Thanks for any information, Nicolas Huillard G.H.S Directeur Technique Tél : +33 1 43 21 16 66 Fax : +33 1 56 54 02 18 mailto:nhuillard@ghs.fr http://www.ghs.fr -----Message d'origine----- De: Hannu Krosing [SMTP:hannu@trust.ee] Date: mercredi 25 août 1999 09:18 À: mlinvill@winstar.com Cc: Daniel Stolk; pgsql-interfaces@hub.org Objet: Re: [INTERFACES] Trying to find a PostgreSQL interface Mark Linvill wrote: > > On Tue, 24 Aug 1999, Daniel Stolk wrote: > > >Hi, > > > >I'm needing to access my PostgreSQL database from the web, or actually > >the customers need to. I was originally using C with the libpq library, > >but I was wondering if there are some programs out there that would make > >it easier and faster for me to set things up? If there aren't, what > >kind of interface would be best to use? I was looking at PHP, but I'm > >not sure it will be as powerful as C, but maybe it is powerful enough. You may also try Zope (http://www.zope.org) > IMHO, PHP is plenty powerful enough. Development time is > fabulously quick. The only possible issue might be execution speed. > Not that PHP is slow, but it can't beat a C CGI. AFAIK you can save the CGI startup costs as PHP is loaded as a module in Apache. If it has persistent database connections (like Zope) then you also save the DB connection setup and so it can easyly beat C CGI on anything but most compute-intensive tasks. ----- Hannu ************
If you are into Perl you might try mod_perl/Apache. There are Perl/HTML integrator tools like Embperl or Mason. Perl is way more flexible than C and a lot more expressive than PHP. It's also quite fast. With mod_perl you don't spawn an extra Perl process for every apache request because the perl interpreter is loaded into apache (likewise mod_php/Apache). I would say mod_perl/Apache is the swiss army knife of application servers. You find more at http://perl.apache.org Dirk
Dirk Lutzebaeck wrote: > > If you are into Perl you might try mod_perl/Apache. There are [snip] > (likewise mod_php/Apache). I would say mod_perl/Apache is the swiss > army knife of application servers. I love choices! If you're into Tcl, try AOLserver. It is a fully integrated web development environment, with a kicking multithreaded server, tcl 8.2 (in 3.0b3), tightly integrated database connectivity, dynamic content (embedded Tcl in HTML -- AOLserver Dynamic Pages (ADP)), and, best of all, a great postgresql driver. Tcl, IMHO, is one of the best languages for web scripting -- perl is a good glue language, but, for some things, the AOLserver dialect of Tcl is far more useful. Plus, there is a prefab community system available for AOLserver from ArsDigita, called the ArsDigita Community System -- while written for Oracle *i, a porting effort is underway to get it up on Postgresql. www.aolserver.com. Lamar Owen WGCR Internet Radio
Nicolas Huillard wrote: > > Was : [INTERFACES] Trying to find a PostgreSQL interface > > About Zope, that I didn't know about before today, has anyone usage >information/examples, or experience he/she can talk about. My experience is that easy things are easy and difficult things are doable without much effort once you know your way. The learning curve may be a little steep at some places, but the zope.org site helps nicely by having DTML-source links at the bottom of pages > I think that it includes the parts I was wondering for : resusable SQL > queries repository, and transaction/session management. > Has anyone used this product or compared it with others, and even > have pointers to other free products like this one ? This question should be asked at zope list zope@zope.org, there probably is even a faq somewhere Hannu