Topic: PostgreSQL for Pythoneers
Speaker: Jason Kirtland
Date: Thursday, 5/15/08
Location: FreeGeek, 1731 SE 10th Ave

Come join us for an evening of Pythoneering with Jason Kirtland, a key
force behind the Portland Python Interest Group -
http://wiki.python.org/moin/PortlandPythonUserGroup. They are having
Lightning Talks tomorrow night at Cubespace.

Jason hasn't provided too many details at this point, but I imagine it
will be a tour of a popular Python ORM and a discussion of using it
with PostgreSQL.

"A tour of SQLAlchemy [1], an open source database toolkit and object relational mapper in Python. The tour will be SQL heavy and Python-light, and I'm planning on focusing on the object relational mapping part of the tool.

If you have a schema that you'd like to see mapped, send it my way and I'll do my best to work it in to the presentation.

[1] http://www.sqlalchemy.org/"

Also, Jason has offered to map RT - a continuation of our refactored schema meeting for RT.

Refreshments afterward at the Lucky Lab!

Dirk Jagdman will demonstrate his multi-master replication system for PostgreSQL.

Tuesday, May 13, 2008, 7:00 PM
EzRez San Francisco
50 1st Street 7th Floor
San Francisco, CA 94105

There will probably be free food (but there's a chance you'll be asked to chip in). RSVP to our Meetup page or the mailing list.

Part of Austin's Geek culture? Work for a company using an open source database? Interested in Keeping Postgres Weird?

Then join us at the first meeting of the Austin Postgres User's Group on Tuesday, May 6th at 6PM!

The rough agenda will be:
6:00 - 6:30 Meet 'n greet
6:30 - 7:15 Discuss goals for the AustinPUG
7:15 - 7:45 Presentation: What's new it 8.3?
7:45 - 8:00 Wrap-up

The meeting will be held at Sun's offices in Riata:

Sun Microsystems
Building 8 - Longhorn Conference Room
5300 Riata Park Ct
Austin, TX 78727
Map

We will have to register everyone who is attending as a visitor; to make this as efficient as possible, please RSVP to austinpug@decibel.org. Oh, and there's one more reason to register...

FREE PIZZA!

I'll be ordering from Mangia's; please let me know if you'd rather chow down on spinach, pepperoni, or Chicago style (or if you really can't eat any of the above...)

Check out Baltimore / Washington PUG. They're first meeting is on May 14th, 2008.

Subscribe to the mailing list (or the RSS feed) so that you don't miss out! Mailing list is bwpug@postgresql.org. To subscribe, send the message "subscribe bwpug" in the body of the email to majordomo@postgresql.org.

Meeting in one week!

Date: Thursday, April 17, 2008
Time: 7:00pm (that's 1900 hours.)
Place: FreeGeek

Our own David Wheeler will give a repeat performance of his talk from PostgreSQL Conference West 2007:

Ruby on Rails Essentials for PostgreSQL Enthusiasts

Has all the hype got you jazzed to develop Ruby on Rails applications on PostgreSQL? Is virtually everything you find about Rails MySQL- specific? Come to this talk to learn all you need to know to make Rails and PostgreSQL work together harmoniously. Topics will likely include:

* The ins and outs of Rails migrations
* How to add support for foreign key constraints
* Managing partial indexes and other PostgreSQL-specific objects
* Working with views
* Monkey patching for fun and profit
* Supporting multi-column primary keys
* The joys and pains of Rails collections
* Working with time zones
* The antiquity of the Ruby PostgreSQL driver (NOT)
* Enforcing constraints in Rails *and* in the database
* Getting Rails to execute *your* queries instead of its own
* Saved queries for "fat models"

---
See you there!

Hey, y'all; let's hit the ATLPUG IRC channel at 7:30 this (Tuesday, 8 April) evening to brainstorm about topics of interest to ATLPUG. Hope to see y'all there! :)

Just quickly uploading some slides from the meeting. Covered all the crazy conferences coming up soon, and included a plug for Summer of Code and PostgreSQL -- if you're a student, its $4500 for the summer and great experience! Check it out!!

Also, a few slides about USPA and what we're up to!

Check out Joshua's recap of our ice-breaker over on his blog.

Ed Sawicki gave an overview of spam supression techniques he's using and gave us a few tips on tools that were useful to him. We recommended he have a look at some CIDR address types available on pgfoundry.org to help with some performance issues he found.

TOPIC: Managing internet services: using the right tool for the job
SPEAKER: Ed Sawicki
WHEN: March 20, 2008, 7pm
WHERE: FreeGeek, 1731 SE 10th Ave, Portland, OR 97214

Also: What the heck is the United States PostgreSQL Association?, Selena Deckelmann

AND: ELEPHANT BUTTONS! courtesy of David Fetter.

Here's what Ed had to say about his presentation:

"I'll probably end up doing live benchmarks, showing code
snippets, and explaining my rationale for why I chose
to do things the way I do."

"My current projects involve managing a variety
of Internet services, such as spam suppression and the
associated per-user black/white list management, DNS record
management, PKI key management, and a variety of others. Some
of these services require that I deal with the storage and
retrieval of both discrete IP addresses and CIDR blocks in
real time.

I've had to decide on data stores that include plain text
files, SQL using SQLite and Postgres, and constant databases
using tinycdb. At every stage of development I've had to
decide which of these was best based on tools available and
performance testing. For example, Postgres has IP and CIDR
data types and adequate facilities to search for IP addresses
within a CIDR block but performance pales in comparison to
simpler tools that use plain text files. As a result, my
applications use various data stores instead of just one."

Refreshment afterward at the Lucky Lab!

Where would you like to meet? Please answer the poll at: http://pugs.postgresql.org/node/369

LewisC

Hi all,

I dropped the ball on this one. To be honest, March 11th got here much faster than I planned.

I will reschedule for a new date as soon as seems reasonable.

I'm hoping that we will get some activity on the email list. Sign up at: http://archives.postgresql.org/spug/

Let me know your preferences for location and time.

If you would like to volunteer for the the group (officers and such), please do so. Let me know if you would like to speak also.

Thanks,

LewisC