On Mar 6, 2005, at 2:07 AM, David wrote:
> So, it all boils down to this - can a serious database be run from psql
> or is it better to use something else? I believe I could write an app
> in "C" without much trouble, using my current program for a pattern for
> the user interfacing, and I'm even thinking about trying my hand
> at perl or python, but it would be nice to do it all from psql if
> possible.
If all you need is light reporting, browsing, and editing take a look
at phpPgAdmin (http://phppgadmin.sourceforge.net/). It is a nice web
based administration interface. If you want to extend it, all of the
source (PHP) is there.
If you want to do everything in psql, you might also want to take a
look at pgEdit (http://pgedit.com/). It provides front end for psql,
including a menu of recently executed files and management of your
connection information.
For reports I want to see on a regular basis, I have found it very
convenient to have a process that runs psql and emails the output to
me.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL