Thread: [INTERFACES] webserver interface
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 --------------------------------------------------------
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.
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.
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. > > > ************
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
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 > >