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

Web browser will be the most popular GUI front-end in the future. A major portion of code should be written in Web server scripting (and compiling) language PHP+Zend compiler, HTML, DHTML and with little bit of JavaScript and Java-Applets on web-client side. It is recommended that you migrate all of your "legacy" Windows 95/NT applications to PHP + HTML + DHTML and 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 -

• 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. PHP Web server scripting, HTML, DHTML with Javascrpt client scripting and Java-Applets.
2. Perl scripting language using Perl-Qt or Perl-Tk Perl Database Interface
3. 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.
4. Java but its programs run very slow and has license fees. C++ is 20 times faster than Java!!

There are other tools available - PostgreSQL has Tcl/Tk interface library in the distribution called 'pgTcl'. There is a 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.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