Manage PostgreSQL Database with iPhone or iPod Touch App

Here is another awesome application from the App Store for your iPhone and iPod touch. If you are a web developer who runs a web site with PostgreSQL open source relational database, then MobileCan comes handy. We fell in love with this app instantly, ouch! We love databases.

MobileCan is a query and database management tool for PostgreSQL databases. It’s a mobile OilCan for your iPhone with a few additions including server management. As you know, OilCan is a popular Universal Binary Mac OS X PostgreSQL query tool.

PostgreSQL databases run on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others.

MobileCan touch gives you access for the most commonly used SQL keywords and one touch to access list of tables to insert into a SQL query. For server management, it gives you the status of running processes and kill long running processes. You get to see two views of your data: Simple view of just the first six fields, and the Entire view by drilling down on a record. Data can be viewed in abbreviated or full detail mode. Price: $7.99 (download).