I own a pool league and i would like to write a app so I can keep score on the phone. I would like it to keep the data on the phone and then when it is all done you can hit a button to submit it to me over the internet. It has to be able to be shut down and started back up without loosing any data on the phone.
My question is what would be the best way to go about this. I have thought about using a text document and writing to it then sending it over the internet as an email. I have thought about doing it with a spreadsheet then email the sread sheet. I have thought about doing it in a database then sending the database.
It has been a long while since i have made android apps and I'm a little scatter brained right now on how to approach it. More than likely I will need a tutorial to follow as well so if you have an idea please let me know.
There are several ways. I prefer a server solution with a MySql database (about 10$ a month).
- you can do a login (mail & pw)
- you then know the league's members
- you can send push messages to the members very easy via GCM (like WhatsApp)
- you can do a lot of more things (member fees, events, etc.)
- the data is safe on your server (hosted)
Sounds complicated? No. It's easier than a email based solution which is hard to synchronize.
There are several ways. I prefer a server solution with a MySql database (about 10$ a month).
- you can do a login (mail & pw)
- you then know the league's members
- you can send push messages to the members very easy via GCM (like WhatsApp)
- you can do a lot of more things (member fees, events, etc.)
- the data is safe on your server (hosted)
Sounds complicated? No. It's easier than a email based solution which is hard to synchronize.
That all sounds good for how to get it after the fact, And i will probably use that to have them submit the scores but how do i collect it in the first place. If i do it like that and the server is located else ware i will have to have internet access at all times. which is definitely not possible. So how do i store it on the phone until such time as i can submit it to the server.
Lets Say im playing my match and we are an hour and a half in and my phone goes dead. unless I am activiely saving all info on the phone every time a change is made, I I lose everything because it was just stored in memory. I need a way to store it locally before it updates to the server when told to do so.
Ok so now I'm back to where I started. What kind of file should I save it as so I can have a smooth transition into a database or sql server? do i save it as a spreadsheet then upload the info from it to a database or am i better of with a text document or is there anyway to save it straight to a database file then upload the databse file to another database file and have it merge with it? kinda lost on how to get the two files to merge.