Hello good friends.
if any of you have some spare time , I would appreciate a little help.
this is an important project for school
I am very new to databases. as I am self learning , I create a local database system where the user can add ,view and edit three strings , without any limits (every entry = 3 strings)
easy.
as I learn (sql and json) , I would love to come here and read whatever you are willing to share
The next phase of the project (will get there in a few days) is to connect and manage firebase database.
now, in this phase, I have an app with an initial local database. (a user can create unlimited entries in local database , that is in the phone)
in this phase, I will need :
1. google auth. (saw in the forum so I think i'll manage doing that, although I did not try it yet)
(I will add facebook auth later on.)
2. possibility of all app users (authenticated and also NOT authenticated) to read from one main public database (basically the work is to compare strings local and remote)
3. Only authenticated users can post to main public database.
BUT
4. limit every authenticated user to post (add to public database) up to 10 entries only.
(if a user has used all of his own created 10 entries he must delete one in order to add a new one - or edit/modify existing)
the first question that comes to mind is this : how do I implement the last one. how to limit each connected user to add to public database only up to 10 entries but allow unlimited access to read the whole database to all app users...
Your thoughts, insights , remarks or any good lead to get me starting...would be very appreciated.
I will update my progress here of course.
Thank you in advance good people.
if any of you have some spare time , I would appreciate a little help.
this is an important project for school
I am very new to databases. as I am self learning , I create a local database system where the user can add ,view and edit three strings , without any limits (every entry = 3 strings)
easy.
as I learn (sql and json) , I would love to come here and read whatever you are willing to share
The next phase of the project (will get there in a few days) is to connect and manage firebase database.
now, in this phase, I have an app with an initial local database. (a user can create unlimited entries in local database , that is in the phone)
in this phase, I will need :
1. google auth. (saw in the forum so I think i'll manage doing that, although I did not try it yet)
(I will add facebook auth later on.)
2. possibility of all app users (authenticated and also NOT authenticated) to read from one main public database (basically the work is to compare strings local and remote)
3. Only authenticated users can post to main public database.
BUT
4. limit every authenticated user to post (add to public database) up to 10 entries only.
(if a user has used all of his own created 10 entries he must delete one in order to add a new one - or edit/modify existing)
the first question that comes to mind is this : how do I implement the last one. how to limit each connected user to add to public database only up to 10 entries but allow unlimited access to read the whole database to all app users...
Your thoughts, insights , remarks or any good lead to get me starting...would be very appreciated.
I will update my progress here of course.
Thank you in advance good people.