Thread: [INTERFACES] webserver interface

[INTERFACES] webserver interface

From
"Craig Potter"
Date:
I am sure that this question has been asked many times, but I am new to this
list and am searching for answers....

How to I get Postgres on RH linux 6.2, Apache, talking to web page forms.  I
am sure there is software for this.  Can anyone recommend anything & give
tips on their method of doing this.

Maybe there is a list FAQ where this is answered.

Thanks.
---------------------------------------------------------
Craig Potter

WhatWhatWhatWhatWhatWhatWhat
- Neddie Seagoon
--------------------------------------------------------





Re: [INTERFACES] webserver interface

From
"Brett W. McCoy"
Date:
On Mon, 27 Sep 1999, Craig Potter wrote:

> I am sure that this question has been asked many times, but I am new to this
> list and am searching for answers....
> 
> How to I get Postgres on RH linux 6.2, Apache, talking to web page forms.  I
> am sure there is software for this.  Can anyone recommend anything & give
> tips on their method of doing this.

I use perl, along with the CGI and Pg modules (actually, mod_perl works
even better -- much faster!).;  Alternatively, you can use PHP3
(www.php3.org), an embedded HTML scripting language along the lines of
ASP.  It has a lot of really neat things like database connectivity
(including Postgres), graphics manipulation, regular expressions, and so
on.  It runs as an Apache module (you can run it as a CGI mdoule, but it's
sooo slow) and has a syntax based on Perl and C. 


Brett W. McCoy                                                   http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
To iterate is human, to recurse, divine.



Re: [INTERFACES] webserver interface

From
Lamar Owen
Date:
Craig Potter wrote:
> 
> I am sure that this question has been asked many times, but I am new to this
> list and am searching for answers....
> 
> How to I get Postgres on RH linux 6.2, Apache, talking to web page forms.  I
> am sure there is software for this.  Can anyone recommend anything & give
> tips on their method of doing this.

You certainly CAN use mod_php with apache (mod-php with the pgsql module
comes with RedHat 6.0).

If you don't have a religious attachment to apache, you can use
AOLserver, which has a killer tcl API, and directly supports
PostgreSQL.  I am a little biased towards it, because that is what I
have used for over two years -- it is quick and relatively painless to
learn the AOLserver-enhanced tcl.  Version 3.0b3 is available now in
both source and binary form -- check www.aolserver.com for details. 
AOLserver is one of the most scalable webservers on the planet -- it is
right now fielding over 28,000 hits per _second_ at AOL's server farm
(more than one server, of course....). AOLserver is multithreaded, and
fast.  And don't let the initials AOL make you retch -- AOL just bought
the company, Navisoft, that built the server originally -- it is not
AOL's creation.  The original Navisoft people are still there at the
helm of this server.

If you prefer to stay with Apache, mod_php is , AFAIK, one of the best
ways of going about it -- it is very similar to how AOLserver does it.


Re: [INTERFACES] webserver interface

From
"Tim Joyce"
Date:
We use www.webmacro.org
this is java servlet based and open source.  fine technology.

timj

> > I am sure that this question has been asked many times, but I am new to
this
> > list and am searching for answers....
> >
> > How to I get Postgres on RH linux 6.2, Apache, talking to web page
forms.  I
> > am sure there is software for this.  Can anyone recommend anything &
give
> > tips on their method of doing this.
>
> I use perl, along with the CGI and Pg modules (actually, mod_perl works
> even better -- much faster!).;  Alternatively, you can use PHP3
> (www.php3.org), an embedded HTML scripting language along the lines of
> ASP.  It has a lot of really neat things like database connectivity
> (including Postgres), graphics manipulation, regular expressions, and so
> on.  It runs as an Apache module (you can run it as a CGI mdoule, but it's
> sooo slow) and has a syntax based on Perl and C.
>
>
> Brett W. McCoy
>                                          http://www.lan2wan.com/~bmccoy
> -----------------------------------------------------------------------
> To iterate is human, to recurse, divine.
>
>
> ************



Re: [INTERFACES] webserver interface

From
Hannu Krosing
Date:
Craig Potter wrote:
> 
> I am sure that this question has been asked many times, but I am new to this
> list and am searching for answers....
> 
> How to I get Postgres on RH linux 6.2, Apache, talking to web page forms.  I
> am sure there is software for this.  Can anyone recommend anything & give
> tips on their method of doing this.

If it's just a few forms then use cgi-s (either C, python or perl).

If it is something more complex use Zope (http://www.zope.org/).

------
Hannu


Re: [INTERFACES] webserver interface

From
"Craig Potter"
Date:
Thanks for all the tips, I will attempt to try it out shortly....you mention
cgi-s - what is this, I know cgi  - how is cgi-s different?
Craig.
----- Original Message -----
From: Hannu Krosing <hannu@tm.ee>
To: Craig Potter <mikado@omni.com.au>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, September 28, 1999 2:52 AM
Subject: Re: [INTERFACES] webserver interface


> Craig Potter wrote:
> >
> > I am sure that this question has been asked many times, but I am new to
this
> > list and am searching for answers....
> >
> > How to I get Postgres on RH linux 6.2, Apache, talking to web page
forms.  I
> > am sure there is software for this.  Can anyone recommend anything &
give
> > tips on their method of doing this.
>
> If it's just a few forms then use cgi-s (either C, python or perl).
>
> If it is something more complex use Zope (http://www.zope.org/).
>
> ------
> Hannu
>
>