Request for direction regarding data storage/structure

I'm looking to create an app to store scores etc I'm happy to work through lots of worked examples and in principle I like the App inventor but if anyone can share their thoughts on a best route to take, that would be much appreciated as I can then focus on this rather than trying to learn everything before making a start.

Imagine wanting to store scores from a ten pin bowling competition.
Its likely the device (most likely a phone) won't be online during the storing of the data as signals are unlikely inside the building and wifi is not always available.

You'd want to store ball by ball and frame by frame scores for an unlimited number of bowlers and then potentially be able to look back at stats after the event.

Ideally, be able to store games indefinitely and compare scores as time progresses.

Now TinyDB seems too simplistic for this to me from what I've read - but am I writing it off too easily. Does anyone have any details on more complex uses of TinyDB that I could look at to see how I might use this.

FusionTables sound more likely an answer, but do I need constant online access and can I easily distribute an app for users to use their own FusionTables (ideally without having to know anything about them) or do all users have to link back to my table. I believe that using O Auth the former can be achieved, but does it result in an app that a user simply asks to install in the play store and just has to give agreement to the various access rights or is there more involved.

Any thoughts welcome

BTW the actual planned app isn't for bowling but its a more useful analogy to ask the question

--

TinyDB can store not only simple text as values, but also lists and list of lists...

just take a look at how to work with lists of lists...

How to work with List of Lists

--

Many thanks - I generally follow the page you linked to - but without an example of storing data in 'lists of lists' I must admit I find it hard to see how you can replicate a larger scale database

For example how would you structure a two person game, with 3 rounds, ten frames in a round and up to 21 balls bowled for each person per round
In a very simple spreadsheet you could store it thus:

...... etc

Somehow I'm just not seeing how this would fit in a structured way in multi layered lists. I'm hoping it's straight forward and I'm just being thick, because this would definitely mitigate the lack of connectivity.
Although is there a finite list length and can you easily export the data into a csv or similar to archive it etc.

--

--

alternatively you can add another dimension for the player,

in the example I just use a list of lists for each player...

zog.aia

--

Wow that really helps, many thanks - I'll have a play and make sure I can populate and read back the data ok.
A perfect example, thanks again--

Thanks grate job.

How can I create it from a csv file?

--

just use the list from csv table block to convert it into a list of lists

--

Thanks I will try.

--

this is bad? I cant stock here. (and is the beginning haha)

--
That won't work... You're getting a list back from the CSV conversion, so you have to set the Label1.Text to the first element of the list, not the whole list.

--

Hi thanks Enis for yours comments.

I visit your website, grate job.!!

I made this 

to read this (in csv format file)

   

and what it shows is this in the label (the hole data base)

((id;name;surname;pohne)(1;aaa;xxx;456)(2;eee;yyy;789)(3;iii;zzz;112))

so:

what I  want is to look from a particular id the hole row. How can i do that...

--

set global name to list from csv table get text

then use a for each in list loop and check the first item in each sublist for the id you are looking for

if you found it, then display the 2nd, 3rd and 4th item of the sublist as result

--
Thanks so much It works Grate!!!

I'm continue with the app !!! 

--