xml middleware

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

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

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 wrote:

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.

That sounds like a trivial program.

Just loop through the result set and append to a StringBuffer.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com

Is there any xml standard to output database content?

Franck Martin
Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org
Web site: http://www.sopac.org/

This e-mail is intended for its recipients only. Do not forward this e-mail
without approval. The views expressed in this e-mail may not be necessarily
the views of SOPAC.

-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: Thursday, 11 January 2001 10:10
To: Adam Lang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] xml middleware

Adam Lang wrote:

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.

That sounds like a trivial program.

Just loop through the result set and append to a StringBuffer.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com

At 10:14 AM 1/11/2001 +1200, Franck Martin wrote:

Is there any xml standard to output database content?

Not that I know of. There is a micro soft format, an oracle format, a DB/2,
format a WDDX format, and probably a thousand other formats as well. The
WDDX people have parsers in perl and php and seems to be the most cross
platform.

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. :)

Ok, did you know who is working on it?
Thanks.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com

--
Peter Cheng

--------------------------------------------------------------------
嚙稻嚙踝蕭嚙緬嚙締嚙瘡嚙箱嚙瘟嚙踝蕭嚙緬嚙賠世嚙踝蕭 http://mail.kimo.com.tw
< 嚙踝蕭 嚙踝蕭 嚙踝蕭 嚙踝蕭嚙瘟嚙踝蕭 嚙箭 嚙稻 嚙踝蕭 > http://www.kimo.com.tw

I'd assume you'd need to make your own up (or whoever develops it.) I'd say
develop a schema that can be accessible from the internet so the XML can be
interpreted.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Franck Martin" <Franck@sopac.org>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, January 10, 2001 5:14 PM
Subject: RE: [GENERAL] xml middleware

Is there any xml standard to output database content?

Franck Martin
Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org
Web site: http://www.sopac.org/

This e-mail is intended for its recipients only. Do not forward this

e-mail

without approval. The views expressed in this e-mail may not be

necessarily

the views of SOPAC.

-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: Thursday, 11 January 2001 10:10
To: Adam Lang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] xml middleware

Adam Lang wrote:

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

I don't recall names, but it came up in the interfaces list. Like I said,
if anyone is actually working on it, I do not know, we just chatted and
threw out some ideas and said it would be really neat. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Peter Cheng" <oolumi1@kimo.com.tw>
To: "Adam Lang" <aalang@rutgersinsurance.com>;
<pgsql-general@postgresql.org>
Sent: Thursday, January 11, 2001 9:09 PM
Subject: Re: xml middleware

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. :)

Just came across this

http://www.zvon.org/xxl/XSLTreference/Output/index.html

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tim Uckun
Sent: Wednesday, January 10, 2001 5:31 PM
To: Franck Martin; pgsql-general@postgresql.org
Subject: RE: [GENERAL] xml middleware

At 10:14 AM 1/11/2001 +1200, Franck Martin wrote:

Is there any xml standard to output database content?

Not that I know of. There is a micro soft format, an oracle format, a DB/2,
format a WDDX format, and probably a thousand other formats as well. The
WDDX people have parsers in perl and php and seems to be the most cross
platform.

What does an XSLT refrence have to do with anything?

Dave Cramer wrote:

Just came across this

http://www.zvon.org/xxl/XSLTreference/Output/index.html

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tim Uckun
Sent: Wednesday, January 10, 2001 5:31 PM
To: Franck Martin; pgsql-general@postgresql.org
Subject: RE: [GENERAL] xml middleware

At 10:14 AM 1/11/2001 +1200, Franck Martin wrote:

Is there any xml standard to output database content?

Not that I know of. There is a micro soft format, an oracle format, a DB/2,
format a WDDX format, and probably a thousand other formats as well. The
WDDX people have parsers in perl and php and seems to be the most cross
platform.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com