[Tfug] PostgreSQL GUI front end/report generator/etc.

[Bexley Hall]

Hi,

I'm implementing an RDB on PostgreSQL (think: free, open)
and looking for ideas on how I can present a more user
friendly interface to the DBMS.

I expect the primary interface to be via a "workstation"...
either locally or remote.  And, I can't count on it being
"Windows" based.

I.e., first idea was to use MSAccess with an ODBC driver
as middleware.  But, not sure how well supported that is
on non-PC platforms (Mac's?).  And, everything with "MS" in
it means "do it over again in a couple of years".

Not an option.  If clients want to "upgrade" their workstations,
fine -- but the application isn't getting rewritten.  Ever!

This suggest a web based interface (and pick some persistent
core of web technologies to ensure the interface remains
viable even as we migrate to HTML1000 and umpteen other
browser variants!).

Any experience on this front?  Any *robust* toolchains to
rely upon?  Note most of the business logic will be hard-coded
in the DBMS.  So, the GUI really *is* just a pretty front end
and "report generator".

Thx,
--don