twittering on 2009-09-22

  • RT @magnushagander: Thank you #postgres for letting me do a 6-level nested subselect in a DELETE, and actually producing the correct result! #
  • @hal_pomeranz there was none, sadly, as I was unable to participate. we'll just have to do it again! #
  • @sycobuny it will if the FK is part of a PK or a UNIQUE constraint. but I am not familiar with all the reasoning behind that. #
  • @adamd also vanilla milkshakes from mcdonalds. no joke. #

twittering on 2009-09-22

twittering on 2009-09-22

Weekly tweet digest for 2009-09-20

  • @PeteForsyth there is something settling about it.as in: "you've had your fun, now it's time to settle in for some work." i <3 season change #
  • @PeteForsyth I like'em too. now if @nedspace would just get some lockers for my cycling clothes… #
  • of course, in pdx RT @BikePortland: New blog post: Naked bikers needed for Flaming Lips music video set in Portland http://bit.ly/3gkWIB #
  • RT @WhereCampPDX: RT @GEOpdx: James Fee on WhereCampPDX http://trunc.it/1z98i @wherecamppdx @cageyjames #wherecamppdx #
  • RT @planetpostgres: Greg Sabino Mullane (@turnstep): Migrating Postgres with Bucardo 4 http://tr.im/yUTJ #
  • creating a private mailing list to deal with a controversial issue, and then creating a new, public one on the same topic can work. #
  • lets people blow off steam, get to know each other, and then they can work together in public. #
  • .@edavis10 yes. & a semi-public forum, shielded from google & w/a low barrier to entry keeps convo civil, but not constrained #
  • Have a backlog of thanks for @WhereCampPDX sponsors — but thank you @TriMet for a big sponsorship today! #
  • @rikkikite glad you're swinging through our neck of the woods! :) #
  • congrats! :) RT @robertmhaas: #postgresql supports join removal !!!! http://bit.ly/l2uvA #
  • @cheekdotcom if you can come up with a better acronym… :) #
  • RT @planetubuntu: Martin Pitt: PostgreSQL security/bug fix update, please test:PostgreSQL new point release.. http://bit.ly/54xyj #
  • happy birthday, tom lane! #postgres #
  • @Theory awesome! thanks for reviewing. #
  • yeah! patches! parties! awesome! RT @planetpostgres: Selena Deckelmann (@selenamarie): User Group Idea: Patch Review Party http://tr.im/z4F6 #
  • and we have cornbread thanks to @gorthx! #
  • @Mettadore sweet :) #
  • RT @ccambien: Postgresql fans : PGDay europe in Paris this year! 6-7 Nov. http://2009.pgday.eu/ #yam #
  • .@karolcooks so happy you're running! http://bit.ly/14Sr65 #
  • it really is the end of the day. :) #
  • figured out how to file a "found cat" report with multnomah county. making fliers in the morning. #
  • @StevenWalling I loved that movie! #
  • @thesethings i am considering the template from the county. but we could go full-bleed photo, font: Agit prop? #
  • @StevenWalling you're never going to trust my taste in movies again. #
  • RT @planetpostgres: Hubert Lubaczewski (@depesz_com): Speeding up dump/restore process http://tr.im/z95p #
  • @GEOpdx saw a couple last year. we could put out a call to the local drupalistas (@xolotl, @thirdworld for starters) #
  • looking forward to making pumpkin pie from the pumpkins baking in the oven right now. #
  • . @thesethings he said "for the win, etc." (para-tweet @stephenfry just left vid msg saying "wish i was there." http://tinyurl.com/nbrc6g) #

twittering on 2009-09-19

twittering on 2009-09-18

  • happy birthday, tom lane! #postgres #
  • @Theory awesome! thanks for reviewing. #
  • yeah! patches! parties! awesome! RT @planetpostgres: Selena Deckelmann (@selenamarie): User Group Idea: Patch Review Party http://tr.im/z4F6 #
  • and we have cornbread thanks to @gorthx! #
  • @Mettadore sweet :) #
  • RT @ccambien: Postgresql fans : PGDay europe in Paris this year! 6-7 Nov. http://2009.pgday.eu/ #yam #
  • .@karolcooks so happy you're running! http://bit.ly/14Sr65 #
  • it really is the end of the day. :) #
  • figured out how to file a "found cat" report with multnomah county. making fliers in the morning. #
  • @StevenWalling I loved that movie! #
  • @thesethings i am considering the template from the county. but we could go full-bleed photo, font: Agit prop? #
  • @StevenWalling you're never going to trust my taste in movies again. #

User Group Idea: Patch Review Party

On Tuesday, I invited a group of people from PDXPUG over to my house for chili, beer and patch review. PostgreSQL has what we’re calling a ‘commitfest‘ every two months where we buckle down and try to review and commit (or reject) the patches submitted over the last few weeks. Webb and Gabrielle had the original idea to get everyone together for a review party, and they did a fantastic job recruiting people to join in.

Gabrielle gave the details and lessons learned on our PUG site already, so I won’t repeat that.

One thing that occurred to me as we were doing this work was how affirming and *fun* it is to work on patch review with people in person. Several people commented on how they enjoyed doing this work in the company of others, and how the tedious issues around compiling, applying patches and going through all the questions were made so much more enjoyable with a group of good-natured hackers sitting around answering questions.

The atmosphere wasn’t pressured – I gave a little background about commitfest, how it’s been run in the past and what the development group is trying to change about it (mainly, bring in more people, and make patch review faster for people who submit patches, and smoother for the committers). Then we just got down to work in pairs or groups of three.

Working in pairs is a really good idea for this type of event. I certainly learned a few things from John, and over email and in-person again, we were able to wrap our review up a couple days later after the regular user group meeting. Having another person to bounce questions off of was invaluable for the patch that we reviewed, and it was just fun brainstorming variable names, piecing together a test case and then finding a solution to a problem we found.

Another thing that happened was that I had lots of time to chat with people I hadn’t talked with before about projects they’re working on (a really exciting materialized view implementation, and a massive cleanup of our *.bki infrastructure — two very ambitious projects!). Both people are now signed up to give talks at our local user group about their work.

I’ve talked a little bit about the social benefits of commitfest on various mailing lists, and I think the opportunity for user groups to get together and review patches as a team is a great one. I’ll be gathering up some of my other observations about PostgreSQL community and posting those over the next few weeks.

I’ve got a talk about user groups to prepare for (JPUG’s 10th anniversary in November!), so now is the perfect time for me to be gathering my experiences and thoughts from the last three years.