?
Solved

Storing Data (Database or Local)

Posted on 2014-12-15
5
Medium Priority
?
226 Views
Last Modified: 2014-12-16
Hi, i am in the process of building a small app for a charity swim.

It is a very simple app that allows the participants to enter in their training records each day, in the build up to the race day. They will be training for 12 weeks in total, and the app will allow them to enter in the following each day:

01 - DISTANCE
02 - TIME


I am trying to decide if i should get the users to sign up and store their information in a database, OR if i should just allow them to use the app straight away, and then store all of their info within the app.

If i didn't add the Sign Up and database feature, the app data would load quicker etc, however if the person loses their phone, they will have no way to recall the data that they built up within the app.

Can anyone offer any advice on this, should i store to a database or internally? Is there any other pros / cons to either option? Thanks in advance for your help.
0
Comment
Question by:oo7ml
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
Kimputer earned 1100 total points
ID: 40500210
Local:

pros: always available data (no need for internet), can use backup routine (on internal memory or cloud), so it can be restored on another phone. can be shared using this backup/restore routine (save to dropbox, share dropbox link)
app testing is much easier.
cons: other ppl can't see this data quickly (if data needs to be shared). if forgot to make backup (and store somewhere else), data could be lost forever)

Database:

pros: if needed, can be easily shared. Even if not shared, more devices can get the data (person can use browser on the PC, or tablet, or other phone)
if app based on webview, app doesn't need to be updated that often, the web server/front end update will be enough.

cons: no internet = no db connection.
need investment (db / website programming, website hosting, security audit, backup routines)
need database/web programming expertise (instead of just app building)
0
 

Author Comment

by:oo7ml
ID: 40500285
Thanks, considering the app will only be used for 12 weeks
0
 
LVL 28

Assisted Solution

by:dpearson
dpearson earned 900 total points
ID: 40502027
I think for this sort of app you should store the data on the phone itself.

In the event of the phone being lost, modern phones all support ways to recover app data via their online backup services.  For iOS this is iCloud and for Android there's an Android backup service.

I know for Android this can be triggered by the app itself:
http://developer.android.com/guide/topics/data/backup.html
and it likely can be for iCloud too (http://support.apple.com/kb/PH12519?viewlocale=en_US), if you want to ensure all of the data is backed up to the cloud as soon as possible.

Even without any explicit work, the data should be backed up with 24 hours - assuming the user connects their phone to a Wifi network.

Doug
0
 

Author Comment

by:oo7ml
ID: 40502270
Ok great, thanks.

I'll look into those.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The Super Bowl is just days away. Millions of advertising dollars will be spent in just a few hours to drive people to websites around the globe. Optimizing your site in anticipation of a big event like this (and the traffic surges that follow) will…
Today, unlike web development, the mobile landscape is complex enough for a software engineer and Android is posing more challenging environment thanks to its fragmentation issues on hardware and software fronts.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question