MobileCan 2.1 for iPhone OS 3.0
MobileCan is a full PostgreSQL client for the iPhone. It features the ability to generate complex queries without ever using the keyboard. MobileCan shares an interface similar to iMy.
Features:
- Construct complex queries using the built in keyword list and table and field views
- Save queries for future use
- Email query results directly from MobileCan
- Get server statistics and terminate processes
- Uses Keychain to store passwords securely
Walkthrough
Managing Connections
The Connections screen. The database is in blue on the top line, with the user and host name on the second line.
Adding or editing a connection. Enter the information for each connection. If the password is left blank, there will be a prompt when attempting to connect to the database. This adds security in case your device is lost or stolen.
Working with the interface
Connected to the database. Here is the main query screen.
Underneath the query text is a list of keywords that will be inserted into the query when pressed. Pressing the "Tables button" will toggle the button to read "Keywords" will show the tables and fields in the datbase. Selecting a table on the left will update the fields on the right. Click on the "Use Table" or "Use Field" button to insert into either the selected table or field into the query. Press the toggled "Keywords" button to return the keywords.
The toolbar also has a comma button for easy entering of multiple fields in a query.
Pressing the queries button, will bring up a list of saved queries that can be reused. These queries can be saved pressing the Save button, and the text of the query will be saved.
Executing Queries
Viewing an executed query
The first view that is seen after executing a query is the abbreviated field view. The row number is in blue on the top row, and the first three fields are listed below. The fields are listed without field names.
From here, the next 20 records can be retrieved by pressing the "20 more" button.
The current query results can be emailed by pressing the "Email" button. All fields will be put in a tab delimited format with a header row, and inserted into an email.
Viewing Records
Viewing a record in detail.
Selecting a row in abbreviated mode will present the full record in vertical form. If for some reason, the field is longer than can be read on one line, a disclosure indicator will appear, showing the full value of the field.
Server Status
This view presents the Server type and all connected processes to the server. Selecting the server at the top will show more detailed server statistics, such as uptime, etc.
By selecting a process, it is possible to view the full activity, and with proper permissions, kill that process.
Selecting the server at the top will show more info and allow for reloading of the configuration file, and log rotation. Following along this path, more detailed database info can be seen. Table and index information is available by going one level deeper.
Support
See here for MobileCan support.
