Please help me understanding how can I make app with data to be refreshed each day from a server.
What are the methods to upload data within the app ?
Use RDC. If it
does not involve images/blob data (which you would otherwise store on disk - rather than blob), it is quite easy to do - when you know what to do...
I do this with all my tables in my app. It determines what is new on the server and refreshes my mobile app with 'new stuff'.
First, your server table(s) need to have an updated field (MySQL Timestamp). This field gets updated each time the record is updated/modified on the server (or when new data from mobile updates it - if shared). When your mobile app last updated it's tables from new stuff from the server, it should update a local table with a time-stamp of when THIS table last updated. This is your check if it needs to be done again.
Have your mobile app check each table's LAST update record to see if new changes exist on the server. If new data on server exists:
1. What I found is most practical...
DROP the local table, recreate it and insert EVERYTHING from the server. This way, you don't have to deal with updates, new inserts or deletes. Everything from the server gets into your local table.
2. Manage updates, inserts, deletes in your own fashion.
Note: Option 1 works great when dealing with a small amount of records/data.. (under 5 meg - configuration data )... Otherwise bandwidth and cell costs (data plans) may be an issue depending on how often it is invoked. (Wifi - no concern).
Your question has
HUGE implications depending on your actual needs/environment. There is no "one solution fits all". These days it all depends on how much you (or your customer) is willing to spend in data transfer costs - when on cell (eating up your 1 gig/month/device plan) - which most rely on now.
Think about it...