Hi. I have been asked to build a new app which will interface with an online database by both downloading and uploading data. Briefly..
A web app will be built so dealers can log in and enter their details.
Dealers can also set up special offers for trade events
The Android app must access the online database (above) and allow attenders of the trade events to download special offers to a wallet on their phone/tablet.
They can then present (show) them to the dealers and get the special offer.
I have a number of questions, please:-
1) Can I build an SQL Lite database which will be usable as the online database (ie loaded to the domain space)
2) I am guessing that, when a person logs into the Android app, I should be querying the online database
and storing any special offers locally (in a replica SQL Lite database) for them to browse and save any of interest in a 'wallet'on their phone/tablet
3) Would this approach enable a flag to be sent back to the online database to update a count of offer redeemers?
Am a bit overwhelmed at the challenge at the moment so any help would be very much appreciated.
Thanks in anticipation,
Malcolm
A web app will be built so dealers can log in and enter their details.
Dealers can also set up special offers for trade events
The Android app must access the online database (above) and allow attenders of the trade events to download special offers to a wallet on their phone/tablet.
They can then present (show) them to the dealers and get the special offer.
I have a number of questions, please:-
1) Can I build an SQL Lite database which will be usable as the online database (ie loaded to the domain space)
2) I am guessing that, when a person logs into the Android app, I should be querying the online database
and storing any special offers locally (in a replica SQL Lite database) for them to browse and save any of interest in a 'wallet'on their phone/tablet
3) Would this approach enable a flag to be sent back to the online database to update a count of offer redeemers?
Am a bit overwhelmed at the challenge at the moment so any help would be very much appreciated.
Thanks in anticipation,
Malcolm