The iPhone gets a PostgreSQL client
Spanware has released MobileCan, a PostgreSQL client for the iPhone. MobileCan allows an iPhone user to connect to PostgreSQL databases, browse tables, perform simple queries, get the status of long running processes and, if needed, kill them.
To make composing SQL on the iPhone easier, Spanware has incorporated a one-touch button set into the query editor for the ten most common SQL keywords. The 1.0 release of MobileCan has some limitations; you cannot edit connections you have configured; Instead have to delete and recreate them. MobileCan uses cursors to select data efficiently from the database, pulling in 20 records at a time. The developer notes that if there are fields with around thirty to forty kilobytes of data in them, it is possible to run out of memory.
Unlike the OilCan Mac OS X application also made by Spanware which is BSD licensed, there is no mention of any open source availability of MobileCan. It is currently available on the iPhone App Store for £4.99.