Choosing a database

[jojobeerten (Joris Beerten)]

Hi there,

I’m looking for an online database to store some data.
I’m creating an app to calculate paramaters for machining metal, plastics etc.
The database consists of at least 2 tables. Category and product details. The tables are linked by ID’s. I’d like the ability to expend the database in order to create users, usergroups and machines. These tables will be linked, so something “select from table x and y where x.id=y.id”.
I’m familiar with MySQLi and PHP.
Storing images online is required as well. Preferable in the database.

Self hosting a database, be it MySQL or a textfile is possible but I prefer an online service for what I hope is easier to use.

Which online database comes in handy? Any suggestions on would to choose? Are there any limitations on storage capacity? Keep in mind images must be stored as well.

Jojo

[Rogerio_Rios (Professional Support)]

Mysql or PostgreSQL.
But, You will find many hosts that already offer mysql.
Then you can use MySQL. Don’t worry about storage capacity.

[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…

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 :

[jojobeerten (Joris Beerten)]

Thnx for the reply. I’ll dive in to this.

[_FTTX (Ali Abo Wardi 0 iraq)]

What do you think about fire database it is excellent for your project

[Still-learning (1-2-3-4...)]

@jojobeerten

The database consists of at least 2 tables.

Then in simple you can use googlesheet as database. Limited blocks, fast response… first try with MySQL after then try googlesheet