On Fri, Dec 12, 2014 at 8:31 PM, Sayth Renshaw <flebber.c...@gmail.com> 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.mart...@gmail.com> wrote: >> >> On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw <flebber.c...@gmail.com> >> 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 <vegiv...@tuxera.be> >> > wrote: >> > >> >> >> >> ----- Original Message ----- >> >> > From: "Sayth Renshaw" <flebber.c...@gmail.com> >> >> > 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
