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@math.eiu.edu
|_____).|_| .|_|.\__|..|______|../_/...\_\ web site: math.eiu.edu/seb