Re: [sqlite] XML into sqlite

2014-09-11 Thread Petite Abeille
On Sep 11, 2014, at 5:45 PM, Carlos A. Gorricho 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.net/~egnor/xml2/ Allows for rather strai

Re: [sqlite] XML into sqlite

2014-09-11 Thread Carlos A. Gorricho
For the time being, it's a one-off thing. In the future it could become regular. I used to solve all my analytical DB needs with MS Access. Since I migrated to a Mac I decided to look for a new DB engine and am exploring sqlite. I have been running a couple of tests, based on actual data problem

Re: [sqlite] XML into sqlite

2014-09-11 Thread Simon Slavin
On 11 Sep 2014, at 6:04am, Carlos A. Gorricho 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 a favourite programming language, or do you

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 : > > 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

[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. Che