How to configure TextMate’s SQL bundle on Mac OS X Snow Leopard

TextMate is a great text editor for Macs. Its supports a myriad of programming and scripting languages. However, after I installed it. I was unable to get the SQL bundle to work properly on Mac OS X (10.6.x) or Snow Leopard. I blew it off for a while. Then I found this post by 豆皮儿.

The post says to replace the keychain and plist bundles in TextMate’s application bundle. Instead of using the command line, I recommend these steps:

1. Go to http://svn.textmate.org/trunk/Support/lib/osx
2. Download keychain.bundle and plist.bundle.
3. In the Finder window, navigate to /Applications/TextMate.app and right-click Show Package Contents.
4. Navigate to /Contents/SharedSupport/Support/lib/osx.
5. From your downloads directory, drag the new keychain and plist bundles to the osx directory.
6. Open TextMate, configure the SQL bundle (SQL > Preferences) and test a query such as “SELECT 1;”

That’s it. Enjoy.