From the monthly archives: September 2006

Can you use a stored procedure in a subquery? I don’t think so. (MySQL)

By On September 27, 2006 · 14 Comments

I do not think you can use the result of a stored procedure in an ad-hoc subquery.

On my social network, LetsGetNuts.com, I have a Friend table. This is the structure:

mysql> describe Friend;
+—————-+—————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+—————-+—————+——+—–+———+——-+
[...]

Continue Reading →

Post-Digging: askhaddad.com

By On September 25, 2006 · 2 Comments

Glad I was able to think of something interesting enough for the digg community to vote up so highly, but I was a little surprised to see that question submission has completely stopped.  I’ve been sitting at 388 all weekend.

It was interesting to see traffic spike up to 67K pageviews for the day – [...]

Continue Reading →

askhaddad.com

By On September 22, 2006 · Leave a Comment

I’ve created an experiment, askhaddad.com. I answer all questions in the order they are received, unless they are blatent spam or nonsense.

Askhaddad.com is an anti-social q&a site – there is no user community, and I am the only one that answers questions.

Continue Reading →

MySQL: Number + NULL = NULL

By On September 20, 2006 · 14 Comments

Maybe not breaking news, but I think it’s interesting enough of a point, and I didn’t really find anything about the topic when I googled it. If you do any addition, subtraction, multiplication, or division (and probably a lot more mathematical functions for that matter) and NULL is one of your values, the entire expression [...]

Continue Reading →

MySQL Triggers Tutorial

By On September 14, 2006 · 50 Comments

If you’ve worked with any of the commerical databases other than MySQL, you may have already had some experience with triggers.

I’m glad that the MySQL developers finally managed to squeeze in this extremely important feature. I no longer dread trying to defend MySQL from the Microsoft and Oracle [...]

Continue Reading →

Apple: “It’s Showtime”

By On September 12, 2006 · Leave a Comment

Might as well list the latest Apple stuff they’re announcing today.

Games: Interesting. I’ve always been a pacman fan. They will be starting with the following: Bejeweled, Cubis 2, Mahjong, Mini golf, pac man, tetris, texas holdem, vortex, and zuma. Glad they’re compatible with my 5th gen iPod.

iTunes 7: According to iLounge, iTunes will [...]

Continue Reading →

Rsync over SSH

By On September 11, 2006 · 1 Comment

Took me a while before I got on the ball and starting doing this for syncing my web servers docs to my local machine (for backing up). I had previously used Interarchy for this, but I really prefer to use the command line, where I can schedule it via a cron (should all be 1 [...]

Continue Reading →

AB On Digg.com

By On September 11, 2006 · 1 Comment

Someone was nice enough to post a story about Answerbag on Digg. I thought our widgets were pretty cool – this dude is impressed enough to call it “killer”. Awesome.

read more | digg story

Continue Reading →

Answerbag Reviewed on Techcrunch

By On September 8, 2006 · 2 Comments

Worth mentioning that the site I develop, answerbag.com, has a pretty good review on TechCrunch. They mentioned the XML API we have in the works, and the widgets we just came out with.

Continue Reading →