Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto:

> In its most basic form a great tool would just start as a pl/pgsql
> or pl/perl function that could be used to call a table and have it
> output a batch of records to an editable html form or a colored pdf
> for nice reports. There would need to be some kind of interface for
> Apaché of course.
I guess the XML functions of 8.3 + an XSL stylesheet should do the
job... my 2 cents,
e.

I'll take a look at them. Anyone have a recommendation for a CGI
interface? I've thought about it enough to want to try it. I don't
really know how APEX / HTML DB work so I'm open to suggestions. I can
either put the controller in a perl module and send intelligent
requests for formatted pages to postgres or I could attempt to put a
controller into pl/pgsql.

It is amazing to me that a similar project doesn't already exist. I am
still looking though. I think many people have written functions that
output tables into formatted html, Excel and pdf formats.

Regards,

Justin Tocci
www.unirev.com
7813 Harwood Road
North Richland Hills, TX 76180
cell 817-988-7758
land 817-503-9545


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--- justin tocci <justin@tocci.org> wrote:

> interface? I've thought about it enough to want to try it. I don't
> really know how APEX / HTML DB work so I'm open to suggestions. I
> can
> either put the controller in a perl module and send intelligent
> requests for formatted pages to postgres or I could attempt to put
> a
> controller into pl/pgsql.
>

Just an FYI - ApEx is 100% PL/SQL and completely stored in the
database. All code and metadata. It's table driven and users can
create their own screens and reports. It's actually gotten pretty
advanced and it's very robust. Oracle runs what it calls the "Oracle
PL/SQL Gateway" to allow access. That's Apache in the db.

You can read about the architecture here:
http://download-uk.oracle.com/docs/c.../intro_app.htm

No middle tier required, no CGI.

LewisC



Lewis R Cunningham

An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/

LewisC's Random Thoughts
http://lewiscsrandomthoughts.blogspot.com/

Postgres Forums
http://postgres.enterprisedb.com/forum.do



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/