Web lists-archives.com

Re: Xml data import




And does that then lead you to use Fabric?

http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding

Sayth

On Sat, 13 Dec 2014 9:06 AM Larry Martell <larry.martell@xxxxxxxxx> wrote:

> On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw <flebber.crue@xxxxxxxxx>
> wrote:
> > So it is definitely achievable, I see other db's converting xml2json etc
> to
> > get it in.
>
> I use this https://github.com/hay/xml2json
>
> > Sends odd that xml had done great document qualities but as a data format
> > it seems rather hard to work with.
>
> Indeed.
>
>
> > On Fri, 12 Dec 2014 9:55 PM Johan De Meersman <vegivamp@xxxxxxxxx>
> wrote:
> >
> >>
> >> ----- Original Message -----
> >> > From: "Sayth Renshaw" <flebber.crue@xxxxxxxxx>
> >> > Subject: Xml data import
> >> >
> >> > I have an xml data feed with xsd, it's complex in elements not size.
> Wray
> >> > are the best way to get data into mysql, do I have to hack with
> xquery?
> >>
> >> That's going to depend on the complexity of your XML and how much of
> that
> >> complexity you want preserved. There's definitely libraries out there
> that
> >> can map XML (tree) structures onto relational structures; although it's
> >> been so long since I played with XML that I really couldn't tell you
> which
> >> ones.
> >>
> >> > My goal is to be able create queries and send csv files out for
> analysis
> >> in
> >> > R and plots in ggplot2. Also render done other off the initial days to
> >> the
> >> > Web usually xslt from xml.
> >>
> >> I suppose that worstcase you could use XSLT to transform into a flatter
> >> structure, maybe even CSV?
> >>
> >>
> >> --
> >> Unhappiness is discouraged and will be corrected with kitten pictures.
> >>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>