Certainly stuffing the data in MySQL gives you great flexibility.  It
shouldn't be a big deal to write a PHP or Perl script to stuff the data
into the database.  This makes reporting a whale of a lot easier, too.
It sounds as if you are already generating XML files.  No reason you
couldn't just suck the XML from the PIC into the database and eliminate
the intermediate file.  But I presume you have already sorted out the
messy issues of not overwriting old files, etc.

If you aren't familiar with PHP think of it as sloppy C.  It is a little
easier to get to the database in PHP than C, mostly because PHP is
interpreted so changes are quicker when you are sorting things out.  I
also believe PHP has a library to make parsing the XML simpler, although
I haven't used that myself.

An easier (if not as elegant) solution is to convert the XML to SQL and
suck it into the database through the command line interface.  A little
bit of bash and you can automate this on the crontab.

--McD

On Sat, 2014-07-05 at 08:25 -0700, Harold Hallikainen wrote:
> I have a bunch of pic32 systems posting xml to a server. I could have the
> server parse the xml and save the data in mysql. Another possibility woul=
d
> be to just append new xml to the old in a text file, then access the data
> in that file to generate reports. I like the simplicity of just saving th=
e
> xml. I'd like to hear comments on this and suggested xml database engines
> to search the data. This is running on a centos system.
>=20
> Thanks!
>=20
> Harold
>=20
>=20
>=20
> --=20
> FCC Rules Updated Daily at http://www.hallikainen.com - Advertising
> opportunities available!
> Not sent from an iPhone.


--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.