Create a bootable OS X El Capitan installer

This is how to create a OS X El Capitan installer on a flash disk or external disk.

Download OS X El Capitan from the App Store. When it finishes downloading, quit the installer. The “Install OS X El Capitan” application should be in your /Applications folder. On a side note even if you do not create a bootable installer, it’s a good idea to get a backup of this installer before running it. After upgrading your system, the installer will remove itself.

Format a flash stick Mac OS Extended (Journaled) with GUID Partition Table

Name the disk “Untitled”. Simply because the command below references the disk by the “Untitled” name.

In Terminal, run:

sudo /Applications/Install\ OS\ X\ El\ –volume /Volumes/Untitled –applicationpath /Applications/Install\ OS\ X\ El\ –nointeraction


Master Controller Lyrics

These are unofficial Master Controller lyrics I wrote and performed for the Pertino Summer party 2013:


Find out which program is using which port on OS X

lsof -i  | grep LISTEN


lsof -i -P | grep <portnumber>

Using PHP to create a MySQL datetime

For reference

$datetime = date('Y-m-d H:i:s');

Changing Calendar Colors on a Jailbroken iPhone running iOS 5

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 (you must have Cydia in “Developer” mode so it lists the command-line utilities)

– ssh to your iPhone (as user mobile)

– 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 &amp; Nasique';
sqlite> UPDATE Calendar SET color='#AC725E' WHERE title = 'Health';

-Quit sqlite3


-Quit ssh


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


Twitter API, PHP precision and scientific notation

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);


Debian squeeze

Here is what you need if you have some binary on Debian squeeze which wants

sudo dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb

mBuzz Maintenance Page

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.


Show or Hide hidden files in Finder OS X

Here is how it’s done via the Terminal:

defaults write AppleShowAllFiles TRUE
killall Finder

How to Hide Hidden Files:

defaults write AppleShowAllFiles FALSE
killall Finder

Thanks Brooks Andrus


Google Search Globe

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