Skip site navigation (1) Skip section navigation (2)

NEW WEB INTERFACE for PostgreSQL

From: seb(at)Panther4095(dot)eiu(dot)edu
To: pgsql-admin(at)postgresql(dot)org, pgsql-announce(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: NEW WEB INTERFACE for PostgreSQL
Date: 1999-07-08 18:39:49
Message-ID: Pine.LNX.4.04.9907081420570.18250-100000@Panther4095.eiu.edu (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-interfaces
Hi all,

sorry if get this mail 2 or 3 times!

I am working on a CGI (perl) to access ANY postgres DB 
from the web: "PGase"

Here are the main features:

_ Login page to enter the CGI (default guest OK!).

_ Select/Insert/Update/Delete with just the mouse. 
    (foreign keys are links to primary key table!)

_ Import/Export data from/to flat .txt files 
   => works perfect with Access or whatever!

_ UPLOAD SQL scripts from IMPORT to create database structure
   directly from the CGI, or put data back from a pg_dump.

_ Administration also through a CREATE (SQL commands) page.

_ little HELP... :)

_ build queries dynamically (point & click: basic but OK 
   even when referential integrity between 2 tables).

_ run perfect with LYNX!!!

_ record queries => SAVEAS  ...  access from QUERY

_ Pie CHARTs on a selected field in a table.


Still to do:

_ FIND functions to get any records having "$string" 
   in one of its fields...  or between dates...

_ IP control access from the CGI.

_ few bugs to correct

_ move to mod_perl

_ lots of other ideas, like BLOBS, personalized forms...

Do you like the CGI?
What would you change?
What would you like to see?
Feel free to give me any advices!
'Say that's for the PostgreSQL community!  ;)

Thanks for your help,
Have fun,
                                Sebastien.

Oups, maybe you need this:
http://panther4095.eiu.edu/PGase

The code:
http://math.eiu.edu/seb/cgi-bin/pg
                                                
._...... _...._...._...._...._..._ ......_
|.|.....(_)..|.\..|.|..|.|..|.|..\.\..././ Sebastien Flacher
|.|.....|.|..|..\.|.|..|.|..|.|...\.\././
|.|.....|.|..|...\|.|..|.|..|.|..../._.\   phone: 217.345.8874
|.|___..|.|..|.|\...|..|.|__|.|..././.\.\  email: seb(at)math(dot)eiu(dot)edu
|_____).|_| .|_|.\__|..|______|../_/...\_\ web site: math.eiu.edu/seb


pgsql-announce by date

Next:From: Bruce MomjianDate: 1999-07-17 17:06:15
Subject: PostgreSQL status report
Previous:From: Bruce MomjianDate: 1999-07-02 21:01:51
Subject: subscribe

pgsql-interfaces by date

Next:From: George YoungDate: 1999-07-08 19:55:59
Subject: transactions in libpq++ require new connection?
Previous:From: C.J. PenaDate: 1999-07-08 15:38:24
Subject: No suitable driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group