Liya for iPad
Open iTunes to buy and download apps.
Liya connects to MySQL and PostgreSQL databases, and allows iPad users to access and edit the database contents.
What's New in Version 1.0.2
Bug fixes. Includes updated database connectors to match the latest versions of MySQL, Postgres and SQLite3.
Also, Liya will now do everything with a Postgres database that it can currently do with a MySQL database.
For example, Liya can now do data entry and searches for data in fields with quotes, double-quotes, apostrophes, umlauts, diacriticals, any human language (like Traditional or Simplified Chinese or Tamil), and even partial date strings, for both MySQL and PostgreSQL databases, and it will do it consistently across Mac, iPhone or iPad devices.
Proves a Point
This App seems to have been written by someone to do precisely what THEY want with THEIR database. For anyone else, it's likely to be pretty useless.
Where do I start?
When browsing - any field longer than 80 characters is unreadable apart from the first 80 characters.
If you have field names longer than eight characters you can't read them, and if those first eight characters are similar then you can't tell which field you are looking at.
App provides an edit feature but restricts fields to the 80 character view so editing is impossible unless it's the final 80 characters.
Can add records but the restrictions above apply and the App ignores your carefully applied database design:
.....fields are not laid out in the order that your database is programmed to appear so fields with similar names, as truncated by the App cannot even be distinguished logically from their on-screen order
.....sets all numeric and text null fields to 0 or empty
.....automatically puts today's date into date fields and doesn't permit them to be set to null
.....time fields get set to the current hh:mm:ss but editing only allows access to the hh:mm portion of the field, and they cannot be set to null
......and there's more but I'm tired of writing.