Bookmarklet for today's time report in Basecamp

javascript:var%20d=new%20Date();location.href='https://YOUR_URL.basecamphq.com/time_entries/report?subject_id=YOUR_SUBJECT_ID&from[month]='+(d.getMonth()+1)+'&from[day]='+d.getDate()+'&from[year]='+d.getFullYear()+'&to[month]='+(d.getMonth()+1)+'&to[day]='+d.getDate()+'&to[year]='+d.getFullYear()+'&commit=Create+report';
Replace YOUR_URL and YOUR_SUBJECT_ID with your Basecamp URL and the user’s ID of interest. You can get a user ID by running a custom time report for just that user in Basecamp. Look next to “subject_id” in the URL of the report.

Getting Rails, Sphinx, MySQL working on Snow Leopard

Had to switch to the 64-bit version of MySQL. Then I needed to re-install the MySQL gem as follows:
env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
For Sphinx, I had to compile with the following commands:
LDFLAGS="-arch x86_64" ./configure --prefix=/usr/local --with-mysql=/usr/local/mysql
make
sudo make install
Check out this website for more info.

Update: Use the 32-bit version of MySQL if you’re still on Leopard. Apparently the Ruby interpreter is 32-bit on Leopard and 64-bit on Snow Leopard. Grr.