What databases to use in php sites?

Question

Database

Hello! For the past 10 years I've just been having fun with websites and different languages. For a long time I looked in the direction of mastering the bases, but did not dare. It got to the point that I can no longer use ready-made engines, and I already tried to make up static pages, I didn’t like it ...

The essence of the question: I asked a question in groups about databases, I was advised to read about NoSQL databases, I liked the idea, but While I was reading, I got lost in the options. Liked MariaDB.

I would like to keep some data in the databases:
MOTHER:
- - - Socket
- - - m.2 = 1
- - - ddr

CPU:
- - - Socket
- - - Frequency
- - - HT = 1

1) I want to display a couple of inputs on the page with dependencies:
If the mother socket is selected, then:
- - - display a list with the corresponding socket in the processor combobox

2) Create a page with a simple addition of content to the databases:
- - - Add CPU > Socket, frequency, ht, cores, etc. "Save" > add to the database
- - - Similarly with deleting data.

Which database is the best fit? I would like to use it in conjunction with PHP, but something simple, because. there will be not much data in this project - then complex databases are not needed. Please advise any solutions. Thank you in advance!

Answer 1

For the volume of your data, the easiest thing to do, I think, is to start with an sqlite database at all. It is built into PHP by default and for a general understanding of sql it will do. Simple.

Answer 2

For the past 10 years I've just been having fun with websites and different languages. For a long time I looked in the direction of mastering the bases, but did not dare.

Err, 10 years of development without databases? It's wine, I think...

Liked MariaDB.

It's a fork of Mysql if anything...

Which database is the best fit?

Any. The main choice for beginners is MySQL (MariaDB), considered the de facto standard, available on almost all hosting sites, a lot of information on the topic, a wide community.

Answer 3

Purely in theory, you can try slight - no installation.

Answer 4

Most hosting providers offer PHP+MySQL(MariaDB) bundle. It's the combination of the most popular backend language and the easiest base to learn. How you missed this in 10 years, I'm even afraid to imagine ...
Plus, such a set is in sufficient flexibility - you can build everything that your imagination and skill are enough for, and a large, if not gigantic community. The answer to almost any question is Googled in 5 minutes. The main thing is to formulate the question correctly...
And on a shared hosting, everything is usually already installed. And the base is created from the control panel interface.

Answer 5

MySQL, PHP PDO

Answer 6

MySQL, Mariadb, Mongodb - all of these are certainly excellent tools, it is pointless to criticize and compare them, each has its pros and cons, just like PostgreSQL. But, using PostgreSQL, you get both normal data storage in json and the creation of normal indexes. You are also lagging behind a relational database, with support for full-text search of the level of leading solutions on the market. In a word, more powerful and more advanced - here you already need to look.