 |
|
 |
|
 |
Sessions - PHP & Databases
Building a PHP/MySQL Geographical Information System
Speaker: Luke Welling (MySQL AB)
Generating maps is a cool web application with many uses.
MySQL 4.1 provides a number of geometric types and functions. Using these to do the backend work, you can build a web based GIS system fairly easily.
Our example adds shop locations to a map and directs customers to their closest locations. We use the GD extension to create output JPEGs with a zoomable scrollable interface.
Enterprise Web Applications Over Multiple Database Servers with MySQLi
Speaker: Jerome Gagner (Name Intelligence)
My talk would share strategies and code examples that are currently being used at Name Intelligence to bring our huge Whois History/Name Server History database to the fingertips of our customers.
High Availability DB Connectivity Utilizing PHP OO Abstraction Layer
Speaker: Jennifer Goodie (Schematic)
An object oriented PHP database abstraction layer combined with MySQL replication can be leveraged to provide seamless fail-over in the event of server outage minimizing downtime. This technique is also used to load balance database queries and easily perform maintenance without incurring downtime. Application development time is decreased through code portability, and enhanced debugging output.
Writing DB2 Universal Database, Cloudscape, and Derby applications
Speaker: Dan Scott (IBM Canada)
Learn how to write and deploy robust PHP applications for IBM DB2 Universal Database, IBM Cloudscape, and Apache Derby. We start by setting up connectivity between PHP and the database under Linux and Windows, then cover performance tips and tricks for advanced SQL. Along the way we highlight any limitations or restrictions in the available PHP interfaces for DB2, Cloudscape, and Derby.
