Re: xml middleware - Mailing list pgsql-general

From Adam Lang
Subject Re: xml middleware
Date
Msg-id 004501c07b1b$b9b2a540$330a0a0a@6014cwpza006
Whole thread Raw
In response to xml middleware  ("Peter Cheng"<oolumi1@kimo.com.tw>)
List pgsql-general
I was even thinking more along the lines of a java program that acts as an
interface where it receives a query from the user, sends it to postgreql via
jdbc, receives the result set, translates it into XML and returns it to the
user.

Performance would be the isue, but something like that would be best suited
for internet applications and the performance is not as big of an issue.
Plus, if you plan on using XML, you are expecting to take performance hits
anyway.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Joseph Shraibman" <jks@selectacast.net>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, January 09, 2001 8:55 PM
Subject: Re: [GENERAL] xml middleware


> According to the the tuning document released by GreatBridge, postgres
> is relational as well as object oriented.  Since it is object-oriented
> methinks it shouldn't be a problem to translate a DTD to a database def,
> but trying to figure out the postgres backed code gives me a headache.
>
> Basically what is needed:
>
> 1) A parser to create a database schema from an XML DTD.
> 2) A parser to translate SELECT /root/element1 FROM table WHERE
> /root/element1@param1 = "foo"; into a database query.  Could be tricky
> because (I think) element1 has to be stored in an array field because
> there might be more than one of them, and I'm not sure how to do a
> select on an array element.  I really don't know how the
> object-oriented-ness of postgress works, the only docs only seem to
> cover the relational paradigm.
>
>
> Adam Lang wrote:
> >
> > Not that I know of, but a couple people have been toying with the idea
of
> > starting something like that... I think we are mostly all talk right
now. :)
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company
> > http://www.rutgersinsurance.com
> > ----- Original Message -----
> > From: "Peter Cheng" <oolumi1@kimo.com.tw>
> > To: <pgsql-general@postgresql.org>
> > Sent: Tuesday, January 09, 2001 4:01 AM
> > Subject: [GENERAL] xml middleware
> >
> > > Hi,
> > >
> > > Does Postgres provide xml middleware?
> > > If so, would anyone tell me where I can get it,
> > > thanks.
> > >
> > > - Peter
> > >
> > > --------------------------------------------------------------------
> > > ©_¼¯¹q¤l«H½c¡E·¾³q¤ß¥@¬É  http://mail.kimo.com.tw
> > > < ºô ¸ô ¥Í ¬¡¡EºÉ ¦b ©_ ¼¯ >  http://www.kimo.com.tw
>
> --
> Joseph Shraibman
> jks@selectacast.net
> Increase signal to noise ratio.  http://www.targabot.com


pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: Re: converting .xls to delimited file
Next
From: Lee Joramo
Date:
Subject: Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly