Skip site navigation (1) Skip section navigation (2)

Re: From TODO, XML?

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Frank Ch. EiglerDate: 2001-07-28 02:24:31
Subject: Re: From TODO, XML?
Previous:From: Bill StudenmundDate: 2001-07-28 00:09:50
Subject: Re: Re: plpgsql: Debug function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group