Programming the Perl DBI

Programming the Perl DBI

Author: Tim Bunce

Publisher: "O'Reilly Media, Inc."

Published: 2000-02-04

Total Pages: 366

ISBN-13: 1449315917

DOWNLOAD EBOOK

One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based web and intranet applications.The primary interface for database programming in Perl is DBI. DBI is a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, Informix, you name it. The design of DBI is to separate the actual database drivers (DBDs) from the programmer's API, so any DBI program can work with any database, or even with multiple databases by different vendors simultaneously.Programming the Perl DBI is coauthored by Alligator Descartes, one of the most active members of the DBI community, and by Tim Bunce, the inventor of DBI. For the uninitiated, the book explains the architecture of DBI and shows you how to write DBI-based programs. For the experienced DBI dabbler, this book reveals DBI's nuances and the peculiarities of each individual DBD.The book includes: An introduction to DBI and its design How to construct queries and bind parameters Working with database, driver, and statement handles Debugging techniques Coverage of each existing DBD A complete reference to DBI This is the definitive book for database programming in Perl.


Perl for Oracle DBAs

Perl for Oracle DBAs

Author: Andy Duncan

Publisher: "O'Reilly Media, Inc."

Published: 2002-08-19

Total Pages: 624

ISBN-13: 1449390919

DOWNLOAD EBOOK

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal.You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities. The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate with Oracle databases. Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason. The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tasks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more. The book also explains how Oracle DBAs and developers can extend the toolkit and solve their own database administration problems using Perl.


Perl Programming for Biologists

Perl Programming for Biologists

Author: D. Curtis Jamison

Publisher: John Wiley & Sons

Published: 2003-07-14

Total Pages: 206

ISBN-13: 9780471430599

DOWNLOAD EBOOK

Working on the assumption that the reader has no formal training in programming, Perl Programming for Biologists demonstrates how Perl is used to solve biological problems. Each chapter opens with a set of learning objectives, provides numerous review questions and self-study exercises, and concludes with a bulleted summary of key points. The author incorporates numerous real-life examples throughout the text. Upon completing the book, readers are able to quickly perform such tasks as correcting recurring errors in spreadsheets, scanning a Fasta sequence for every occurrence of an EcoRI site, adapting other writers' scripts to one's own purposes, and most important, writing reusable and maintainable scripts that spare the rote repetition of code.


Advanced Perl Programming

Advanced Perl Programming

Author: Sriram Srinivasan

Publisher: "O'Reilly Media, Inc."

Published: 1997

Total Pages: 444

ISBN-13: 9781565922204

DOWNLOAD EBOOK

Covers advanced features of Perl, how the Perl interpreter works, and presents areas of modern computing technology such as networking, user interfaces, persistence, and code generation.


Perl Database Programming

Perl Database Programming

Author: Brent Michalski

Publisher: Wiley

Published: 2002-11-07

Total Pages: 580

ISBN-13: 9780764549564

DOWNLOAD EBOOK

Author is an experienced Perl user who maintains the Perl area of Dr. Dobb's Journal Website. * The first book to cover the full range of Perl database programming topics. * Discusses practical applications such as online catalogs, Web-based photo databases, and Palm-powered applications.


Learning Perl

Learning Perl

Author: Randal Schwartz

Publisher: "O'Reilly Media, Inc."

Published: 2011-06-23

Total Pages: 389

ISBN-13: 1449303587

DOWNLOAD EBOOK

The sixth edition of this bestselling Perl tutorial includes recent changes to the language. Years of classroom testing and experience helped shape the book's pace and scope, and this edition is packed with exercises that let readers practice the concepts while they follow the text.


Perl Programming for Medicine and Biology

Perl Programming for Medicine and Biology

Author: Jules J. Berman

Publisher: Jones & Bartlett Learning

Published: 2007

Total Pages: 428

ISBN-13: 9780763743338

DOWNLOAD EBOOK

Written for biomedical professionals and hospital practitioners interested in creating their own programs, Perl Programming for Medicine and Biology, discusses and reviews biomedical data resources, data standards, data organization, medicolegal and ethical conduct for data miners, and grants-related data sharing responsibilities. It teaches readers the basic Perl programming skills necessary for collecting, analyzing, and distributing biomedical data and provides solutions to in-depth problems that face researchers and healthcare professionals. Non-technical "Background" sections open each chapter to help non-programmers easily comprehend programming procedures. Explanations are provided for the biomedical issues underlying the Perl scripts that follow, and examples of real-world implementation are provided. Perl Programming for Medicine and Biology will show you how to transform, merge, and examine large and complex databases with ease.


Modern Perl Programming

Modern Perl Programming

Author: Michael Saltzman

Publisher: Prentice Hall

Published: 2002

Total Pages: 372

ISBN-13:

DOWNLOAD EBOOK

The complete Perl learning resource for novices and experienced programmers alike, with advanced coverage that highlights GUI development, networking applications, real database integration, and much more. Includes many clear examples of using references (pointers)--the cornerstone of all advanced Perl development.


Higher-Order Perl

Higher-Order Perl

Author: Mark Jason Dominus

Publisher: Elsevier

Published: 2005-03-31

Total Pages: 601

ISBN-13: 0080478344

DOWNLOAD EBOOK

Most Perl programmers were originally trained as C and Unix programmers, so the Perl programs that they write bear a strong resemblance to C programs. However, Perl incorporates many features that have their roots in other languages such as Lisp. These advanced features are not well understood and are rarely used by most Perl programmers, but they are very powerful. They can automate tasks in everyday programming that are difficult to solve in any other way. One of the most powerful of these techniques is writing functions that manufacture or modify other functions. For example, instead of writing ten similar functions, a programmer can write a general pattern or framework that can then create the functions as needed according to the pattern. For several years Mark Jason Dominus has worked to apply functional programming techniques to Perl. Now Mark brings these flexible programming methods that he has successfully taught in numerous tutorials and training sessions to a wider audience.* Introduces powerful programming methodsnew to most Perl programmersthat were previously the domain of computer scientists* Gradually builds up confidence by describing techniques of progressive sophistication* Shows how to improve everyday programs and includes numerous engaging code examples to illustrate the methods


MySQL and Perl for the Web

MySQL and Perl for the Web

Author: Paul DuBois

Publisher: Sams Publishing

Published: 2001

Total Pages: 550

ISBN-13: 9780735710542

DOWNLOAD EBOOK

MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites. It shows how to use Perl's DBI database access module, pairing it with with the CGI.pm module that allows Web pages and forms to be generated and processed easily. These tools provide developers with a solid foundation for creating applications that incorporate database content to create dynamic, up-to-date Web sites. The book employs a practical learn-by-doing approach that demonstrates development techniques by building complete applications, not just fragmentary pieces. It shows what to do at each step of the way during the process of building live, working examples. Applications are fully explained so you can understand how they work and apply the techniques they illustrate to your own projects.