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.

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.

PostgreSQL Conference East – this Saturday and Sunday

We’re wrapping up all the little details for the conference:

  • Wireless access is secured! Each person will have their own account. You’ll receive it when you register.
  • Our final schedule is available!
  • The last few talks have been rolling in. I’m very excited about the round table Sunday morning with Joshua Drake (USPA and PostgreSQL SPI Liaison), Bruce Momjian (PostgreSQL Core) and Magnus Hagander (PostgreSQL-EU). Bring some questions! We’ll be on IRC taking remote questions as well.
  • I’ll be giving a talk on ptop Sunday too!
  • Also very excited to get together with other Women In Open Source!

We’re all getting together at the Greenbelt Chevy’s on Friday night. Let me know if you’d like to join. I’ve made a reservation for 20.

extreme database makeover: RT meeting recap

[Update: David Wheeler provided the SQL that came out of this meeting.]

Extreme Database Makeover: The crowd

Last night, PDXPUG and Code-n-Splode got together to refactor the database for RT. David Wheeler, Jeff Davis and Mark Wong led the discussion.

Through the course of the meeting, the group chose to pick out a few key features that would be better served if the database schema was more normalized, and offered a few new constraints we thought would help manage the data. Toward the end of the meeting, Igal suggested having a Perl workshop to refactor the code related to one or more of the database changes. The idea here was to be helpful, rather than just poking holes in the schema.

David started the discussion off with an introduction to RT. RT was created about 10 years ago by Jesse Vincent of Best Practical, and the database schema has been augmented over the years to accommodate new functionality. They support both MySQL and PostgreSQL as backends, and tend to dislike using database-specific technology.

Continue reading

LAPUG Launch!


Saturday night, February 9, at 8pm, Richard Broersma and a crew of 15 launched LAPUG. Noel Proffitt, from the City of Garden Grove, gave a great talk on time-oriented (or temporal) database design.

He presented an example of a set of columns, rules and triggers for tracking both valid and transaction time. Noel also was kind enough to give a plug to the temporal data type that Jeff Davis and I presented last PGDay before OSCON. There was some suggestion that Jeff should submit the code for version 8.4.

We also showed off the new PUGs website, and talked a little about what had brought people to the BoF.

A few students from Cal Poly were there, along with many experienced administrators from around LA. Richard mentioned that his company was willing to host the group’s first meeting, and Noel offered to bring a projector. The group also asked about potential topics, so I am going to start a talks repository on the PUGs site. Ultimately, I’d love to have the authoritative and searchable repository of PostgreSQL talks for all PUGs to use as starting points and references.

Thanks go to Robert Broersma for taking the initiative and announcing the meeting, and Joshua Drake for scheduling the BoF. Also, it was a pleasure to spend the weekend with Joshua, Robert, David Fetter and Josh Berkus in the SCaLE PostgreSQL booth.

I’m looking forward to great meetings from LAPUG in the future!

legion of tech

I recently joined the board of a tech non-profit called Legion of Tech. Our goals are:

  • Grow and nurture the local Portland technology community through educational, not-for-profit, community-run events.
  • Make it easier for community members to organize technology events.
  • Provide resources and assistance for technology community events.

Dawn also just wrote about it. We had a great first board meeting, full of interesting ideas and energetic people.

A few of us at the board meeting talked about event calendaring and keeping in touch with all the user groups in the greater Portland area. Members of the Perl community recently volunteered some time to write some code in support of a better calendaring system. We currently have at least two Google calendars, a PBwiki, dozens of mailing lists and many individual blogs.

Have ideas for how we could all work together and make a better system? Raven suggested the hCal microformat for announcing meetings, I thought it would be cool to have a Planet Portland and someone else mentioned Drupal. What do you think?

december coder’s bash – thanks, sam

I made it out for the last hour or so of the December Coder’s Bash last night. The first thing I noticed was how many people were there! At least 50 were still hanging out at 9:15pm on a Tuesday night.

They were chatting and playing games — Settlers of Catan, some kind of card game, something involving bean bags. And, of course, there was programming shop-talk. I got to talk about embedded systems with Matt, tried to beg some help with a Drupal installation from part of the PostgreSQL crew, and started to decompress a little from the ERP migration I just completed on Monday.

And there were a ton of women! My unofficial assessment was that about 15% of the group were women.

Portland is so awesome.

I want to thank Sam Keen for putting this together. I know that a lot of other people were involved, but he was the guy sending out the email, contacting us user group leaders and getting sponsorships. Sam, you really did a great job.

women’s sized t-shirts for postgresql

I have been looking into getting some woman-sized PostgreSQL shirts, in addition to the more typical men-sized tshirts. The particular style is American Apparel shirts, style # 2102. The shirt says ‘PostgreSQL’ in small print on the front, and has the big elephant logo on the back. We’ll most likely ask for a $20 donation to the PostgreSQL non-profit for each shirt.

So, I’m conducting a small poll:

If you are interested in a woman-sized shirt, please email or comment on this thread with a quantity, and size (XS, S, M, L, XL). If you would not wear a PostgreSQL woman-sized shirt yourself, please consider whether you would maybe get one as a gift for someone else this holiday season 🙂

I would be overjoyed to have my mailbox clogged with requests, so please don’t be shy!

I’m just trying to get a feel for the numbers, so your comment won’t be considered an order. Also, please forward this to anyone you think might be interested.