Cloud dB limit and app inventor account after not using

[Hisham_Hafis]

I have made an app which uses clod dB so, i may not be using app inventor a long time but may still use the app. So, my doubt is that if we stop using app inventor, will it delete our account and stop cloud dB for us.
Also, how much data can cloud dB actually hold (max.)

[ChrisWard]

Hello Hisham

Your App Inventor Account will not be deleted. However, you might want to host your own copy of Cloud DB on your own Redis Server and thus have a secure connection.

There is an excellent guide on TimAI2's site:

https://sites.google.com/view/metricrat-ai2/guides/howto-setup-redis-server-with-ssl-for-use-with-ai2?authuser=0

I don't know what CloudDB's capacity is, I'll ask.

[ABG]

I once set up a free Redis account and server, for experimentation.
After I stopped using it for a few months, Redis started to nag me about not using it.
After more non-use by me, they deleted the free server instance.

You get what you pay for.

[Hisham_Hafis]

Can u pls show how to use spreadsheet to store and also get data
I have not used spreadsheet much and have doubts on how to get the data stored in it
And how to clear the spreadsheet

[ABG]

@Hisham_Hafis

Can u pls show how to use spreadsheet to store and also get data

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[GT-Game_and_Tech]

@Hisham_Hafis

Also, how much data can cloud dB actually hold (max.)

It is for experimental purposes only you cannot make a commercial app from that. It's good for personal use. If you want to make a commercial app, you can use redis server

[Hisham_Hafis]

How can we use got value and data changed also in spreadsheet.

[Hisham_Hafis]

Also, like in cloud dB we can get a specific data using tag, can we get/send data from/to a specific cell of the spreadsheet?

[ChrisWard]

Hi Hisham

Do you have your own website? If you do, TinyWebDB is another consideration.

Can you tell us the capacity your database needs to have?

Edit: In fact, we do not know what your App does - so we shouldn't be answering your random questions without that knowledge as DB systems are defined to suit different requirements. So that's where we need to start:

1. What does your App Do.
2. If it has multiple Users, how many?
3. What type of data needs to be stored-retrieved?
4. If more than one User, where in the world are they? This question is important because not all programs can handle right-to-left languages.

[ABG]

@Hisham_Hafis

can we get/send data from/to a specific cell of the spreadsheet?

A specific cell in a spreadsheet counts as a range, which has an easy Web GET, described in the FAQ I mentioned above.

Updating a cell requires more work, in other FAQ posts above.

[Hisham_Hafis]

I donot have my own website
•The app is a chat app but it also requires cloud for storing name,point, sending notification to users,etc

•Only some, maybe 5 or 6,as of now as it is not completed

•Chat data(list), and some datas like
tag-points value-250

•They mostly only speak using english letters

[ChrisWard]

• right, so Google Sheets would be good enough, but you may need to delete 'old' data (chats) on a regular basis.

[Hisham_Hafis]

@ChrisWard, Spreadsheet is harder than what I thought
I have been getting errors like this :Syntax Error - Unclosed quoted cell

And also @ABG and @TIMAI2 I can't understand how to use the the got value

So, can I just use the cloud dB, I thought of making the chatdata send to cloud dB temporary, that is the data will be stored long time only on tiny dB but a little in cloud
Then, will there be any problem

Or is there any understandable way of viewing the data easily in listview just like cloud dB because I'm new to reading spreadsheet in listview

In cloud dB we can easily store everything using tags , is there a similar way to do this in spreadsheet too?

[Hisham_Hafis]

@ChrisWard @TIMAI2 @ABG,

@GT-Game_and_Tech

you cannot make a commercial app from that. It's good for personal use.

I'm not making a commercial app
And very less amount of people (mostly 5 or 6) are using it, just for fun, testing it & chat

Very less amount of data may be stored because the I'm thinking of storing the chatdata in tiny dB itself.

So can I use cloud dB itself
Will it be possible
Because the app may have thousands of blocks and it takes a long time to replace blocks

[TIMAI2]

@Hisham_Hafis

So can I use cloud dB itself

You can, but:

1. You may run out of space (the MIT cloudDB files max out at 5mb)
2. Your data may be routinely wiped, without warning, by the server to recover space for other users
3. Connectivity may be slow or difficult at times of high usage

How do you create chat room with CloudDB?

I will like to create a chat room with CloudDB but will it be compulsory for those in the chat room to have the app ??

[Hisham_Hafis]

@TIMAI2

can, but:

1. You may run out of space (the MIT cloudDB files max out at 5mb)
2. Your data may be routinely wiped, without warning, by the server to recover space for other users

Thnx Tim, these are ok, I think I may need very less amount of data

Thanks to everyone for answering

[ChrisWard]

@Hisham_Hafis

I have been getting errors like this :Syntax Error - Unclosed quoted cell

You can have syntax errors in any form of code - that is simply mistakes being made by the Developer........

[GT-Game_and_Tech]

You can but I recommend to see through redis server