Database Front end suggestion

Bill Campbell linux-sxs
Tue Nov 9 01:02:36 PST 2004


On Mon, Nov 08, 2004, Shawn Tayler wrote:
>Hi Guys,
>
>I have a problem.  I am not at all familiar with perl or PHP or Pythoin, my
>last coding bit was some very simple awk and sed scripts and the QuickBasic
>coding about 20 years ago.  I need to shuffle a large about of data into
>and through a database.  I have both postgresql and mysql operational on a
>box with 300G of LVD SCSI HD space, 1G RAM and, a P4 2.8Ghz chip.  
>
>What I really need is a newbie friendly frontend that will allow me to
>build tables and run queries and impoirt and export data and results.
>
>I spent a couple hours just trying to build a table in mysql today,
>apparently the syntax in the book is wrong and I'm spinning my wheels.  
>
>Would you fine gents know of something?  Linux and Open Source would be
>great but I can shell out some sheckles  if needed.

There are a couple of general purpose php based utilities for working with
postgresql and mysql, phpMyAdmin and phpPgAdmin.  OpenOffice.org interfaces
nicely using jdbc or odbc connections to either of these databases (jdbc is
probably a better choice as OpenOffice.org has strong java roots).  Zope
and Plone have excellent tools for working with back end databases.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

The difference between science and the fuzzy subjects is that science
requires reasoning while those other subjects merely require scholarship.
                -- Robert Heinlein


More information about the Linux-users mailing list