Topic for Consideration:
This February, LAPUG will be having a "Birds of a Feather" (BOF) meeting at this year's Southern California Linux Exposition (SCALE). The PostgreSQL Users Group Liaison Selena Deckelmann and the PostgreSQL Core Developer Josh Berkus will be presenting a "Tag-Team" presentation regarding some of PostgreSQL's new features released in version 8.4 as well as other key feature from previous versions.

Time:
February 21, 7-8 pm (Saturday Evening)

Location: Vote for your favorite meeting Location
Los Angeles Airport Westin
5400 West Century Boulevard
Los Angeles, California 90045
Phone: (310) 216-5858
Fax: (310) 417-4545

Map:
Map to Airport Westin

January's LAPUG Recap:{See Attachments Below}
Richard Broersma presented a topic on Tree models in SQL. He mentioned how Trees are a specialized form of graph. It seems that there are three ways to model trees and that PostgreSQL V8.4 will greatly simplify the use of one of these models.

Juan Natera presented the Perl ORM module 'ROSE'. It was very interesting to see how ROSE's ORM framework simplifies the task of handling the ties between application logic and Database persistence. This was a very popular talk as seen from the lively Q&A session that ensued.

Konstantin Antselovich presented the a Data Model to handle the common functionality of a message board system or mailbox. The discussion that followed was a consideration of the features gained by using an SQL back-end versus a file system back-end.

Brian Dolan was the concluding speaker. He presented a fascination discussion that gave an insight into how advanced analytic mathematics can be use to greatly reduce the CPU and Filesystem load on the Database Server(s). To summarize what Brian presented, Likelihood mathematics were used to aggregate many-many-many... billions of rows of data into a materialized view with a row count in the hundreds of thousands that could be SELECT-ed with ordinary SQL to produce insightful yet performant results. (I have to say that this was an awesome topic!)

I hope to see everyone at the next LAPUG meeting!

[About LAPUG] [Join the Mailing List] [View List Archive]