Re: [sqlite] XML into sqlite

2014-09-11 Thread Petite Abeille
On Sep 11, 2014, at 5:45 PM, Carlos A. Gorricho <cgorri...@heptagongroup.co> wrote: > Next step is to venture into XML - sqlite integration...both ways. Considering you are on a *nix system, you may find Dan Egnor’s xml2 set of command line utilities of interest: http://www.ofb.n

Re: [sqlite] XML into sqlite

2014-09-11 Thread Carlos A. Gorricho
problems I have solved in the past with Access. So far, I have been able to replicate everything. Next step is to venture into XML - sqlite integration...both ways. With some restrictions, it worked well between Access and XML, via Excel. Cheers, CARLOS A. Sent from my iPad > On 11/09/2014, a

Re: [sqlite] XML into sqlite

2014-09-11 Thread Simon Slavin
On 11 Sep 2014, at 6:04am, Carlos A. Gorricho <cgorri...@heptagongroup.co> wrote: > How would you recommend to drop XML data into an sqlite DB? I am guessing > there is more than one way. Is this a one-time thing or are you going to have to do it every month/week ? Do you have

Re: [sqlite] XML into sqlite

2014-09-11 Thread Gert Van Assche
I'm using XSLT to create CSV. gert 2014-09-11 7:04 GMT+02:00 Carlos A. Gorricho <cgorri...@heptagongroup.co>: > > How would you recommend to drop XML data into an sqlite DB? I am guessing > there is more than one way. > > I thought of importing XML into Excel, convertin

[sqlite] XML into sqlite

2014-09-10 Thread Carlos A. Gorricho
How would you recommend to drop XML data into an sqlite DB? I am guessing there is more than one way. I thought of importing XML into Excel, converting to csv, for further import into sqlite, now that I know how to import csv into sqlite ... almost always! But this seems like a long haul

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

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

2006-05-07 Thread Steve O'Hara
MAIL 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 > 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

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

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 na

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]> [2

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

[sqlite] XML to SQLite upload

2006-05-04 Thread Danilo
://www.digitazero.org/?p=33 Regards, Danilo. Home Page: http://www.digitazero.org venerdì 5 maggio 2006 A. Pagaltzis ha scritto: * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 02:20]: Does someone have XML to SQLite

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 // <http://plasmasturm.org/>

[sqlite] XML to SQLite upload

2006-05-04 Thread Rajan, Vivek K
Does someone have XML to SQLite upload utility in perl/C++? Vivek

Re: [sqlite] XML and SQLite?

2005-01-23 Thread Jeff
or > >should I just put it on the file system. Which would be faster? > > I would say that it depends on their quantity or use. If you are > having thousands of little XML files, then store all of them in a > SQLite database, each one in a SQLite record, where the XML is all in

Re: [sqlite] XML and SQLite?

2005-01-22 Thread David Wheeler
On Jan 22, 2005, at 11:13 PM, Jeff wrote: Here is the question: Should I store XML files in a database, or should I just put it on the file system. Which would be faster? The file system would be faster, since SQLite sits on top of it, anyway, so you have its overhead no matter what. Regards,

[sqlite] XML and SQLite?

2005-01-22 Thread Jeff
I'm making something that requires XML. (ooh, secretness) It would also be nice to use SQLite with it, but I am confused about how much things I need to put into the database and how much that needs to stay on the file system. You probably didn't understand that. My describing skills suck. Here