iMy 1.5 for iPhone OS 3.0
iMy is a full MySQL client for the iPhone. It features the ability to generate complex queries without ever using the keyboard. The interface of iMy is very close to MobileCan.
Features:
- Construct complex queries using the built in keyword list and table and field views
- Save queries for future use
- Export query results to Google spreadsheets
- Advanced filtering of query results
- Email query results directly from iMy
- Get server statistics and terminate processes
- Uses Keychain to store passwords securely
- Native compiled MySQL client library for maximum performance
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.
Queries can also be edited to change its name or actual query text.
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.
Filtering Records
Records can be filtered on any field, with options to set whole world and case sensitivity. All records that match the filter criteria will remain in the detail view. Tapping the "Clear Filter" button will remove the filter. While records are filtered, the ability to retrieve more records is disabled.
Exporting To Google Spreadsheets
iMy has the ability to export your queries directly to a Google spreadsheet. Press the "Google" button, enter your Google user name, password, and a spreadsheet file name. All retrieved records will be saved to a Google spreadsheet. If there is a filter present, only the filtered records will be saved to the spreadsheet.
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.
Support
See here for iMy support.
