O'Reilly Open Source Convention - August 1-5, 2005 - Portland, Oregon
 Convention Coverage


Deep Dive With Apache Derby: Perl, PHP, and Python Programming
Dan Scott, Product Manager, DB2 Universal Database for Linux, IBM Canada

Track: Apache
Date: Tuesday, August 2nd, 2005
Time: 1:30pm - 5:00pm
Location: E144

When many people first learn about Apache Derby, they recognize its value as a Java embedded database but overlook its power as a networked database server. This tutorial dives deep into the Apache Derby network server to teach you everything you need to know to rapidly build database applications with Perl, PHP, and Python.

Part 1. Introducing Apache Derby

For those who are unfamiliar with Apache Derby, it is a powerful ANSI SQL relational database supporting joins, views, transactions, stored procedures, and more that just happens to be written in Java.

Learn how to set up and administer Apache Derby as a database server, create a database that exploits some of Apache Derby's functionality, and connect remotely to the database from the command line or through ODBC.

Part 2: Writing PHP applications with the PDO_ODBC extension

Learn about the PHP Data Objects (PDO) lightweight database abstraction for PHP and its implementation for Apache Derby in the PDO_ODBC driver.

Set up PHP with the PDO and the PDO_ODBC extensions and develop a complete Web application with the Apache Derby database.

Part 3: Writing Perl applications with the DBD::DB2 driver

Learn about the Perl DBI database interface and the DBD::DB2 driver that gives you access to the Apache Derby database.

Develop a complete Web application using the Perl DBI, DBD::DB2, and CGI modules with the Apache Derby database.

Part 4: Writing Python applications with the pyDB2 module

Learn about the Python DB-API 2.0 interface and the pyDB2 module that gives you access to the Apache Derby database.

Develop an end-to-end Web application using the PyDB2 and cgi modules with the Apache Derby database.

Attendees will walk away from this tutorial with sample code they can use to jump-start their next project and experience with three popular programming languages for Web applications.

Diamond Sponsors

Computer Associates International Inc., (CA)
Hewlett Packard
Sun Microsystems

Platinum Sponsors

Novell, Inc.

Gold Sponsors


Silver Sponsors

Black Duck Software
Covalent Technologies
GroundWork Open Source Solutions
Intel Corporation
Mergere, Inc.
Yahoo! Inc.
Zend Technologies, Inc.

Media Sponsors

boing boing
C/C++ Users Journal
DevtownStation News
Digital ID World
Enterprise Open Source Journal
Free Software Magazine
InsideMac Radio
Integration Developer News
Linux Journal
Open Enterprise Trends
Software Association of Oregon
Version Tracker
Wi-Fi Technology Forum
Women's Technology Cluster

In-Kind Sponsors

Dell Inc.
Griffin Technology
Harman Multimedia


OSCON 2005 Sponsor Opportunities — Email us at

Download the OSCON 05 Sponsor/Exhibitor Prospectus

OSCON 2005 Media Sponsor Opportunities — Call Margi Levin at 707-827-7184 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Conference News

Want to receive conference news? Sign up for our email newsletter.

O'Reilly Home | Privacy Policy

© 2005, O'Reilly Media, Inc.