Saturday, September 08, 2012

Database Designer for iOS

I'm involved in quite a complex project right now and i'm responsible for the system architecture and DB design as i'm the project leader for this project. Sometimes, when i'm not in front of the PC, i wanted to work, at least designing the database using my iPad.

I searched through Google and found a product that might be perfect for me: MySQL Mobile Database Client by Impathic. Here's some description and it's feature copied from the original page in App Store:
Browse, search, and update all your MySQL databases on the go with the DataGlass Mobile Database Client for MySQL! DataGlass is your one stop for complete and flexible access to your MySQL servers. From DBAs and IT professionals that need to run ad-hoc queries, to executives who need immediate access to the raw data, to analysts who need to build and execute sophisticated reports, DataGlass is the only app you will need to connect you directly to your data. Whether you are accessing your servers from your local network, or remotely through your organization's secure VPN, you never need to be without the information that is the lifeblood of the modern enterprise. DataGlass requires no complicated desktop servers or expensive middleware to set up: the speed and flexibility of direct connections to your server provides unparallelled efficiency.

• Compatible with MySQL versions 3, 4, and 5
• An unlimited number of databases can be simultaneously managed by DataGlass
• Connect directly to your databases without the need for complex and expensive middleware
• Corporate databases can be accessed remotely using a VPN or by using the built-in SSH tunneling
• Can access tables and views in OLTP databases and data warehouses alike
• Export your raw data to Numbers, Mail, or CSV files for inclusion in external reports
• Save local snapshots of your data for browsing offline or on the road
• Generate elegant charts from your data within the app
• Print the results of your queries directly from your printer-enabled iOS device
• Build and execute sophisticated queries spanning multiple tables using the innovative Query Designer, or enter custom SQL
I think it's a good product. I will have a look on it shortly