Leaving US PostgreSQL Assoc. – what’s next for me?

A smiling pug
image credit to bugbunnybambam

A few weeks ago, I decided to resign from the United States PostgreSQL Association board. Shortly after, I left for a long vacation where I thought about what I wanted to do next – both professionally and in a volunteer capacity.

Looking back, I started volunteering for PostgreSQL two years ago. I’ve led PDXPUG, staffed many conference booths, given nearly a dozen talks and run conferences. Of the work I’ve done, I’ve been most surprised by the creation of the PUGS website and all the user groups that followed.

This may sound silly – but I was so incredibly proud to see user groups in Oklahoma, Toronto, Los Angeles and the D.C.-area (BWPUG) hold meetings, share their experiences and publish fantastic presentation slideshows. All while I was out of the country!

That’s a true sign of success to me: groups of people leading themselves and sharing their knowledge with each other. It’s open community, with minimal bureaucracy, and (I hope) maximum fun.

With that in mind, I’ve decided to make this next year’s volunteer work focused on a simple idea:

Enable people to connect and learn directly from each other.

So what you can expect from me over the next year is more of the same, but now with that end goal in mind: more PostgreSQL user groups (for as long as the postgresql.org folks would like me to stay), more ways to connect people directly to each other, more authentic community building through un-conferences, and more contributions – through code, testing and presenting of that work.

To give you an idea — here’s what I’m up to over the next couple of months:

  • Linux Plumber’s Conference, September 17-19 – with Gabrielle Roth, we’ll be presenting information about databases (PostgreSQL specifically) and filesystem performance using data gathered from the recently installed PostgreSQL performance lab.
  • PostgreSQL Conference West, October 10-12 – I’m not organizing this year, but I’m organizing a session on hacking PostgreSQL, led by some PostgreSQL hackers!
  • WhereCampPDX, October 17-19 – I’m helping organize this un-conference for geography-specific tech – practicioners, professionals, enthusiasts, artists! We’ve got some great ideas and hope to publish details in the next week about the awesome folks involved, the venue and the parties!

Hope to see you at these events!

I haven’t talked about my work much in this blog, and probably will continue not to do that much here – but I also wanted to share that I’ve taken a position with End Point Corporation, a fantastic company that works on open source software, and provides support for PostgreSQL. I’ll be focusing on PostgreSQL, and doing a little Perl development here and there.

PDXPUG Day on July 20 – Register now!

pgday 2007

photo courtesy of Dan Browning

Registration for PDXPUG Day on July 20, 2008 is open! Please sign up and let us know what size t-shirt you’d like. We’re requesting a $20 donation (by cash or check) at the door. All proceeds to to Software in the Public Interest, a 501(c)3 organization that is used to fund PostgreSQL advocacy.

Registration for OSCON is not required to attend.

Registering also gets you in the door at the Gotham Tavern, our after-party location close to the convention center!

Our line-up of talks includes:

PostgreSQL Unit Testing with pgTAP – David Wheeler
Inside the PostgreSQL Shared Buffer Cache – Greg Smith
Muldis D – Portable Databases At Full Power – Darren Duncan
A Streaming Database Talk – Rafael J. Fernández-Moctezuma
Using GLORP to connect Squeak Smalltalk to PostgreSQL – RandalSchwartz
Fighting Disease with PostgreSQL Full Text Search and JRuby on Rails – Mike Herrick
All Your GIS Are Belong to You – Abe Gillespie
What’s PgUS – Joshua Drake

Sign up today!

Drupal + PostgreSQL: review some patches, folks!

baseball bat
am i the girl, the bat or the heart? you decide!

I’ve been working on a site that uses Drupal for a few months now. And I’m living dangerously with CCK, Views and, as of last week, Organic Groups.

I found this sharp moderation module (Modr8) last week, and then quickly realized that I wanted to be able to provide this moderation tool any conferences that wanted it! Enter the Organic Groups.

I’m using PostgreSQL for the back-end database, and so I’m used to being a second-class database citizen in Druplandia. This means that I frequently have to patch modules so that they use SEQUENCE instead of AUTO_INCREMENT, or get rid of the (8) after an INT type. So, when Organic Groups and the og_modr8 modules caused this bug to rear up, and I suddenly had a full-scale “blogs running backwards” problem on my hands, I wasn’t surprised.

Thank goodness for Brenda Wallace’s patch, which fixed everything up a short while later. What got me, however, was that the problem has had a fix (although not Brenda’s ultimate patch) for over a year, but it hasn’t been added to core. Particularly when the problem causes nodes to be presented out of order, site-wide.

Apparently there’s a shortage of PostgreSQL reviewers in the Drupal community.

Fortunately, if you’d like to help get patches applied to core, there’s a page of Patches To Be Reviewed, and a few people are trying to add a postgresql tag to bugs. If you’re a Drupaler and use PostgreSQL, please take a few minutes to review a patch.

Call for proposals for PDXPUG PgDay, due June 20, 2008

pgday 2007
(Photo from PgDay 2007)

Please submit a talk! The call will be open for 2 weeks and proposals are due June 20th. Follow the link for details on submitting.

http://pugs.postgresql.org/node/400

PDXPUG PgDay will be on July 20, 2008. This is a one-day conference happening the day before OSCON at the Oregon Convention Center.

We are inviting anyone who has something interesting to share about PostgreSQL to send us a proposal!

We’d like to have at least one 1.5 hour tutorial and up to five 45-minute talks.

We welcome talks in any of the following areas:

* Case studies involving interesting and innovative uses of PostgreSQL from an application developer, PostgreSQL developer or administrative user perspective
* Converting from other databases to PostgreSQL
* Howtos for database administration tasks (partitioning, backups, replication, writing stored procedures)
* Practical advice on configuration, monitoring and database management

PgCon 2008 – big announcements, community conversations

PgCon was a very exciting conference, with a lot of people from Europe, Asia, Australia and South America traveling to be part of it. I read that 175 people attended, and based on how crowded both parties were, it’s not hard to believe!

The biggest announcement for me was that the PostgreSQL Europe is finally a non-profit organization! I made a slide for my lightning talk with Magnus, Gabriele, Jean-Paul and Andreas on it:

PgEU announced

I got a ton of great feedback about the User Groupalooza slides. I also enjoyed meeting Jean-Paul Argudo, a fellow Drupaler.

There were a bunch of community-focused conversations, some focused inward on developers, some looking out to the rest of the world from inside Pg, and others from the outside looking in:

All the talks were recorded, so I look forward to listening to them again – without the distraction of Twitter! 🙂

A couple talks I thought were really great for web developers were:

  • Magnus Hagander’s search.postgresql.org talk gave some great examples and code showing how to use PostgreSQL’s tsearch capabilities with a PHP-based website.
  • Clark Evan’s talk on HTSQL, a REST-ful web inteface application. It looks pretty cool and I’m interested in trying it out. They are using it for medical records report generation and have even given the ability to generate queries to the end users.

Thanks so much to Dan who got me to the conference this year! I learned a lot, and really enjoyed meeting so many people that I’ve only communicated with over email for the past three years.

PgCon Lightning talk: User Groupalooza

I gave a Lightning talk today about PostgreSQL User Groups. I wasn’t able to get through ALL my slides – but I only had to rush through the last three. (click on the cat below to download – 5MB)

splash for user group talk

Lightning talks are some of my favorite sessions. I got to announce the incorporation of PostgreSQL-EU! We had a talk about DBIx::Cache (which you should all check out!), a cool open source lab in Japan that Hiroshi Saito works for (only for Japanese, but very cool), Gavin Roy talked about Staplr and a new benchmarking tool called Playr that was just released on Thursday, and six more talks! We hope to publish the rest of the slides shortly.

At PgCon in Ottawa, Day 1

Oops, this got published early. I’ll be updating this shortly.. probably over lunch.

Magnus posted some photos already!

Summary of last night:

We had a great time last night at the pub for registration, and then over to the Yahoo! party. We had fun talking databases, beer, and the difficulty in trying to understand Australian accents. I learned from Tom (not Tom Lane) that Adelaide, Australia has a fantastic wine-growing region. Alvarro once again recommended that Jeff commit his time interval data type. I think Jeff was convinced to do this for 8.4. Now I have to update the documentation!

PgCon in Ottawa – following people on twitter

I’m in Ottawa at PgCon and listening to Bruce Momjian give the keynote.

We have a few people who’ve joined Twitter in the last couple months and are posting their thoughts through the conference. Try following @crad, @fuzzychef, @franciscojunior and @selenamarie (me) for our up-to-the-minute updates!

I’ll be giving a lightning talk this afternoon around 5:30pm about user groups and PostgreSQL.

Bar Camp Portland: what a weekend!

I’m inspired.

I’m still buzzing from BarCampPortland. I loved every minute of it, and managed to learn a ton from all the amazing people in Portland. I met a ton of new people, and started several more projects 🙂

Over the course of two days, I ran two sessions. The first was about PostgreSQL:

We had a fantastic discussion, totally filled the room up with people curious about what PostgreSQL can do. We had several requests for MySQL -> PostgreSQL “rosetta stone” documentation.

The second session was How to raise or eat chickens sustainably:

We had an incredible conversation – ranging from getting and raising chickens for the first time, to digging up your lawn and planting food, to gentrification, to obsessive local eating.

I also attended these others: DSLR, Bikes and Geeks Collide, Project Management, My Other Thing, Women in Tech, and a session at WordCamp.

I think it’s finally time to go to sleep. Check out a ton of pictures. Thanks so much everyone who attended, led sessions and volunteered this weekend!