PostgreSQL Community Day Schedule

Tuesday, August 5th

Please register with LinuxWorldExpo

The PostgreSQL Community Day is sponsored by CommandPrompt and EnterpriseDB.

Sessions

PostgreSQL's Future original PostgreSQL Core Team member and EnterpriseDB chief architect Bruce Momijian talks about where PostgreSQL has been over its 12-year history as an open source project, and where he thinks the project is going in the future.

The Business Case for PostgreSQL Commercial adoption and deployment of PostgreSQL is accelerating. Jim Mlodgenski, vice president of technical services for EnterpriseDB, explores the business reasons behind this increasing popularity, and makes the case that this adoption will accelerate even further, as it addresses the growing gap between expensive, proprietary databases and free, lighter-weight products. Among PostgreSQL's advantages are the favorable BSD license, the community commitment to quality, user influenced features, and increasing commercial support.

Up and Running With PostgreSQL in 30 Minutes Because it is so powerful and comes with 2000 pages of documentation, PostgreSQL has the undeserved reputation of being complex, obscure, and difficult to install. Long-time contributor David Fetter and Core Team member Josh Berkus will show you how easy it is to be up, running, and developing with PostgreSQL ... in less than 30 minutes.

PostgreSQL, Extensible to the Nth Degree: Functions, Languages, Types, Rules, Performance, and More! PostgreSQL hacker and Truviso senior engineer Jeff Davis will show how the extensible pieces of PostgreSQL fit together to give you the full power of native functionality -- including performance. These pieces, when combined, make PostgreSQL able to do almost anything you can imagine. A variety add-ons have been very successful in PostgreSQL merely by using this extensibility. Examples in this talk will range from PostGIS (a GIS extension for PostgreSQL) to DBI-Link (manage any data source accessible via perl DBI).

Lightning Talks Six hackers, application developers, driver maintainers, PostgreSQL extension creators and more will talk for 5 minutes each about their projects and products. Learn about the great variety of things people are doing with this advanced database system, including Unicluster, building javadocs with PostgreSQL, database security, and more.

High Availability PostgreSQL using UCARP, DRBD, and Warm Standby Having trouble crafting a high-availability solution without excessive performace costs? Then this is the solution for you. In this session we will discuss and implement the Userland Implementation of the Common Address Redundancy Protocol (UCARP) along with PostgreSQL's "warm standby" feature and Distributed Replicated Block Devices (DRBD) to provide rapid recovery from database failures while still retaining the ACID "durability" constraint.

Using PostGIS to add some spatial flavor to your applications With the advent of neogeography everyone wants to do something spatial with their applications. In this session, Steve Citron-Pousty, Developer Evangelist for deCarta, will give an introduction to PostGIS (a spatial extension for PostreSQL) and then show you how to get some cool mapping magic going. We make sure your PostGIS install is working, download some data from the internet, load it into PostGIS, and then start asking some interesting spatial questions of the data. We will look at queries calculate distance and area, calculate centroids, test distance or containment, and we will clip features to a bounding box. Demos and code will be shown for using these functions in desktop applications and in custom applications.

Using Python with PostgreSQL Python hacker John Zarella tells you how Python and PostgreSQL make an unbeatable combination of processing power and persistent data storage. The Python language provides superior expressive power for solving problems in very diverse fields -- from web services to numerical analysis. PostgreSQL supplies a high-integrity, reliable database that ensures continuous availability of the information you need to solve those problems.

PostgreSQL Party After the pgDay, join us at a bar and grill near Moscone Center to play pool against other PostgreSQL geeks! Pick up your invitation at the pgDay; attendence is limited. Finger food and beer provided by our party sponsors: Truviso, CommandPrompt, EnterpriseDB, iParadigms, Open Technology Group, and xTuple.