http://www.baconandtech.com Because everything's better with bacon Tue, 12 Jan 2010 07:03:44 +0000 http://backend.userland.com/rss092 en I have this little sorting problem that had been bothering me for a month, but as it's only a minor annoyance, I hadn't spared the cycles to work on it. Last Friday I decided I needed an instant gratification project, and set about solving it. I have a table that ... http://www.baconandtech.com/2010/01/12/array-sorting/ Last night at the hackathon,  we refactored one of our queries from my review of Refactoring SQL Applications.* First, we had a duplicate field name in the original select.  Not a problem if you're just doing a select, but if you want to create a table (temp or otherwise) from the ... http://www.baconandtech.com/2009/11/06/refactoring/ We arrived at the conference site to find that the XML Data Warehousing had been canceled, so I spent that session in the Hackers' Lounge attempting to continue work on pg_proctab, while getting kicked off the commie college wireless. In Lists and Recursions and Trees, Oh My!, David Fetter gave us ... http://www.baconandtech.com/2009/10/19/pgwest-sunday/ This past weekend was the 3rd annual PgWest.  The conference moved up to Seattle this year, and I think it was the biggest it's ever been.  As usual, there were more interesting talks scheduled than I had time to attend.  (This is the 21st century;  where's my time machine?) For my ... http://www.baconandtech.com/2009/10/19/pgwest-saturday/ Jeff (aka @duckyd) gave a presentation about CPAN Awesomeness at last night's pdx.pm. Slides are on github!  Your homework is to find them. :)  Here are some highlights. There are over 16K modules on the CPAN as of 11 Oct 2009.  Wow. Jeff's recommended changes from the default cpan shell configuration: - auto_commit 1 - ... http://www.baconandtech.com/2009/10/15/pdx-pm-meeting-notes/ (I'll be missing Friday's tutorials.) Saturday: 9am:  Jeff Davis:  PostgreSQL, Extensible to the Nth Degree.  Jeff's talks usually melt my brain, and I like that. 10:15:  Conference Keynote. 11:30am:  Mark Wong: pg_proctab.  Turns out I'm giving this talk with Mark, even though my name's not on the schedule.  I should probably show up. 1:45pm:  Scott ... http://www.baconandtech.com/2009/10/13/my-picks-for-pgwest/ At a loss for what to do next weekend?  Grab your rain gear & head on up to Seattle for PgWest 2009. There'll be three days of talks & tutorials plus a hackers' lounge.   After-party plans are nebulous at this time, but we are researching options.  (Psst--pub crawl!) Come join the fun! At ... http://www.baconandtech.com/2009/10/08/are-you-going-to-pgwest/ (just in case you haven't read about it yet): http://pugs.postgresql.org/node/584 http://www.baconandtech.com/2009/09/23/pdxpug-patch-review-party/ Hacking on 5.10.1 was the plan...that happened for a couple of us. :) Duke proposed a PDX.pm sprint to work on 5.10.1: "I think if everyone learns how to a) get a copy of the perl git repo b) keep it in sync c) run the perl test suite, including running a single test ... http://www.baconandtech.com/2009/07/02/pdxpm-code-sprint-1/ This week I attended Open Source Bridge here in Portland. Typically, I managed to miss the keynotes both days. There is something about conferences which makes me sleep through my alarm. It was really hard choosing which talks to attend. The results of the coin toss: Wednesday: Tcl/Tk: Grandpa might be old, ... http://www.baconandtech.com/2009/06/20/osbridge-recap/