Re: Getting started - Interfacing questions

On Mar 7, 2005, at 4:57 PM, David wrote:

> For example, the php-based front-ends require apache. It
> just seems that in my case, at least, it's asking a lot to install
> apache on a machine that will never do any web-serving elsewhere in
> order to access a local database -- but -- perhaps the same could be
> said for using postgresql on a database that might see 300 entries at
> most, but I "wanna do it" :)
>

It is definitely true that the web-based front ends need apache or some
other web server, but I want to point out that you don't need a web
server to make use of php. You can create and run php scripts just like
any other shell script. Using the \! command, you could have psql call
your script and I'm sure there is a way to run psql from php. Here is a
reference if you are interested:

http://us3.php.net/features.commandline

This is related to one of the features I'm working for pgEdit -- to use
php as preprocessor for the sql file before passing the output to psql.
This creates some interesting opportunities to parameterize sql scripts
and add a lot data I/O facilities.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL