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.