lapug's blog
SCALE 8X - Bird Of A Feather
Josh Berkus will deliver a presentation on PostgreSQL Version 9.0 during the Birds of a Feather” session at SCALE.
This is an excellent opportunity to learn about the exciting new features that are included in this new release and to meet other PostgreSQL users local to the Los Angeles area.
EVENT: 2010 SCALE 8X
LOCATION: Westin Hotel
Room: La Guardia
Time: 7:00 pm, Saturday February 20th
Inquiries for additional information can be sent to lapug@postgresql.org.
- 455 reads
LAPUG January Meeting
Topic for Consideration:
Alan Gruskoff will present the use of Adobe Flex/ PHP-AMF using PostgreSQL.
Time:
January 27, 7:30-9:00 pm (Wednesday Evening)
Location: Vote for your favorite meeting Location
Caltech
Steele 214 in Caltech.
370 South Holliston Avenue,
Pasadena, CA 91106
Map:
Map to Caltech
Campus Map
- 546 reads
October LAPUG Meeting
Topic for Consideration:
Jim Mlodgenski from EnterpriseDB will present "Architecting Your PostgreSQL Application for the Cloud."
Abstract:
The cloud is a powerful environment for deploying applications, but like any type of infrastructure, it has strengths and weaknesses. This session will discuss how to leverage those strengths and mitigate the weaknesses on the data tier of your application. This architectural discussion will focus not only on performance and scalability, but also on security and management within a cloud environment.
Time:
October 19, 7:30-9:00 pm (Monday Evening)
Location: Vote for your favorite meeting Location
Caltech
Steele 214 in Caltech.
370 South Holliston Avenue,
Pasadena, CA 91106
Map:
Map to Caltech
Campus Map
- 1068 reads
LAPUG May Meeting
strong>Topic for Consideration:
For the May's Meeting will be hosting Joshua Drake who is the president of the United States PostgreSQL Association (PgUS). He'll spend some time discussing what PgUS is and what to expect from it. After this Joshua will take any manner of PostgreSQL related questions regarding development, administration, and performance tuning.
Time:
May 27, 8:00-9:00 pm (Wednesday Evening)
Location: Vote for your favorite meeting Location
Caltech
Steele 214 in Caltech.
370 South Holliston Avenue,
Pasadena, CA 91106
Map:
Map to Caltech
Campus Map
April's LAPUG Recap:
Moo presented a discussion on CouchDB and Erlang, and raised the issue of problem domains that benefit from non traditional databases required extremely hi concurrency and fault tolerance.
I hope to see everyone at the next LAPUG meeting!
- 1393 reads
LAPUG March Meeting
Topic for Consideration:
For the March Meeting, Moo Moragraan is presenting the topic of Erlang and CouchDB. Erlang is a functional programming language emphasized on concurrency in a distributed system, fault tolerance, and constant availability. These are all ideal for where databases are going. He will demonstrate a little bit on the language's power and then will look into an application of the language in the database world using CouchDB.
Time:
March 25, 7:30-8:30 pm (Wednesday Evening)
Location: Vote for your favorite meeting Location
The City of Garden Grove
City Building (Look for the entrance labeled "Housing Authority")
11277 Garden Grove Blvd
Garden Grove, CA 92840
Map:
Google Map
February's LAPUG Recap:
Selena Deckelmann and Josh Berkus presented many new features that will be introduced in version 8.4. Selena started with a round-table introduction, which was a nice start since many of the persons that attended the BOF were first time attenders. Josh elaborated on many of the features that will standout for PostgreSQL users upgrading to 8.4. Afterwards, we finished up with dinner and drinks at the LAPUG social.
On a side note, I wanted to mention the altruism shown by both Selena and Josh. Selena and Josh (as well as many others in the PostgreSQL community) have a long standing track record of supporting the PostgreSQL project and community as was apparent at this year's SCALE. Its important to remember that the support these individuals offer is possible because of the personal sacrifices they make in their time, money, and energy. Its interesting to see the increase in the number of people using PostgreSQL in comparison to the previous SCALES. This shows that the hard work of persons like Josh and Selena is paying off.
Also, in addition to Josh and Selena I wanted to mention the other volunteers that helped out at the PostgreSQL booth. They were Christopher Nielson, Erez Ascher, John Zarrella, Noel Proffitt, and Moo Moragraan.
I hope to see everyone at the next LAPUG meeting!
- 1157 reads
LAPUG - PreSCALE Pizza Party
Folder Stuffing Pizza Party:
This Friday (Feb 20, 2009), PostgreSQL.org will host a "Folder stuffing" pizza party on Friday evening of the SCALE convention. In addition to enjoying free pizza we will be "stuffing" PG folders with community literature. We highly encourage all to attend. If you are able to attend the pizza party please RSVP with an email to lapug@postgresql.org.
Time:
February 20, 7-10 pm (Friday Evening)
Location:
Rhythm & Hues
5404 Jandy Place
Los Angeles, CA, 90066
Map:
Rhythm & Hues
Parking Instructions:
We have two lots on either side of the building, I will see about getting the gate left open past 6pm, so people can drive in. Also, there should be plenty of on-street parking on Beatrice, a brisk 1 min. walk from the entrance.
I hope to see everyone at the Pre-SCALE Pizza Party!
- 1026 reads
LAPUG - February at SCALE
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
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!
- 919 reads
LAPUG - January's Lightning Talks
Topic for Consideration:
January's LAPUG meeting will be held at the Fox Media Building in the City of Santa Monica. This month we are planning a round of lightning talks and are looking for speakers to talk about anything that's RDBMS related for about 5 to 10 minutes. We already have some speakers scheduled, so take this opportunity to to sign-up and tell us about what interests you!
I wanted to thank everyone that has offer to present at January's meeting. The following is a list of speakers and topics:
Konstantin Antselovich
- Modelling Message Boards and Mailboxes in SQL
Richard Broersma
- Modelling Trees in SQL
Brian Dolan
- Likelihood Models in the Data Warehouse
Juan Jose Natera
- ORM with Rose::DB::Object
Time:
January 21, 7:30 pm (Wednesday Evening)
Location: Vote for your favorite meeting Location
Fox Media Building.
2500 Broadway,
Santa Monica, CA 90404
Map:
Map to Fox Media
Instructions:
Fox Interactive Media is located on the second floor of 2500 Broadway, Santa Monica, CA 90404. Fox shares a complex with Yahoo and are in the exact same building as HBO. Fox is along the Broadway edge, closest to the tennis courts. If entering from the street (where you should be able to find plenty of parking) you want to head toward the north-east most building near the tennis courts.
After 7pm, the elevator requires a pass. Noelle Sio and David Hubbard from Fox Interactive will be helping us get people up and down. We'll be in or near the meeting room from 6pm onwards. The actual meeting room is directly above the lobby. We can easily see you if you stand outside and wave. Once we stop laughing at your unfortunate fate, we'll come down and let you in.
You should park on the street. The pay lot closes at 7 and I haven't set up validations. See you there!
Taking a head count:
Feel free to invite anyone that may be interested in coming to a PUG meeting. For those that are planning to attend please send an email to the LAPUG mailing list. (If food can be provided, it will help to know how much to bring.)
November's LAPUG Recap:
Paul Salazar presented a discussion on Greenplum; what features it has and how it compares to its competitors. In addition to this, the presentation touched lightly on some concepts of data warehousing. He gave away some nice swag (including an IPod) at the end which was very nice of him!
I hope to see everyone at the next LAPUG meeting!
- 1223 reads
LAPUG hosting Greenplum
Topic for Consideration:
November's LAPUG meeting will be held at Caltech in the City of Pasadena. Paul Salazar the VP of Corporate Marketing at Greenplum Inc. will be delivering a presentation on the basics of Data Warehousing, On-Line Analytic Processing (OLAP) and how the Greenplum Database server supports these application domains.
Paul would like additional feedback on points for discussion. So if anyone would like specific features addressed in the meeting regarding Data Warehousing, OLAP, or Greenplum, please email these points to the LAPUG mailing list or post a comment to this blog.
Time:
November 19, 7:00 pm (Wednesday Evening)
Location: Vote for your favorite meeting Location
Steele 214 in Caltech.
370 South Holliston Avenue,
Pasadena, CA 91106
Map:
Map to Caltech
Campus Map
Taking a head count:
Feel free to invite anyone that may be interested in coming to a PUG meeting. For those that are planning to attend please send an email to the LAPUG mailing list. (If food can be provided, it will help to know how much to bring.)
September's LAPUG Recap:
Michael Chen delivered an excellent presentation for the basics of implementing Slony. Michael pointed out that while Slony is a very powerful replication strategy, it also has a steep learning curve. One of the first recommendations was not to follow the slony tutorial in its recommended setup. It seems that the tutorial demonstrates replication between two PostgreSQL instances running on the same server. While this eases the learning curve by focusing only on learning the Slony interface, it shields the user from pitfalls that will be encountered when configuring two separate servers to communicate successfully with one another. Another point made was need for the user to develop his or her own api layer on top of SLONY that simplifies many low level tasks that Slony exposes. The api layer will be dependent upon the replication topology that is designed by the user,
On a side note, I have to mention that I am continually impressed by the immense skill, knowledge, talent, and intelligence that seem to be common with the PostgreSQL users that find their way to various LAPUG meetings. Maybe every users group leader feelings this way, but I can't help but feel that there must be something special about PostgreSQL that attracts people of this caliber. It reminds me of a movie I once saw with the line: "If you build it. They will come!" :)
Anyway I hope to see everyone at the next LAPUG meeting!
For further information see the attached presentation. {Hold For Presentation}
- 1176 reads
LAPUG - September Meeting
***********************
** Attention All LAPUGers **
***********************
Vote for your favorite meeting nights.
Vote for your least favorite meeting nights.
Topic for Consideration:
September's LAPUG meeting will be held in the City of Irwindale. Michael J. Chen will be delivering a presentation on using and configuring SLONY as a means of replicating PostgreSQL.
Time:
September 26, 7:00 pm
Location: Vote for your favorite meeting Location
5288 Rivergrade Rd.
Irwindale, CA 91706
Map:
Map to Irwindale
Taking a head count:
Feel free to invite anyone that may be interested in coming to a PUG meeting. For those that are planning to attend please send an email to the LAPUG mailing list. (If food can be provided, it will help to know how much to bring.)
August's LAPUG Recap:
Geoff Kloess delivered an interesting presentation of Ruby on Rails (RoR). After explaining the syntax semantics of Ruby, Geoff illustrated the Object Relational Mapping that the RoR framework uses and how it is implemented in both the PostgreSQL schema design and RoR class design. Lastly, we watched as Geoff built a simple yet functional website in just a matter of a few of minutes.
For further information see the attached presentation.
- 1152 reads
