twittering on 2008-02-29

  • going through my bikesnobnyc backlog. #
  • finally, mysql people admitting what we already know: http://tinyurl.com/2wbqh3 #
  • twitter-withdrawal shakes subsiding. #
  • @snitter please drop the filtering #
  • formatting strings in C is a PITA #
  • @garethgreenaway postgresql will be there! #
  • watching ptop stats roll by #
  • first commitfest for postgresql 8.4 begins tomorrow – http://snurl.com/20oxp #
  • @br3nda: lol we’re always a day behind in US #
  • @br3nda *sigh* yes. there’s some talk of moving things over to git — see http://git.postgresql.org #
  • we’re probably going to move ptop over to git for the next release #
  • giving up on writing the PROCARGS code today. off to dinner, then karaoke! #

twittering on 2008-02-28

  • @verso please make it so that i can send bacon updates via twitter. #
  • hi @aurynn. yay! more postgresql goodness. see @br3nda, @mjollnir, @cbbrowne. others? #
  • headed home.. #
  • @theory i’m "following"… ok, maybe the joke’s not … "funny" anymore. #
  • :D thanks, @theory. milkshake now up nose. #
  • @linuxpoet pong. #
  • in case you’ll be in the UK April 2 for another postgresql conference: http://www.postgresql.org.uk/ #
  • trying to remember how to program the phone system. grr. #
  • @garethgreenaway i WISH. typing commands into a phone keypad is so 1980s. #
  • @notbenh you never called for coffee! :) #
  • @muckp thanks for the link. my husband interviewed some aspies on a private email list a while back. really interesting community. #
  • @clonezone, @petdance feed it to the chickens! #
  • @garethgreenway lol we’re a small company and telco people are $50/hr. its done now anyway. the electricians are installing the patch panel! #
  • ok, i figured out drupal views. updating the pugs site. #
  • take that, integrated headset framemakers. http://snurl.com/20lsq #
  • hooray for calagator! http://tinyurl.com/2qg3f9 #
  • @andeezy safeway on NE broadway has wifi, burgerville next to convention ctr does. #
  • jealous of @br3nda’s geekgirl dinners :) #
  • excited about new mission statement. #
  • @schwern no synergizing. just fun :) #
  • @karolcooks LOL #
  • cool php/postgresql presentations from a very humble programmer (see sidebar) http://snurl.com/20mm5 #
  • @grigs box "wine"? #
  • if i’m gonna booze it up at work, it’s going to be glenlivet. #

twittering on 2008-02-27

  • @theory heh. #
  • looking forward to extreme database makeover with @theory, @gorthx http://pugs.postgresql.org/node/154 #
  • at cubespace for barcamp planning #
  • @theory are you going to post those schema suggestions? i’d like to link to them… or post them on the PUGS site #
  • @spinnerin @ljbanks yup, high temp is the key! i use a pizza stone, parchment paper and a lot of steam to get a good crust #
  • btw @spinnerin’s bread and marmalade is the bomb. #
  • i started using my pizza stone before i had discovered parchment paper, so mine isn’t so pretty now. but it works great! #
  • my new absolutely most favorite blog: http://quotation-marks.blogspot.com/ #
  • thanks to @theory, mark wong and jeff davis for their work on extreme database makeover! http://snurl.com/20jhc #
  • @petdance so "true". my plan is to "catch up" on the last "three years" in the next "two hours". #
  • @petdance oh "right" #
  • @rael, @theory: "literally" is another favorite of mine – of course, there is a blog dedicated to its abuse: http://literally.barelyfitz.com #
  • @theory you tell me because my airport sux too. #

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

twittering on 2008-02-23

  • totally fixed a bug in Net::MAC #
  • @metafluence what happens in vegas, stays in vegas. #
  • dammit, @gorthx found another bug. #
  • totally going to see jumper #
  • going to the japanese garden today #
  • chickens are clucking about something or the other. #

twittering on 2008-02-22

  • coffee + laptop = disassembled laptop #
  • whatever, @linuxpoet. u want one. #
  • 15 teeny screws later, that keyboard is off and the air compressor blew another 8 oz of coffee out. #
  • considering purchasing a new keyboard. #
  • @notbenh u still coming to pdxpug? #
  • @notbenh if you’d be willing to be laptop provider, that’d be awesome. we were going to use my robot. not anymore. #
  • @kanejo gonna have to check out peter’s 19th hole. sounds awesome. #
  • @notbenh not really, probably just ability to go to web and look things up. #
  • stuff white people like: http://stuffwhitepeoplelike.wordpress.com/ #
  • laptop fully functional! #
  • josh drake came to PDXPUG last night. that was fun :) #
  • @andeezy when i have kids, i want to have twins. unfortunately, it is not in the cards. #
  • just finished rearranging office. qi flowing auspiciously. #
  • @adamd yay for bikes! #
  • mmmm. sushi. #
  • i love getting emails from the waffle cart about them having apple crisp this weekend. #

twittering on 2008-02-22

  • coffee + laptop = disassembled laptop #
  • whatever, @linuxpoet. u want one. #
  • 15 teeny screws later, that keyboard is off and the air compressor blew another 8 oz of coffee out. #
  • considering purchasing a new keyboard. #
  • @notbenh u still coming to pdxpug? #
  • @notbenh if you’d be willing to be laptop provider, that’d be awesome. we were going to use my robot. not anymore. #
  • @kanejo gonna have to check out peter’s 19th hole. sounds awesome. #
  • @notbenh not really, probably just ability to go to web and look things up. #
  • stuff white people like: http://stuffwhitepeoplelike.wordpress.com/ #
  • laptop fully functional! #
  • josh drake came to PDXPUG last night. that was fun :) #
  • @andeezy when i have kids, i want to have twins. unfortunately, it is not in the cards. #
  • just finished rearranging office. qi flowing auspiciously. #
  • @adamd yay for bikes! #
  • mmmm. sushi. #
  • i love getting emails from the waffle cart about them having apple crisp this weekend. #