There are good and bad choices available for the design of my system and
MySQL seems to be the best available. I need it to run client/server
and support stored procedures & triggers and a host of other
features. But I also need a database that will run single-user on
mobile devices when off-line, then synchronize with the on-line server
when reconnected to the Internet. The only database provided with
Android is SQLite - which doesn't even come close to providing the
features required. Also, installing MySQL on Android devices would mean
that I wouldn't have to support any incompatibilities between two
different databases. I do not need other features installed (HTML
server, PHP, etc)... just MySQL. How can I get that installed (and with
my apps(s)) and have it work easily and efficiently (and not have to
root or install a new ROM on the device)?
I currently work on an open source e-commerce platform
() and I am trying to work out if I can deploy an offline
version that can run on an tablet. I was hoping to use an iPad but this
has proved very difficult (impossible?)
a) Does anyone know of an AMP (apache mysql php) version that will run on a tablet - eg. Android?
The idea is to have a local version of the online store that sales
reps can use when selling to wholesale customers that will store the
orders locally until they find a WiFi or 3G signal at which point it
will merge the new records into the webserver.
If I could get Apache, MySQL and PHP to run locally (like it does
using WAMP, MAMP, LAMP, etc.) it would be great as the app would be
usable without an internet connection.
Regards,
