Extension. Get all TinyDB. Save TinyDB content to CloudDB

[Juan_Antonio]

• Using blocks we can read the entire TinyDB and save its content in a file, here is an example:
  https://community.appinventor.mit.edu/t/save-tinydb-to-file-and-clouddb-retrieve-the-information-from-clouddb-and-insert-it-into-tinydb/42920

• Here we are going to use an extension to get the content of a TinyDB in JSON and CSV format. We can also load a TinyDB with the content of a text file in CSV format.

You can download the extension from:
http://kio4.com/appinventor/256_extension_tinydb_obtener.htm

1.- Get the content of a TinyDB in JSON and CSV format.

p256_Get_TinyDB.aia (10.8 KB)

Notice that each TinyDB has a different Namespace:

[Juan_Antonio]

2.- Copy the content of a csv file into a TinyDB.

p256_Get_TinyDB_v2.aia (11.3 KB)

• We have this file in the asset: africa.csv

Egipto,"El Cairo"
Argelia,"Argel"
Libia,"Trípoli"

• We want to load that content into TinyDB1 with Namespace: Tiny_ONE

• Using the File component we copy the africa.csv file into ASD, then we load its content into TinyDB1

[Juan_Antonio]

3.- Save a TinyDB in CloudDB. Get her back.

p256_Get_TinyDB_v3.aia (11.4 KB)

• We create a TinyDB and show its content using Button2.

• Through the Csv block we obtain the entire TinyDB and save all its content in CloudDB with the backup label.

• We delete the entire TinyDB using the ClearAll block.

• We press Button2 again to show its content and we observe that it is deleted.

• Press Button5 to obtain the content of the TinyDB stored in CloudDB and save it in the file: backup.txt

• We load the backup.txt file in the TinyDB with Namespace: Tiny_ONE

[Juan_Antonio]

4.- Upload and download file to FireBase.

Instead of saving the information in CloudDB, we can upload the backup.txt file to Firebase, for that we follow the tutorials of @TIMAI2

METRIC RAT AI2 - Firebase Demo: No Security with Web Component

[Juan_Antonio]

This format:

Egipto,"El Cairo"
Argelia,"Argel"
Libia,"Trípoli"

[Juan_Antonio]

Stress test

p256_Get_TinyDB_v2C.aia (12.0 KB)

Egipto,"El Cairo"
Argelia,"Argel"
Libia,"Tripoli"
Spanish,"Hola: el Ñandú corrió por Cádiz (España), y no alcanzó a la cigüeña."
Link,"https://ai2.metricrat.co.uk/guides/firebase-with-a-web-component/firebase-demo-no-security-with-web-component"
Chinese,"人是唯一被同一块石头绊倒两次的动物。"
Arab,"الإنسان هو الحيوان الوحيد الذي يتعثر مرتين بنفس الحجر."
Finés,"Ihminen on ainoa eläin, joka kompastui kahdesti samaan kiveen."
Tailandés,"มนุษย์เป็นสัตว์ชนิดเดียวที่สะดุดหินก้อนเดียวกันถึงสองครั้ง"
Varios Caractéres,"Saludos: Hola_Adiós, 'Amigo', 3000$, 20%, Vinos: Williams & Humbert, 12/2=6, ¿Sí o no?"

[Juan_Antonio]

5.- Get all TinyDB using KIO4_Terminal.aix extension.

DEco_XML.aia (16.3 KB)

https://community.appinventor.mit.edu/t/using-linux-commands-in-app-inventor-extension/6469

[Carlos_Andre]

Does not work with lists!

[TIMAI2]

@Carlos_Andre

Does not work with lists!

It does.
You do not show your blocks for using the extension, or the outputs you are getting?

[Carlos_Andre]

[TIMAI2]

This

should be create empty list

Also

[Gorjeos]

Hello!
I'm new here, so I'd like to take this opportunity to say hello to everyone and thank you for the help you've given the rest of the community.
@TIMAI2 I'm having the same problem as @Carlos_Andre. I've tried what you mentioned, but it still doesn't work (I used the exact same example). I've tried other options, but nothing. I still get that error with the lists. Thanks in advance.

[TIMAI2]

You could try using the tinydb block - GetEntries?

Or there is a more up to date extension called etinydb ?

[Gorjeos]

Thank you so much for your quick response, TIMAI2. With GetEntries, I get the plain text, and with split, I can get to where I wanted, but I don't know if you intended me to use it that way. In any case, with the etinydb extension, I managed to do what I wanted. Thank you so much for your help, and sorry for my English.