Archives for the ‘Programming’ Category On-The-Fly Account Switching in OS X 10.6+

Like most people, my wife and I have a number of email addresses for different purposes – work addresses (we each have several for different projects & businesses), personal addresses (Gmail, iCloud, etc), addresses for our various websites, etc. ¬† Over the years we’ve both found that it’s very important for mental well-being to keep […]

Implementing an Apple Help Book in OS X Snow Leopard and Lion

The documentation at Apple regarding help book implementation leaves a lot to be desired. It seems that updates have been added here and there, and overall the documentation is fragmented. Add to that the fact that Apple is no longer providing sample code for it makes the process of creating a help book a royal […]

Xcode 4 & Subversion over SSH With Custom Port

I run a SVN repo on a local server that I wanted to connect to via ssh on a custom port using shared key authentication. I use Xcode 3.2.6 for some legacy apps and Xcode 4 for new software. ¬†Unfortunately Xcode is less than helpful with this setup, and though a few things seem to […]

Grab Last Model Number From Alphanumeric String In MySQL

I ran into this MySQL problem today and couldn’t find a clear-cut answer online so I figured this might be useful to someone else. Suppose you have a table a column that houses alphanumeric substrings, such as is often used for item model identification, eg.: A1 A2 A3 B1 B2 B3 AB1 AB2 AB3 How […]

AppleScript Objective-C: Dealing with Paths

Here are a couple of notes that might be helpful when dealing with paths in Cocoa-AppleScript applications in Xcode: Getting the POSIX Path to Resources With Global Scope If you need the POSIX path to the Resources folder in the App (for instance, if you intend to reference some resource files in a shell script) […]