If you do not desperately need MySQL, there are many non-relational
database software around (most people refer these as "nosql" but this
technology is not against the query language, but the traditional tables,
columns and rows). The main idea is that you do not need to design the
database upfront, just throw the structured or unstructured data in it and
get a very fast query capability for that. That reduces the development
time significantly, especially if you need to modify the data structure you
want to store -- no more redesigning tables and converting / reimporting
data. Most of them are used in high available online systems and in big
data science field.

Better description what "NoSql" is:
http://en.wikipedia.org/wiki/NoSQL

Many of these systems simply can be fed by JSON data, but there are some
with XML as well. Check out MongoDB, ElasticSearch, Redis, Cassandra, BaseX
etc.

List of NoSql databases:
http://nosql-database.org

Tamas





On 6 July 2014 05:45, Bob Ammerman <picram@roadrunner.com> wrote:

> If you just tack one XML file onto the end of another you will have
> malformed XML. This is because every properly formed XML document must ha=
ve
> a single tag (often called the root or document tag) that wraps the entir=
e
> document. For example:
>
> <a>
>   <b></b>
> </a>
>
> Is valid, but:
>
> <a>
>   <b></b>
> </a>
> <a>
>   <b></b>
> </a>
>
> Is malformed.
>
> ~ Bob Ammerman
> RAm Systems
>
> -----Original Message-----
> From: piclist-bounces@mit.edu [mailto:piclist-bounces@mit.edu] On Behalf
> Of
> Harold Hallikainen
> Sent: Saturday, July 05, 2014 11:26 AM
> To: Pic List
> Subject: [OT] XML database?
>
> 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 the
> 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.
>
> Thanks!
>
> Harold
>
>
> --
> http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
> View/change your membership options at
> http://mailman.mit.edu/mailman/listinfo/piclist
>



--=20
int main() { char *a,*s,*q; printf(s=3D"int main() { char *a,*s,*q;
printf(s=3D%s%s%s, q=3D%s%s%s%s,s,q,q,a=3D%s%s%s%s,q,q,q,a,a,q); }",
q=3D"\"",s,q,q,a=3D"\\",q,q,q,a,a,q); }
--=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
.