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 PHP and with little bit of JavaScript on web-client side. It is recommended that you migrate your legacy Windows 95/NT applications to PHP/Zend.

The best tools are

• PHP and Zend (script and compiler) PHP
• 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 with Javascrpt client scripting.
2. Perl scripting language using Perl-Qt or Perl-Tk Perl Database Interface
3. Omnipresent and Omnipotent language C++:
   • CGI(written in C++) with Javascript as Web-GUI-frontend.
   • C++ and QtEZ or QT
   • C++ with Lesstiff or Motif.
4. Java but its programs run very slow.

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
• FreeBuilder ftp://ftp.redhat.com/pub/contrib/i386/free*.rpm
• SpecTCL ftp://ftp.redhat.com/pub/contrib/i386/spec*.rpm
• Kanchenjunga Java RAD Tool for PostgreSQL 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