philihp.com

Category: Uncategorized

Maximum sizes of MySQL Blob Fields

This is not immediately obvious from the documentation(, which as it seems is often the case, was written for people who just like to read documentation, and not for people who are looking for answers). The maximum sizes of the MySQL Blob fields are as follows: Type What They Say It Needs That Means You Get [...]

Using SAS/OR to solve Sudoku puzzles

I just got back from SAS Global Forum 2011 and heard about this really cool package called SAS/OR (Operations Research). Within it, there’s a procedure called CLP, which does nothing short of programming voodoo. The CLP procedure is a finite-domain constraint programming solver for constraint satisfaction problems (CSPs) with linear, logical, global, and scheduling constraints. [...]

Things I Learned from Wiring a Car Stereo

So I just finished installing a car stereo into my car. I wanted to do it myself to learn as much a possible. This post is to share bits of information that were previously buried on message boards, or were myths that car audio shops had previously told me (or debunked for me). DISCLAIMER: I’m [...]

Excel 2010′s Default AutoRecover Location

And so the only thing you need to know about Excel’s AutoRecover is this: the default path for Excel is: C:UsersyouApplication DataMicrosoftExcel Keep in mind, Application Data is usually a hidden folder, so you might not see it. It is still there.

The Family Reunion Problem

Here’s an interesting problem. I would like to call this the family reunion problem. As far as I know, this problem hasn’t been stated or generalized anywhere else. But maybe it has? Suppose a set of people live in different cities and wish to have a reunion. They’re fairly far apart such that they’ll be [...]

AT&T U-Verse DNS Loopback workaround for 3800HGV-B

AT&T’s U-Verse network just came up on my street. So… since the gateway doubles as a router & switch, I was trying to set it up so my httpd server was accessible from the outside. Setup the port forwarding through the firewall just fine, and indeed everything works for the rest of the internet. All [...]

Beep!

Make my computer beep. Go here: http://shatner.philihp.com/beep/