Web lists-archives.com

Re: Xml data import




On Fri, Dec 12, 2014 at 8:31 PM, Sayth Renshaw <flebber.crue@xxxxxxxxx> wrote:
> And does that then lead you to use Fabric?
>
> http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding

No, I've never used that. I just process the the data in python.


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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql