Basic Understanding of CloudDB (and using Lists to store and manipulate data)

[Sebastian_Gaster]

Hi there,

thank you for reading my lines and please be gentle in case I missed the threads or docs where all my questions might be answered. I didn't find them. If you know them, I'd be glad to study them.

Now, can I save a table of x lines and y columns?
E.g., if I wanted to save a shopping list, with values of "What Item", "Where To Buy", "Must Be Bought (Yes/No)", how could I do this? Will I have to join these three values into one value?
If I put "What Item" in one tag, "Where" in a second and "Y/N" in another, are they still connected in a way? How could I sort or e.g. just show items that must be bought?

I do neither expect nor want to get a complete tutorial, but hopefully u see where my lack of knowledge is and give me a hint where to go...

thanks

[Patryk_F]

In AppInventor, you have lists and dictionaries that you can save to CloudDB. There are also different blocks with which you can process lists or dictionaries.

FAQ Section: CloudDB

CloudDB Blocks Help CloudDB Pizza Party remix - TimAI2 HOWTO: Setup a Local Redis Server for CloudDB - TimAI2 Redislabs account config in AI2 - TimAI2 HOWTO Setup Redis with SSL for CloudDB with AI2

[TIMAI2]

Also

CloudDB and Lists

Hi. I'm developing an application that uses CloudDB. in a class tag, there is a list which has a list as well. each element of the "class" tag is a list whose first index is the name of the room and the rest of the elements include a list of first and last names for each student in the room. I would like to allow admins to add students. but I can't seem to add values ​​inside lists by cloudDB. I thought of the "Store Value" block but if 2 admins add a user at the same time there will be loss …

[Sebastian_Gaster]

Hey, so dictionaries seem to be what I was lookin for
Haven't even seen them before, omg. I'll take a look and hopefully get what I wanted.
Thank you for your fast reply!

[SteveJG]

Welcome Sebastian.

Is this what you want to do

The csv is what,where,status\nboat,ocean,true\nairplane,sky,false\ntruck,road,true

Store the data as a List is one way to handle your database. when using a nonSQL database like a CloudDB

[Sebastian_Gaster]

Woot! Another way to do it, where I was afraid that there isn't any at all
On 1st sight, working with csv's looks even easier than with dictionaries, but I'll take a look at both.
Thank you very much!
Have a brilliant weekend all of you!