We use a program based around the expat XML parser and which
incorporates a table of document entity paths created from the DTD and
associated with a callback (method) or a data address. When it hits an
end tag which represents the end of a row it inserts the row into the
DB. It runs fast and handles documents of arbitrary size.
Our main application for it is to generate remote mirrored database subsets.
Rather than transferring data by XML you might find it better to use SQL.
JS
Rajan, Vivek K wrote:
Thanks for answers.
Sorry, I was not clear in my previous email. I do know the structure of
the for the XML - I was wondering if there was a direct upload
capability, once I know the structure of the XML.
Vivek
-----Original Message-----
From: A. Pagaltzis [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 8:54 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] XML to SQLite upload
* John Stanton <[EMAIL PROTECTED]> [2006-05-05 05:45]:
We feed XML into an SQLITE database, but the XML DTD maps the
database in structure and names. To get general XML data and
load it into any database requires a program of some
description to translate names and structures.
That was the point though. You have to assume some sort of
convention about the structure of the XML, because there is no
direct way to map XML into a relational model, and if Vivek Rajan
does not tell us what he needs, we cannot tell him if such a
thing exists or how to go about it.
The question does not preclude an answer; it just gives too few
constraints to answer it usefully.
Regards,
--
Aristotle Pagaltzis // <http://plasmasturm.org/>
