Want to know about MySQL

[Vinaba_Jadeja]

Hello all,
I store my app’s data in Airtable Spreadsheet but before some days, I watched a video online which describe about how to use MySQL in Kodular Except then Airtable or Firebase.
My Question is: I Have lots of data to show and Airtable is little slow to load data. So Is MySQL loads Data Fast then Airtable or Firebase?

[Meghraj_Singh (Meghraj Singh Beniwal)]

Slowness in loading the data depends on how you are fetching the data, as it’s always recommended to get data in pieces like 10 rows at once and then next 10 rows and so on so that your users won’t see any freeze or glitch on the screen.

With MySQL definitely you won’t have the restriction on number or rows or number of queries per month or so.

Few other users also complained about firebase becomes costly when users are growing and they fetch data on daily basis then your bandwidth uses will grow and firebase will start charging you.

[Vinaba_Jadeja]

Thanks For your valueble information.

[Rogerio_Rios]

This Maybe help you …

Reducing Firebase Realtime Database cost

Think of it this way: relational databases (mysql, oracle, sql-server etc.) you have millions of search sources. Any subject, from beginner to expert … Mysql is free. Almost every hosting site offers this database. You will have to learn how to design your bank. Study concepts of tables, rows, columns, primary keys, foreign keys, triggers, stored procedures … and the relationship between tables … But you can store many many many … records in your tables … free

And This…

[Opinion] Free Database?

Use mysql / mariadb with php scripts. My first test I did with the help of @Kleyber_Derick and I used a database of more than 100,000 records. This query in the database was made with Join in 4 tables. The data appears instantly. I also send the parameters to the script and the Scripts I create works with Insert, Select, Update and Delete on the server. And as I already mentioned, Mysql / Mariadb have thousands of research sources. They also use the SQL language (DML and DDL) which is used dir…

[Rogerio_Rios]

A little more …

Which Server should I Use?

Mysql. It is an established database. With lots of research material. It works with SQL language, which is a language with a lot of research material. So you have stability, robustness and research material. Free. Imagine who bought it? ORACLE. The giant ORACLE. Who use Mysql :

[Meghraj_Singh (Meghraj Singh Beniwal)]

I would like to tag @Point here, He recently switched from Firebase to MySQL and can give more accurate points on what is working well for him, what are the troubles with MySQL.

[ShaikhSajidAli (Muhammed Sajid Ali)]

Mysql with best server and wrapped with redis will give you best performance and 70% faster than airtable and firebase