Archive for September, 2006

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

Wednesday, September 27th, 2006

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

Post-Digging: askhaddad.com

Monday, September 25th, 2006

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

askhaddad.com

Friday, September 22nd, 2006

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.

MySQL: Number + NULL = NULL

Wednesday, September 20th, 2006

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

MySQL Triggers Tutorial

Thursday, September 14th, 2006

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 developers ...

Apple: “It’s Showtime”

Tuesday, September 12th, 2006

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

Rsync over SSH

Monday, September 11th, 2006

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

AB On Digg.com

Monday, September 11th, 2006

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

Answerbag Reviewed on Techcrunch

Friday, September 8th, 2006

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.