12. GUI FrontEnd Tool for PostgreSQL (Graphical User Interface)

Web browser will be the most popular GUI front-end in the future. It is recommended that you migrate all of your "legacy" Windows 95/NT applications to Web-based application.

You should use Web-Application Servers like Enhydra (Java based) or Zope (Python based) or OpenACS .

Best web-scripting (and compiling) language is PHP+Zend compiler PHP is extremely powerful as it combines the power of Perl, Java, C++, Javascript into one single language and it runs on all OSes - unixes and Windows NT/95.

The best tools in the order of preference are -

• Enhydra at Enhydra plus Borland Java JBuilder for Linux http://www.inprise.com
• Zope at Zope
• OpenACS at OpenACS
• PHP script and Zend compiler at PHP+Zend compiler
• X-Designer supports C++, Java and MFC http://www.ist.co.uk/xd
• Qt for Windows95 and Unix at http://www.troll.no and ftp://ftp.troll.no
• Code Crusader is on linux cdrom, freeware based on MetroWorks Code Warrior http://www.kaze.stetson.edu/cdevel/code_crusader/about.html
• Code Warrior from MetroWorks http://www.metrowerks.com
• GNU Prof C++ IDE from (Redhat) Cygnus http://www.cygnus.com
• Borland C++ Builder for Linux http://www.inprise.com
• Borland Java JBuilder for Linux http://www.inprise.com

Language choices in the order of preference are -

1. Java but its programs run very slow and has license fees. C++ is 5 times faster than Java!!
2. Python (Powerful object oriented scripting language).
3. PHP Web server scripting, HTML, DHTML with Javascrpt client scripting and Java-Applets.
4. Perl scripting language using Perl-Qt or Perl-Tk Perl Database Interface
5. Omnipresent and Omnipotent language C++ (GNU g++):
   • Fast CGI(written in GNU C++) with Javascript/Java-Applets as Web-GUI-frontend.
   • GNU C++ and QtEZ or QT
   • GNU C++ with Lesstiff or Motif.

There are other tools available - PostgreSQL has Tcl/Tk interface library in the distribution called 'pgTcl'. There is an IDE (integrated development environment) for Tcl/Tk called SpecTcl.

• Lesstiff Motif tool ftp://ftp.redhat.com/pub/contrib/i386/lesstiff*.rpm
• Vibe Java/C++ is at http://www.LinuxMall.com/products/00487.html
• JccWarrior ftp://ftp.redhat.com/pub/contrib/i386/jcc*.rpm
• Tcl/Tk http://www.scriptics.com
• Object oriented extension of Tcl called INCR at http://www.tcltk.com
• Visual TCL site http://www.neuron.com
• Visual TCL Redhat rpm at ftp://ftp.redhat.com/pub/contrib/i386/visualtcl*.rpm
• http://sunscript.sun.com/
• http://sunscript.sun.com/TclTkCore/
• ftp://ftp.sunlabs.com/pub/tcl/tcl8.0a2.tar.Z
• Java FreeBuilder ftp://ftp.redhat.com/pub/contrib/i386/free*.rpm
• SpecTCL ftp://ftp.redhat.com/pub/contrib/i386/spec*.rpm
• Java RAD Tool for PostgreSQL Kanchenjunga http://www.man.ac.uk/~whaley/kj/kanch.html
• Applixware Tool http://www.redhat.com
• XWPE X Windows Programming Environment http://www.identicalsoftware.com/xwpe/ or at http://www.rpi.edu/~payned/xwpe/ ftp://ftp.redhat.com/pub/contrib/i386/xwpe*.rpm
• XWB X Windows Work Bench ftp://ftp.redhat.com/pub/contrib/i386/xwb*.rpm
• NEdit ftp://ftp.redhat.com/pub/contrib/i386/nedit*.rpm