PRETTY URLS USING MULTIVIEWS
I saw a post on digg.com about how it’s nice to have “pretty urls” that are easy to tell people. While i’m not sure anyone would remember rustyrazorblade.com slash some ridiculous post name, it’s nice to have for search engines. Unfortunately, it didn’t really go into detail about how to accomplish the urls. A lot of people suggested mod_rewrite. Yes, it’s something you can use, but kind of a pain to set up.
CAN YOU USE A STORED PROCEDURE IN A SUBQUERY? I DON'T THINK SO. (MYSQL)
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 | +—————-+—————+——+—–+———+——-+ | fkUser | int(11) | YES | MUL | NULL | | | fkFriend | int(11) | YES | MUL | NULL | | | confirmed | enum(‘Y’,‘N’) | YES | MUL | NULL | | | confirmed_date | date | YES | | NULL | | +—————-+—————+——+—–+———+——-+ 4 rows in set (0.
'POST-DIGGING: ASKHADDAD.COM'
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 - it was mostly contained in a period of 5 hours. Also funny to see people try to mess with the server, one person wrote a script to submit the same question in a loop.
ASKHADDAD.COM
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
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 will evaluate to NULL. For example, this statement returns NULL: mysql> select 4 + NULL; +———-+ | 4 + NULL | +———-+ | NULL | +———-+ Normally you wouldn’t do the above in such a simple way, for instance, you might do some addition in a subquery.
MYSQL TRIGGERS TUTORIAL
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 who have had triggers for so many years. I’ll use the example off the MySQL website (explained below in detail). I’ll assume you know how to create a table.
APPLE: IT'S SHOWTIME
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 give you cover art for free if you are missing cover art. That’s pretty sweet, since most of my music was ripped off of CDs.
RSYNC OVER SSH
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 line). rsync -ave ssh username@yourserver.com:/path/to/your/stuff/ /localpath/to/your/stuff/ You can put the local path first - it’ll push files up to the server instead.
AB ON DIGG.COM
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
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.