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.
PHP 5.1.4 INSTALL ON INTEL MAC (BUG?)
I noticed after installing PHP 5.1.4 on my brand new MacBook Pro that my scripts weren’t executing. After about 3 hours of messing around, I realized that short_open_tag was turned off in php.ini. Location: /usr/local/php5/lib/php.ini Should be: short_open_tag = On Not sure if this is a common issue, or if the PHP defaults have been changed. I installed the package distributed by Marc Liyanage, found at his homepage. _Edit: According to the php web site, this should be on by default.
MY BEEF WITH THE WIKIPEDIA
I used to think the wikipedia was pretty cool. The idea of being able to collaborate on a topic and create an article together sounds wonderful. Today, I say, it sucks. Want to know why? I edited an article, updating it with correct information, and my edit was rejected within 5 minutes. ** 00:01, 16 August 2006 (hist) (diff) Answerbag (rv - Vandalism. Jonathan Haddad is not listed on the site under staff.
FIRST POST - REJOICE
Well, I’m not sure who’s going to be reading this, but if you are, and you are curious about rustyrazorblade.com, here’s the breakdown. I am a web developer with a BS in computer science. What I have to share is a combination of what I’ve learned in school and what I’ve learned developing and optimizing several web sites. I used to work at Intermix (creators of MySpace) working on grab.com, a site for casual gaming.