pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Web server PostgreSQL interfaces
4+ messages / 4 participants
[nested] [flat]

* Web server PostgreSQL interfaces
@ 1999-08-25 10:59 Nicolas Huillard <nhuillard@ghs.fr>
  1999-08-25 11:37 ` Re: [INTERFACES] Web server PostgreSQL interfaces Dirk Lutzebaeck <lutzeb@aeccom.com>
  1999-08-25 20:23 ` Re: Web server PostgreSQL interfaces Hannu Krosing <hannu@trust.ee>
  0 siblings, 2 replies; 4+ messages in thread

From: Nicolas Huillard @ 1999-08-25 10:59 UTC (permalink / raw)
  To: 'Hannu Krosing' <hannu@trust.ee>; 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>

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

************





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [INTERFACES] Web server PostgreSQL interfaces
  1999-08-25 10:59 Web server PostgreSQL interfaces Nicolas Huillard <nhuillard@ghs.fr>
@ 1999-08-25 11:37 ` Dirk Lutzebaeck <lutzeb@aeccom.com>
  1999-08-25 15:29   ` Re: [INTERFACES] Web server PostgreSQL interfaces Lamar Owen <lamar.owen@wgcr.org>
  1 sibling, 1 reply; 4+ messages in thread

From: Dirk Lutzebaeck @ 1999-08-25 11:37 UTC (permalink / raw)
  To: Nicolas Huillard <nhuillard@ghs.fr>; +Cc: 'Hannu Krosing' <hannu@trust.ee>; 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>


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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [INTERFACES] Web server PostgreSQL interfaces
  1999-08-25 10:59 Web server PostgreSQL interfaces Nicolas Huillard <nhuillard@ghs.fr>
  1999-08-25 11:37 ` Re: [INTERFACES] Web server PostgreSQL interfaces Dirk Lutzebaeck <lutzeb@aeccom.com>
@ 1999-08-25 15:29   ` Lamar Owen <lamar.owen@wgcr.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Lamar Owen @ 1999-08-25 15:29 UTC (permalink / raw)
  To: Dirk Lutzebaeck <lutzeb@aeccom.com>; +Cc: Nicolas Huillard <nhuillard@ghs.fr>; 'Hannu Krosing' <hannu@trust.ee>; 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Web server PostgreSQL interfaces
  1999-08-25 10:59 Web server PostgreSQL interfaces Nicolas Huillard <nhuillard@ghs.fr>
@ 1999-08-25 20:23 ` Hannu Krosing <hannu@trust.ee>
  1 sibling, 0 replies; 4+ messages in thread

From: Hannu Krosing @ 1999-08-25 20:23 UTC (permalink / raw)
  To: Nicolas Huillard <nhuillard@ghs.fr>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-08-25 20:23 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-25 10:59 Web server PostgreSQL interfaces Nicolas Huillard <nhuillard@ghs.fr>
1999-08-25 11:37 ` Dirk Lutzebaeck <lutzeb@aeccom.com>
1999-08-25 15:29   ` Lamar Owen <lamar.owen@wgcr.org>
1999-08-25 20:23 ` Hannu Krosing <hannu@trust.ee>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox