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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-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

Browse pgsql-announce by date

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

Browse pgsql-interfaces by date

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