[Opinion] Free Database?

Hi:

Can you inform me, in your opinion, the best free (no cost) database to use?

The goal is to have a database that is able to synchronize data between users!

Thank you.

1 Like

How about Firebase :firebase: ? Maybe it is not the best choice for a database for some users, at least it can store data and it is free (with the limit).

6 Likes

Firebase Irmão, é gratuito e tem planos pagos também.

1 Like

yusufcihan: thank you :wink:
leo_hominis: obrigado, um abraço :wink:

You can use airtable spreadsheet too :blush:

1 Like

Hi Friend My self Ritik From India,
I have my app in Google Play Store in which there are about more thank 300k+ Downloads and more than 150k active users but my friend I want tell you that Firebase is not Good because the reason is that it is very slow. And when the data added to the firebase by the user its becoming slow day by day because of high data and also some time app crays and you know users hate that thing but my friend do no become unhappy there is one solution from Kodular and the solution is AIRTABLE I do not have word to express my feeling about AIRTABLE because it is fastest data base is the Kodular App Builder. It as also api so that’s way your data base while never Hacked and also putting huge amount of data like about more than 500k+ data it never become slow.
And you will get in the FREE plan so. You can also upgrade your data base by paying some small amount.
I hope this Article Helps You.
Thank You.

1 Like

Hi vermajiappdeveloper:

Thank you for sharing your experience!

I really appreciate it!

It is possible to synchronize database with the several users with AirTable?

Big Hug

I have been used MariaDB, through an API in PHP and it works well, since the App just sends the arguments and the API does the job connecting database and executes the INSERTs, UPDATEs, DELETEs, etc.

3 Likes

Hi Kleyber_Derick:

Thank you for share!

It seems that MariaDB is totally free, what is good!

But, to use MariaDB I need to have a server, correct?
A server brings some costs… :frowning:

Hug

Yes, of course!!! In my case I develop apps to sell them to enterprises. If your intention is that, think that in a near future, the costs will be too low… if not, the other options are there… good luck!

4 Likes

Hello Kleyber,

Do you have any tutorial (step-by-step) to configure MariaDB and connect it to the app?
I don’t know php but to host my own DB sounds interesting…
Actually I aim to host at a home server if I can make it work.

If you want a too simple database, you should think about hosting your own TinyWebDB.

Pavitra (from Kodular Staff) has a repo on GitHub which is TinyWebDB’s Python version and can be installed on Heroku with one-click.

And you can use TinyWebDB connect to your database and store and get data.

However, TinyWebDB has less features when compared to other databases such as deleting tag method etc. So I’m trying to improve it with a brand new one. :sweat_smile:

4 Likes

Hi @guilhermemaracaipe,

To use MariaDB or MySQL or any other SQL based databases, is really necessary using PHP to create an API that will work between your app and database.

There is no any way to access a remote database directly using our app. The apps use an API to send the messages and the API do the rest (SELECT, INSERT, etc) and returns data to app in JSON.

1 Like

Excelent that you’re working on a new TibyWebDB @yusufcihan!
The TinyWebDB that exists today doesn’t fullfill my needs because there’s no supoort to tag list, there’s a workaround as @Hossein teached in another post but it’s just too much trouble to make it work properly.
Hope your new version can deal with it, would be a huge improvement to block programming have something like that!

1 Like

If you want your database work fast. Instead of creating lots of tags, try to create lots of buckets (when the application opens, it loads all the tags there are in the bucket and when there are a lot of tags in the bucket it takes a lot to load the device) and in each bucket you create a small number of tags

1 Like

Thank you for support!

I can even say it is almost finished, however, I’m trying to add more methods.

Yeah I hope too! :grin:

And since TinyWebDB is not only limited with App Inventor, you can even use it in every programming language with a simple URL POST call. So I believe TinyWebDB is can be useful for cross-platform apps too.

That’s why I like TinyWebDB!

How do you create a bucket in TinyWebDB? :thinking:

I meant a firebase

1 Like

airtable is slow in loading data it take more time when app make first after that it become smoth but firts request just hang the screen for more than 1 min

Agreed with you.firebase is very slow.i have 13000 tags with value.when app sent request for specific tag its takes to much time (1 to 3 min) to give value