Here are some idea what I am thinking.This can be a really hard issue. In networking, if someone is editing a record, others are usually locked out or their edits are not confirmed.
When you have wide open editing with no central control, you have all kinds of issues.
It's really an issue of the data's usage.
Example: Right now I'm adding a record to this thread, if someone else adds to this same thread at nearly the same time, which post comes 1st? Answer: it really doesn't matter which one comes 1st.
I think you need to look at the specific usage of the data. You might look at having a 'confirm updates' and have a token on each record. If they can't gain control of the token, the can't confirm the updates.
Again it really depends on the usage.
Here are some idea what I am thinking.
1. Any user can add a new record
2. User can only modify record what he/she created.
3. Onwer(me) can modify all records.
I want to how to communicate between all users, do you have any idea to solve such problems?
That is what I want to know, is it possible to use SQLite to store data?What tool are you using for the data store.
That is what I want to know, is it possible to use SQLite to store data?
I don't want to use a server with DB to store data.
When owner created a record, he has to input his email address, that is a key to check if his owner for that record.More information is needed. Are all your users going to communicate when they are on the same local network or via bluetooth? If they can all be remote, then you'd need some service to at least coordinate communication. Are all the users going to have a copy of the data? If so, then how will you know who the owner is?
Think this through some more. Draw it on paper if you need to.
That is what I want to know, is it possible to use SQLite to store data?
I don't want to use a server with DB to store data.
When owner created a record, he has to input his email address, that is a key to check if his owner for that record.
I mean all users are in remote. And with one copy of data.