OilCan source
Verson 2.0
This version is completely redone dispensing with the NSDocument architecture. Just as with 1.1, OilCan is licensed under a BSD license, and the Xcode project can be downloaded from here.
A new version of the universal binary of libpq is also included. This version is from PostgreSQL 8.2.6.
The source will extract into a subdirectory called "source". You must have PostgreSQL header files installed, as well as the libpq .dylib.
OilCan uses a custom version of libpq compiled as a Universal Binary, so that it will work on both Intel and PowerPC Macs. If you do not need this capability, you may use your own version and delete the Copy Files build phase and the Run Script that copies the .dylib and runs install-name-tool. Instructions for building the Universal version of PostgreSQL can be found on the mailing list archives. The easiest way however is to copy the .dylib from the Frameworks package of the binary release, and put it in /usr/local/lib. Then install PostgreSQL from source in /usr/local/pgsql.
Version 1.1
Version 1.1 has full source (Version 1.0 was missing some files). Those files are responsible for the PostgreSQL access. These files will be completely changed for version 2.0.
Some notes on the source:
This is the first really large Cocoa application that I have written, and it probably shows. The next full version of the app will be much cleaner. The NSDocument architecture will be removed.
The basis of the database communication is a very rough Objective-C wrapper around pqlib. This code is going to be redone to allow for nonblocking queries to be run as well as a slew of added functionality.