Re: DRDA, network protocol, and documentation

On Thu, Feb 07, 2002 at 04:02:10PM +1100, Gavin Sherry wrote:
> On Tue, 5 Feb 2002, Brian Bruns wrote:
>
> > I also noticed on the TODO list someone has put SQL*Net support as a
> > network protocol. Is this a serious plan or just a pipedream? Part of
> > what I'm aiming to do is make the network protocol stuff fairly modular so
> > you could support the current protocol, and DRDA, and presumably SQL*Net
> > or TDS (Microsoft/Sybases protocol), etc...
>
> I intend on looking into ways to implement SQL*Net/TNS etc. It's not
> pretty but would be remarkably useful. I haven't started looking at it
> yet because PostgreSQL doesn't support all of the Oracle's SQL
> implementation. Until this happens there's really not much point.

I'd really like to see something that does XML queries, either over
HTTP (POST/PUT) or BEEP (RFC 3080, 3081). I can start work on
something generic (I've been meaning to start hacking pg anyway...).
A generic input format (application/vnd.postgresql-query) and a
generic XML schema that handles any query. Ideally, you'd have the
ability to designate an XML schema (SELECT [AS XML [SCHEMA 'blah']] ...),
and an xml schemas table that has a description of the data parts,
so the output XML is exactly right.

I'm still wrapping my brain around this concept, if anybody else
is interested in this let me know.

--
David Terrell | "When we said that you needed to cut the
dbt(at)meat(dot)net | wires for ultimate security, we didn't
Nebcorp Prime Minister | mean that you should go wireless instead."
http://wwn.nebcorp.com/ | - Casper Dik