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-26

  • woo! spring is here. chickens laid an egg. #
  • welcome to twitter @cbbrowne :) #
  • summer of code for postgresql is ramping up! http://www.postgresql.org/developer/summerofcode #
  • @notbenh there, there. #
  • @andeezy i love that song. is that wrong? #
  • hah! phase Awful Hack to ptop To Make It Compile On Mac OS X complete! #
  • @muckp the chickens were not bold. we did that. that’s right. we snow-tortured our chickens. #

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-21

  • exporting a "medium sized" movie #
  • took 200+ photos of the eclipse. made a slideshow. uploading to pownce. #
  • xo my D40 #
  • my dad gave me a few nikon lenses a couple years ago. i finally am able to use them with the D40. my main film camera was my mom’s, a fujica #
  • ugh, now i’m hungry for cupcakes AND bacon. #
  • @petdance: no. #
  • funny tweets together: @ahockley- "exchange is down", @slashdot – "gates explains microsoft’s need for yahoo" #
  • social web != women in science/technology. more like blogging is replacing print. #
  • really cool that girls are into blogging, but it’s not translating directly into women in leadership positions in tech, especially in edu #
  • @petdance SHELLAC. yay. #
  • @spinnerin you’re rad! #
  • @spinnerin anytime :) #
  • hungry already. still want bacon and cupcakes. #
  • @notbenh that sounds really good right now. #
  • @metafluence yeah, you should fix that because i thought you were maybe my creepy uncle when i got the msg. #
  • working out a tricky issue among italians. #
  • @geekygirldawn hope you feel better soon. the sun is beautiful today! #
  • @kanejo which trivia night do you go to? #
  • @geekygirldawn i haven’t figured it out yet. #
  • @linuxpoet yay for sponsors! #
  • so, if you are organizing something with someone, do you say that you are an organizer, or a co-organizer? #
  • @notbenh different responsibilities, but still lots of time for both people #
  • @notbenh no hierarchy, essentially. yeah, i think just ‘organizer’ is better. #
  • @linuxpoet: right, but i was referring to myself as co-organizer :) because i thought it was "respectful". now i see that is silly :) #