Thread: Front End Tools

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    56
    Rep Power
    4

    Front End Tools


    Hello,

    I'm wondering if anyone knows if there's an existing front-end PHP or similar style tool that allows non-technical users to be able to submit data into my PostgreSQL database? I know PHP is fairly simple to learn and something can be coded in a day but I've never done this and wouldn't know where to even begin or what's possible.

    The database in question has a table I created called 'software' and the database is configued as below:
    Code:
    CREATE TABLE software
    (
    software_id SERIAL PRIMARY KEY,
    software_vendor VARCHAR(100) NOT NULL,
    software_product VARCHAR(100) NOT NULL,
    software_count INT,
    software_warranty DATE NOT NULL,
    software_license VARCHAR(50) UNIQUE NOT NULL,
    software_owner VARCHAR(100) NOT NULL
    );
    So from the above we've got a generic / basic table showing details for all software. I just am looking for help with finding a front-end tool to allow users to submit the data via a form or browser. Anyone have any info?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,262
    Rep Power
    4279
    the key word being "non-technical"

    i've heard of http://www.vfront.org/

    there's also a list of tools here -- http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo