Best database to use

Hey guys i want to make an app to store client info..

whats the best database to use?

--

the "best" local database is TinyDB... (there is only TinyDB)

or are you talking about server databases?

first do the tutorials http://appinventor.mit.edu/explore/ai2/tutorials.html to learn the basics of App Inventor, then try something and follow the

 Top 5 Tips: How to learn App Inventor

--

ok that seems good..but if i share my app then it will be limited..

i seen the component file.read up on it and seems what i need..

one question do when i write to file the file name can it be an ID?(auto increment type)

--

but if i share my app then it will be limited..

why? each user stores his data locally in TinyDB...

--

is there a limit?

cause i want it to store client info.

and in file saving how to i save multiple fields..not only one?is it possible?

--

All you need to know is here:

TinyDB

ABG's example    Build Your Own DB - Part 1   demonstrates filtering

Stephen's example    TinyDB - a persistent data solution

and here:

TinyDB

TinyDB is a non-visible component that stores data for an app.

Apps created with App Inventor are initialized each time they run: If an app sets the value of a variable and the user then quits the app, the value of that variable will not be remembered the next time the app is run. In contrast, TinyDB is a persistent data store for the app, that is, the data stored there will be available each time the app is run. An example might be a game that saves the high score and retrieves it each time the game is played.

Data items are strings stored under tags . To store a data item, you specify the tag it should be stored under. Subsequently, you can retrieve the data that was stored under a given tag.

There is only one data store per app. Even if you have multiple TinyDB components, they will use the same data store. To get the effect of separate stores, use different keys. Also each app has its own data store. You cannot use TinyDB to pass data between two different apps on the phone, although you canuse TinyDb to shares data between the different screens of a multi-screen app.

When you are developing apps using the AI Companion, all the apps using that companion will share the same TinyDb. That sharing will disappear once the apps are packaged. But, during development, you should be careful to clear the TinyDb each time you start working on a new app.

Properties

none

Events

none

Methods

ClearAll()

Clear the entire data store

ClearTag(text tag)

Clear the entry with the given tag

any GetTags()

Return a list of all the tags in the data store




any GetValue(text tag, any valueIfTagNotThere)

Retrieve the value stored under the given tag. If there's no such tag, then return valueIfTagNotThere.




StoreValue(text tag, any valueToStore)

Store the given value under the given tag. The storage persists on the phone when the app is restarted.

If you do not understand this information then please do the following:

MITs tutorials http://appinventor.mit.edu/explore/ai2/tutorials.html

AI2 free online eBook http://appinventor.mit.edu/explore/ai2/tutorials.html   ... the links are at the bottom of the Web page. It teaches you how to program with AI2 Blocks.

Only YOU can determine whether AI2 and the TinyDB is suitable for your use.   Can you loose data in this type of database.   Yes, certainly.  How secure is partially dependent on how you code this and how you use it.

Still uncertain?  Read the terms of use: http://ai2.appinventor.mit.edu/about/termsofservice.html 

Still uncertain, don't program yourself; hire a programmer.

--

great guys thx!i will test it out.

--