From: | "Bob Calco" <robert(dot)calco(at)verizon(dot)net> |
---|---|
To: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, "Alan Gutierrez" <ajglist(at)izzy(dot)net> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: XML ouput for psql |
Date: | 2003-03-05 14:09:50 |
Message-ID: | NCEJJNLDMEJLEJHKNGNHAEDPIGAA.robert.calco@verizon.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I would like to see PostgreSQL eventually support XQuery:
http://www.w3.org/TR/xquery/
http://www.w3.org/TR/query-datamodel/
I see potentially an alternative front end called xsql, providing
substantially the same functionality as psql, only using XQuery syntax and
optionally returning recordsets as XML.
Anybody want to put together a team to explore this seriously? There are
probably several non-trivial semantic issues on the back end, but I only
dimly grasp them at this point.
- Bob Calco
%% -----Original Message-----
%% From: pgsql-hackers-owner(at)postgresql(dot)org
%% [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Merlin Moncure
%% Sent: Wednesday, March 05, 2003 8:16 AM
%% To: Alan Gutierrez
%% Cc: pgsql-hackers(at)postgresql(dot)org
%% Subject: Re: [HACKERS] XML ouput for psql
%%
%%
%% XSLT could be used to convert virtually any xml table format directly
%% into an insert statement. For me, this is better than using a
%% programming language plus a parser. XSLT is quite powerful and fast and
%% is build on top of xpath, and is a closer fit to the declarative
%% programming model of sql. Validation could be done at the xslt stage or
%% with schemas, which I prefer.
%%
%%
%% > Acually, the difficult part has been getting the information back
%% > into the database. Getting it out is a very simple query. I imagine
%% > that every language/environment has an SQL->XML library somewhere,
%% > but I wasn't able to find something that would go from XML to SQL.
%% >
%%
%% ---------------------------(end of broadcast)---------------------------
%% TIP 3: if posting/reading through Usenet, please send an appropriate
%% subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
%% message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Eric D Nielsen | 2003-03-05 14:48:48 | Re: Updateable views... |
Previous Message | Tatsuo Ishii | 2003-03-05 13:49:27 | Re: Win32 Powerfail testing |