On Apr 18, 2:50 pm, dpchr...@holgerdanske.com (David Christensen) wrote: > On 04/17/2012 08:28 PM, flebber wrote: > > >> Can anyone recommend a good book/s for Perl and learning how to handle > >> XPath,XML,SQL, XQuery. > >> I would like to know better how to handle and retrieve text formats > >> and utilise database storage of the data. > > Sorry I should have pointed out in ref to above I meant to add using > > perl tools DBI etc. Which perl tools and how to use them. > > All help appreciated > > "Programming the Perl DBI; Database programming with Perl" is the > canonical book on Perl/ DBI: > > http://shop.oreilly.com/product/9781565926998.do > > But, the MySQL and PostgreSQL books I've read also included chapters or > sections for various programming languages, including Perl. > > If you're doing simple database stuff and/or want to interface with > various data stores (plain text/ CSV, SQLite, MS Excel/ Access/ SQL > Server, MySQL, PostgreSQL, Oracle, etc.), the first book would be > better. If you're going to do hard-core database stuff ("large" amounts > of data, vendor-specific optimizations/ features, internal programming > languages/ stored procedures, etc.), choose your engine and find a > matching book with a Perl chapter. > > HTH, > > David
Thanks David. I need to create an XML feed from Website data and store it in a MSSQL database. Then create queries stored procedures on that data and present the data in a web format. I will also be using MySQL but as part of my main project. I also saw Perl XML - http://shop.oreilly.com/product/9780596002053.do These will probably both be good references but was a little concern that the publication dates were 2000 and 2002. Perl and the core technologies involved have had significant advancement in that time. Sayth -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
