From: | mlw <markw(at)mohawksoft(dot)com> |
---|---|
To: | jgray(at)beansindustry(dot)co(dot)uk, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: From TODO, XML? |
Date: | 2001-07-28 00:11:35 |
Message-ID: | 3B620337.53289167@mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
jgray(at)beansindustry(dot)co(dot)uk wrote:
>
> In article <3B615336(dot)D654E7E1(at)mohawksoft(dot)com>, markw(at)mohawksoft(dot)com (mlw)
> wrote:
> > I was looking over the todo list and saw that someone wanted to support
> > XML. I have some quick and dirty stuff that could be used.
> >
>
> I'm not clear from the TODO what that "XML support" might involve. The
> reference to pg_dump suggests an XML dump format for databases. That only
> makes sense if we build an XML frontend that can load XML-based pg_dump
> files.
>
> I can't see any very useful application though, unless someone has a
> standard for database dumps using XML -I'd have thought that our current
> "list of SQL statements" dump is fine (and useful if you speak SQL)
Actually I have been thinking about a couple projects I have done. Vendors like
to think XML is a way to distribute databases.
So a parser that can scan a DTD and make a usable create table (...) line would
be very helpful. One which could compare a DTD to an existing SQL table and map
XML data correctly. (Or error if conversion from data to SQL types yields an
error.)
During a database export, a SQL table could be used to create a DTD.
I was thinking along the line of being able to use XML as a fairly portable
import/export feature. Having this ability, as a generic solution, would have
made several tasks MUCH easier.
I would also like the XML parser to be fuzzy enough to take some bad XML
(because ALL XML is bad), because a lot of vendors like to distribute data in
bad XML.
--
5-4-3-2-1 Thunderbirds are GO!
------------------------
http://www.mohawksoft.com
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Ch. Eigler | 2001-07-28 02:24:31 | Re: From TODO, XML? |
Previous Message | Bill Studenmund | 2001-07-28 00:09:50 | Re: Re: plpgsql: Debug function? |