Hi flebber, thanks for bottom-posting. :-)
On Tue, 17 Apr 2012 23:04:27 -0700 (PDT) flebber <flebber.c...@gmail.com> wrote: > 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. > I've read the Perl XML book and it's a nice book - not long yet informative. Here is my review it: http://perl.org.il/books/059600205X.html Regarding Perl & databases, I'm quoting one of my replies to Boston-pm, whose archive appears to be private: [QUOTE] Well, as far as I know the CPAN DBI module did not break backwards compatibility since the year 2000 (though naturally there probably were many bug fixes and possibly some new features). What has changed considerably are the various layers above DBI.pm - from https://metacpan.org/release/DBIx-Simple (which gives you relatively little, but it's still pretty useful) to https://metacpan.org/release/DBIx-Class and its various dependencies and extensions (which is a full-fledged Object-Relational Mapper (ORM)) and maybe also https://metacpan.org/release/KiokuDB , which is an Object Graph storage engine, which can use several backends including DBI. There are many other DBI extensions in the DBIx:: and SQL:: namespaces . So will a book be appropriate? I'm not aware of any printed book, that covers all of that in a comprehensive manner, and even if you learn about SQL databases, SQL and then about DBI (which is time consuming by itself), you should at least play with DBIx-Class, to see if it's good enough for you. I've written a little about Databases in Perl here: http://perl-begin.org/uses/databases/ > > Now, There's this one : (for PHP) > http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166/ref=sr_1_2?s=books&ie=UTF8&qid=1334202498&sr=1-2 > > Along with the very good reviews it gets, (yes, I know, online reviews), > I flipped through it for 20 minutes or so, in a book store, and it looks > like solid and well written information. > > > can it be that there's not a current equivalent for Perl ? > Well, someone might take the initiative and write or compile a book about the current state of the art with the DBI ecosystem in Perl, and possibly publish it as an E-book and/or on http://lulu.com/ . But it is bound to become out-of-date and I feel that the online documentation may be good enough for people who don't want or need a printed book. Now that I think of it, it is possible that some of the books about Catalyst (see http://www.catalystframework.org/ ) cover DBIx-Class to some extent, but they may assume some prior knowledge. Good luck! [/QUOTE] Regards, Shlomi Fish -- ----------------------------------------------------------------- Shlomi Fish http://www.shlomifish.org/ http://www.shlomifish.org/humour/ways_to_do_it.html Real programmers use a nice editor and a nice programming language and get it done in less than O(N!). — vanguard on Freenode’s ##programming Please reply to list if it's a mailing list post - http://shlom.in/reply . -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
