|
|
|
 |
Object Oriented Exception Handling in Perl
The main goal of this article is to discuss in detail about exception handling in Perl and how to implement it using Error.pm. On our way, we'll be touching upon the advantages of using exception-handling over traditional error-handling mechanisms, exception handling with eval {}, problems with eval {} and the functionalities available in Fatal.pm. But by and large, our focus we'll be on using Error.pm for exception handling. [EDITORS_NOTE: RR]
[ Covers: ]
|
 |
 |
Comparison of Different SQL Implementations - Compatibility/Differences Matrix for SQL (e.g. Oracle 10g vs. MySql 5.0.18)
Compares in detail, the differences in the SQL of: Standards-Compliant SQL:2003 vs. Oracle 10g Release 1 Standard Edition vs. MySQL 5.0.18 vs MS SQL Server 2005 (Microsoft SQL Express) vs. DB2 vs. PostgreSQL. This is a detailed compatibility/differences matrix which covers many useful and important statements, functions and syntax. About 30 of the most important differences are thoroughly covered. This is an important resource for those undertaking a database engine migration project.
[ Covers: compatibility migration incompatibility sql sequel mssql mysql oracle 10g postgressql db2 standard compliant limit order by statistics describe explain unique concat localtimestamp ]
|
 |
|
Programming the Perl DBI - Chapter 4 of the Authoritative O'Reilly Book on the Perl DBI
(developer.com) One of the authoritative texts on the subject of interfacing Perl with all the major database engines smoothly and easily via the powerful DBI module. This is perhaps the most useful chapter in this must-have book, reproduced here in it's entirety. Perl programmers, keep this link handy just in case you don't have your copy of the book with you.
[ Covers: perl dbi dbd dbh-> dbh handle database connection row oracle informix postgress mysql mssql msql sybase db2 csv connect fetch dsn data source name disconnect ]
|
|
|
Perl Module Anatomy - Handy Synopsis of the Key Components of A Perl Module
This page describes the initial contents of the .pm file which is created by h2xs, or which you will see in the majority of modules from CPAN or elsewhere. This explains how to use those key components as a starting point for a module. Helpful as a Perl module quick start guide.
[ Covers: ]
|
 |
 |
XMLHttpRequest - The Backbone of AJAX - Javascript Communicates with the Server Behind the Scenes
(Wikipedia) Definition and useful links to resources. AJAX refers to the powerful technique of using Javascript and other languages to communicate behind the scenes with an XML data source on a server, allowing for dynamic and responsive web applications. JSON is a common transport protocol in addition to XML. XMLHttpRequest is the key to the operation, defining the protocol which the script uses to transfer data.
[ Covers: xmlhttprequest ajax json xml http javascript jscript vbscript xmlprovider asynchronous javascript and xml jesse james garrett ecmascript dom iframe ebml ]
|
|
|
Application Configuration with Perl - CPAN::AppConfig - Similar to Config::Std
Code reuse is the single greatest advantage of modules in general, and of AppConfig in particular. In cases where the DIY (Do It Yourself) approach creates bugs and delays, AppConfig provides an efficient single solution that will more than likely satisfy most configuration needs. The config file format which AppConfig parses for you is similar to that used by Config::Std and the windows.ini format which is simple and readable. Using Persistent::DBI to store configuration data in a database is also discussed. [EDITOR: RR]
[ Covers: ]
|
 |
|
Test::More - A Preferred Unit Testing Framework and Utilities (perldoc)
(perldoc.org) This is the perldoc documentation and it is relatively detailed. The Test::More module provides fairly comprehensive testing utilities for your Perl code. Various ways to say "ok" with better diagnostics. It has facilities to skip tests, test future features and compare complicated data structures. It is a preferred Unit Testing Framework.
[ Covers: Test::More unit test software test perl qa diagnostics Test::Simple no_plan Test::Harness plan() tests ok is isnt fail pass like unlike cmp_ok can_ok isa_ok use_ok require_ok is_deeply diag ]
|
|
|
Oracle 10g Documentation Library - Comprehensive
(oracle.com) All of Oracle's official documentation, reference and tutorials for Oracle 10g in both HTML and PDF formats. This is the link to the main menu for your bookmarking pleasure.
[ Covers: oracle 10g documentation reference tutorials sql reference install getting started quick start tutorial how to write oracle sql administer application developer guide pl/sql reference ]
|
|
|
Class::DBI (CPAN) - A Database Abstraction Layer (DAL) for the Perl DBI
(cpan.org) This is the tutorial, example code and documentation on the CPAN site. Class::DBI is a simple database to object mapping layer, which can be used to implement several higher order database functions (triggers, referential integrity, cascading delete etc.), at the application level, rather than at the database. If you desire solid architecture for your web application you will need to use something like Class::DBI. It will make it easier for you to employ 'best practices' when working with relational databases.
[ Covers: class::dbi dbi wrapper database abstraction layer data abstraction layer DAL dbi class connection ]
|
|
 |
Mod Perl Performance Tuning
This is the authoritative list of techniques and resources to help you minimize execution time, memory and resource usage of your mod_perl web application code. From the official Mod Perl site itself, this is the place to begin when you are performance testing and tuning Mod Perl.
[ Covers: http_load, httpperf, preload, preloading, code profiling, Benchmark, wallclock, Devel::Dprof, diagnostics, tmon.out, libgtop, gtop, Apache::Status, precompile, maxrequestsperchild ]
|
|
 |
Smarty - The Compiling PHP Template Engine - Documentation
Smarty is a template engine for PHP. More specifically, it facilitates a manageable way to separate application logic and content from its presentation. This is best described in a situation where the application programmer and the template designer play different roles, or in most cases are not the same person. [EDITOR_NOTE: RR]
[ Covers: ]
|
|
|
Perl DBI Examples - From the Basics to Using Oracle Stored Procedures and Transactions
Excellent real world examples explained, including source code from basics to advanced, for: making connections, specifying options or attributes, issuing sql commands, using transactions, and calling oracle stored procedures.
[ Covers: [EDITORS_NOTE: MORE] ]
|
|
|
MySQL On Mac OS X
MySQL has become one of the most popular databases for Web applications. The database is well suited for common Web-related tasks like content management, and for implementing Web features like discussion boards and guestbooks. For a time, some developers avoided MySQL for commercial applications because it did not implement certain features, such as transactions. But this is no longer the case, and MySQL is a great choice for just about any Web-based application. [EDITORS_NOTE: RR]
[ Covers: ]
|
|
|
Installing MySQL on Mac OS X
You can install MySQL on Mac OS X 10.3.x (“Panther”) or newer using a Mac OS X binary package in PKG format instead of the binary tarball distribution. Please note that older versions of Mac OS X (for example, 10.1.x or 10.2.x) are not supported by this package. The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. It should then mount the image and display its contents. [EDITORS_NOTE: RR]
[ Covers: ]
|
|
|
High Performance MySQL
This article from the MySQL website is actually Chapter 6 from the O'Reilly book: High Preformance MySQL, entitled: Server Performance Tuning. Excellent overview of all the major issues from hardware selection and configuration, up through the operating system and into MySQL itself, some of the topics touched on: RAID type, disks, memory amount and speed, cpu cache, MySQL's buffers and caches, multiple I/O channels, gigabit networking, multiple network interfaces/ports and much more.
[ Covers: RAID 5 1 0, disks, memory, cpu cache, buffers cache, multiple I/O channels, gigabit, network interface, innodb, bottleneck, rpm, 512kb l2 cache, ide, scsi, serial-ata, controller, ext2, ext3, freebsd ]
|
|
|
Perl DBI Reference / Cheat-Sheet with Good Info
This is a very useful and concise page with a lot of info organized into 2 major sections, Portable DBI methods and attributes and MySQL-specific methods and attributes.
[ Covers: ]
|
|
|
How to Avoid Writing Code - Class::DBI and "Template Toolkit" Combine Naturally
(perl.com) A Sophisticated technique which will do amazing things to save headaches and time when developing complex databased web or other applications in Perl. A great practical example of how to use DBI with the simple database abstraction layer, Class::DBI. This is a common use of Template Toolkit with some classier database handling. This could be an important part of the recipe for your commercial-scale, Perl or mod_perl-driven web app.
[ Covers: dbi class::dbi template toolkit web application database application database abstraction layer DAL practical example tutorial with source code connect connection method handle ]
|
|
|
Config::General (CPAN) - Apache-Like Configuration File Parsing
(cpan.org) A smart way to configure your app. [EDITORS_NOTE: MORE -- SEE ALSO: Config::Generic, Config::ApacheFormat, Config::Objective, Config::Context::XMLSimple - CLARIFY DIFFERENCES]
[ Covers: [EDITORS_NOTE: MORE] ]
|
|
|
Life with CPAN - Power Use of CPAN - Tweaking CPAN
These notes document the setup and usage of CPAN, with attention to common tasks and pitfalls along the way. [EDITORS_NOTE: MORE]
[ Covers: [EDITORS_NOTE: MORE] ]
|
|
|
Building Good CPAN Modules
(perl.com) Write your new CPAN module so that it installs and runs everywhere you expect and want it to. Properly deal with any dependencies on Operating System or Perl version, etc. [EDITORS_NOTE - MORE]
[ Covers: [EDITORS_NOTE - MORE] ]
|
|
|
PHP Configuration Directives - Reference on 28 of the Most Important Directives from php.ini
(onlamp.com) Configuration directives from php.ini explained in detail.
[ Covers: max_execution_time error_reporting display_errors output_buffering implicit_flush safe_mode memory_limit display_errors log_errors error_log default_charset upload_max_filesize ]
|
|
|
RAID Types - Detailed Summary of the Many Types of RAID
Detailed summary of each of the many different types of RAID (Redundant Array of Independent/Inexpensive Disks). Behind a database server, fileserver, specialized web server, or other types of servers will usually be one of the many possible configurations of RAID, providing high data throughput as well as data redundancy in high performance and high availability applications. Many factors in your application determine your choice from the many options for setting up a RAID storage array. For a summary of all types, this article also goes in to substantial detail.
[ Covers: RAID 1 RAID 0 RAID 5 parity mirrored mirroring mirror stripe striping striped berkeley redundant failure LUN hot swap disk track error verify ecc I/O throughput rpm speed storage array network ]
|
|
|
Modules in Perl: Using, Writing and Improving Them
(informit.com) A discussion of Perl packages and modules. Packages allow us to place variables and subroutines in a namespace hierarchy which is part of the foundation of a module. Modules are the unit of code reuse in Perl. This article discusses how to use modules, how to write them, and how to improve them.
[ Covers: pakage module namespace reuse object oriented programming method inherit inheritance @ISA use require ]
|
|
|
Application Servers, Web Application Frameworks, and Toolkits based on mod_perl
(perl.apache.org) A list of Application Frameworks, modular code sets, toolkits and application development packages which are based on mod_perl. Examples: Embperl, Template Toolkit, CGI::Application, Apache::PageKit, Apache::ASP, AxKit, Mason and more. These tools use a variety of powerful techniques to provide the typical web application functionality and also ease development through templates, embedded code and much more. Why reinvent the wheel? A large part of your solution might be here.
[ Covers: embperl template toolkit CGI::Application Apache::PageKit Apache::ASP AxKit Mason openinteract openframe plp uttu interchange gantry databreeze bivio model view controller ]
|
|
|
DBIx::Wrapper::Config (CPAN) - Abstract DB Connection Info Into an XML Config File
This module allows you to create a configuration file in XML specifying information required to connect to databases using DBIx::Wrapper. This way you can keep your database connection specifications in one place. Each "db" element specifies a key/name for the database connection, which should be passed as the $db_key argument to connect() in order to connect to that database. The "db" element's children specify the dsn, authentication, and attribute information. [EDITORS_NOTE: REWORD]
[ Covers: [EDITORS_NOTE: MORE] ]
|
|
