On Thu, May 7, 2009 at 2:51 PM, Ben Marchbanks <b...@alqemy.com> wrote: > That makes good sense - if my task were repetitive I would take that > route - I opted to write > a quick and dirty PHP script just to handle this one-off case and it > worked like a charm. > > I can share the script as a jumping off point for anyone who is interested.
Add it to the wiki at sqlite.org under a suitable title. That way it won't be forgotten, and it would be available to others. > > > *Ben Marchbanks* > > > > John Stanton wrote: >> Write a simple program.. >> >> As I recall our programs which do this use the Expat parser and obey a >> protocol where the XML DTD represents the database tables and columns so >> that SQL can be generated directly from the XML. It makes for a handy way >> to transport a database, or a part of a database in a universal format. All >> that is needed is the program to scan the database and generate XML and one >> to receive the XML and transform it into SQL statements. >> >> >> Ben Marchbanks wrote: >> >>> Whats the best way to import a large number of records ? >>> 120K+ currently stored as an XML file. >>> >>> >>> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, Geospatial Data http://sciencecommons.org Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
