Chris Carey

iOS 5 changed the database that deals with Calendar colors. The value is now a hex value just like CSS uses (something like #fe6548)

- Install sqlite3 via Cydia

- ssh to your iPhone

- Run sqlite3 and open the calendar database

iPhone:~ mobile$ sqlite3 /var/mobile/Library/Calendar/Calendar.sqlitedb

- Issue the SQL commands to change the calendar colors:

sqlite> UPDATE Calendar SET color='#9FC6E7' WHERE title = 'Chris Carey';
sqlite> UPDATE Calendar SET color='#FF7537' WHERE title = 'Work';
sqlite> UPDATE Calendar SET color='#D06B64' WHERE title = 'Important';
sqlite> UPDATE Calendar SET color='#B3DC6C' WHERE title = 'School';
sqlite> UPDATE Calendar SET color='#4986E7' WHERE title = 'Chris & Nasique';
sqlite> UPDATE Calendar SET color='#AC725E' WHERE title = 'Health';

-Quit sqlite3

.quit

-Quit ssh

exit

If needed, kill the calendar app or reboot the phone to get it to reload the new colors

If you use PHP and the Twitter API, be on the lookout for this issue.

Twitter IDs are up to 141 quadrillion (141 million billion). These Twitter IDs exceed PHP’s default precision of 14. So your Twitter IDs could be converted to scientific notation by PHP.

A Twitter ID of 141675395434037249 will be stored as 1.41675395434037249E+17 once PHP gets it’s hands on it.

This could cause code that has been working great for a while to stop working.

Edit your php.ini and set precision to 20, or use
ini_set(‘precision’, 20);

Here is what you need if you have some binary on Debian squeeze which wants libmysqlclient.so.15


wget http://ftp.nl.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
sudo dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb


mBuzz Maintenance page. The ‘Like’ and ‘Comment’ buttons both function. It sent the Likes and Comments into an IRC channel that could be seen during the upgrade process.

Here is how it’s done via the Terminal:

defaults write com.apple.finder AppleShowAllFiles TRUE
killall Finder

How to Hide Hidden Files:

defaults write com.apple.finder AppleShowAllFiles FALSE
killall Finder


Thanks Brooks Andrus

Google is working on this open source data visualization project Search Globe, check it out. I’m a big fan of creative data visualization.

The location of Google Buzz within GMail does not make sense to me.

Currently Google Buzz is inside of GMail, along with Inbox, etc:

Here is how it should look. Google Buzz should be it’s own section up with Mail: