Re: [sqlite] XML to SQLite upload

2006-05-07 Thread John Stanton
We built a tool at one time for a specific application which would build B-tree indices onto an XML document, giving read-only access to what became many tables like a relational database. It tied together disparate legacy application systems. The addition of an SQL compiler and query engine

Re: [sqlite] XML to SQLite upload

2006-05-07 Thread A. Pagaltzis
* Steve O'Hara <[EMAIL PROTECTED]> [2006-05-07 11:20]: > This is the right approach, when I worked in the SGML world > with a component versioning system, we called it the > "non-linear" design. > > By going down this road, your table schema is static and can > cope with any type of DTD without ch

[sqlite] RE: [RBL] Re: [sqlite] XML to SQLite upload

2006-05-07 Thread Steve O'Hara
[mailto:[EMAIL PROTECTED] org] On Behalf Of A. Pagaltzis Sent: 05 May 2006 06:14 To: sqlite-users@sqlite.org Subject: [RBL] Re: [sqlite] XML to SQLite upload Hi Vivek, * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 06:40]: > Sorry, I was not clear in my previous email. I do know the >

Re: [sqlite] XML to SQLite upload

2006-05-05 Thread John Stanton
] 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 stru

RE: [sqlite] XML to SQLite upload

2006-05-05 Thread Clay Dowling
Rajan, Vivek K said: > 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. I think that the problem is a little too generic for an exist

Re: [sqlite] XML to SQLite upload

2006-05-04 Thread A. Pagaltzis
Hi Vivek, * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 06:40]: > 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. well, you can map generic XML to a rel

RE: [sqlite] XML to SQLite upload

2006-05-04 Thread Rajan, Vivek K
>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 nam

Re: [sqlite] XML to SQLite upload

2006-05-04 Thread A. Pagaltzis
* 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

Re: [sqlite] XML to SQLite upload

2006-05-04 Thread John Stanton
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. JS A. Pagaltzis wrote: * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-

Re: [sqlite] XML to SQLite upload

2006-05-04 Thread James Bailie
A. Pagaltzis wrote: > * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 02:20]: >> Does someone have XML to SQLite upload utility in perl/C++? > > Thats like asking if someone has an ASCII to CSV upload > utility. It doesnt make any sense. > He is probably looking for a utility which will se

Re: [sqlite] XML to SQLite upload

2006-05-04 Thread A. Pagaltzis
* Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 02:20]: > Does someone have XML to SQLite upload utility in perl/C++? That’s like asking if someone has an ASCII to CSV “upload utility”. It doesn’t make any sense. Regards, -- Aristotle Pagaltzis //