This creates a histogram to see when rows were created, grouped by day (assuming your table has a created_date column and dates are stored in unix time)

SELECT count(id) count, from_unixtime(created_date) date FROM blah WHERE created_date > UNIX_TIMESTAMP('2011-03-31') GROUP BY CONCAT(DAY(from_unixtime(created_date))) order by created_date;The ( Read more... )

When I got our first power bill for the new house, I had what one would consider a sticker shock. The bill was almost an order of magnitude larger than our old bill! How could this happen to Northwest Profile #12, the 60F thermostat guy? This triggered a fact-finding nerdgasm freakout where I learned some interesting stuff (one should always ( Read more... )

Five years ago, I created a disaster kit for the twins and me. Since the shelf life of emergency rations is 5 years, and it would only be fair to have some supplies for Venessa and Lillia.

It seemed like a shame to let MREs (which should last a couple decades) go to waste, just because they might be bad, so I decided to eat some of them and see ( Read more... )

rosiedee just pointed out to me that LJ has games now ( Read more... )

"dear dad, Thank you for coming to our filed trip. I [...?] know that pumies floats. Sinselsoeila*, aaro.n"

He drew a picture of pumice floating in a jar. We went to the Burke Museum.

* "Sincerely?"

I have a love/hate relationship with the Puyallup Fair. I love the family tradition of taking the boys every year, but I hate the constant bombardment of crap to buy (like I'm really going to impulse buy a hot tub or tractor?). This year, I decided to take note of all the stuff we did that didn't cost a penny (other than the price of admission ( Read more... )

This came in an email from Bill Meyer last year and I always search the web to find it (forgetting it's in my inbox). Now it's on the web!( Read more... )

Googling for this error didn't turn up any useful matches so I figured I'd share the knowledge:

If you just installed Redmine and you get this error the first time you attempt to serve a web page:

Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings`You forgot the essential but simple step of bootstrapping the database ( Read more... )

update
"dogsex44" was kind enough to take a break from his busy bestiality schedule and post the following:

Guitar Tab:
Tuned a half step down
Intro: A
Verse: A F Bb A Ab
Bride: A F
Verse: A F Bb A Ab

http://www.youtube.com/watch?v=H0MXB39A3Yw

So there you go.

/updateI ( Read more... )

I got in touch with Robert from theslowlane.com because I wanted to see his packing list. After checking out the mileage this guy has racked up, I knew he'd have a great answer to the question "what to pack for a long bike tour?"

Below is his list (sent to me via email, Copyright Robert) ( Read more... )