Thread: xml middleware
Hi, Does Postgres provide xml middleware? If so, would anyone tell me where I can get it, thanks. - Peter -------------------------------------------------------------------- 奇摩電子信箱‧溝通心世界 http://mail.kimo.com.tw < 網 路 生 活‧盡 在 奇 摩 > http://www.kimo.com.tw
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 > > -------------------------------------------------------------------- > 奇摩電子信箱‧溝通心世界 http://mail.kimo.com.tw > < 網 路 生 活‧盡 在 奇 摩 > http://www.kimo.com.tw
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 > > 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
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 > > 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
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. :) > > > 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
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