Hello there good people.
I am working on my final studies project and I was wondering if any of you can throw me some leads to help me learn while I make the progress.
here are my needs :
every app creates a unique id of itself when installing.
(already done).
each app has it's own local db (very simple table, 50 items, two rows, two strings)
(already done)
all apps can connect to the main web hosted sql server (linux)
(almost done)
This main database will contain all app's local databases in one table.(app id , string1, string2)
app users can read the complete main database but able to modify or delete only the data that matches in their own local db.
how this is done?
(I assume that app id will be the key)
in other words,
every time a user is modifying his own listing (in the local db) , the listing in the main db has to be synced.
your help, thoughts, ideas, code samples will be very and extremely appreciated.
I am working on my final studies project and I was wondering if any of you can throw me some leads to help me learn while I make the progress.
here are my needs :
every app creates a unique id of itself when installing.
(already done).
each app has it's own local db (very simple table, 50 items, two rows, two strings)
(already done)
all apps can connect to the main web hosted sql server (linux)
(almost done)
This main database will contain all app's local databases in one table.(app id , string1, string2)
app users can read the complete main database but able to modify or delete only the data that matches in their own local db.
how this is done?
(I assume that app id will be the key)
in other words,
every time a user is modifying his own listing (in the local db) , the listing in the main db has to be synced.
your help, thoughts, ideas, code samples will be very and extremely appreciated.