What are the popular types of data exchange and storage for the site?

Question

Database

Tell me, I'm starting to work with the database.
Worked only with SQL.
What are the popular and relevant data storage resources, their names?
Heard about the rabbit, what else is there? Not familiar with this at all.
What should be used for projects in 2020?
While I use mysql, in the same place I create tables, fields.
And I'm already linking the site through php.
For example, Bitrix - what kind of exchange does it have and what kind of base is used there?
Advise what to read in order to avoid the fog in my head :)

Answer 1

To avoid fog in your head, you need to talk not about abstract bases, but about a specific project.
If you start working with a database, then just understand mysql until you are confident in using it. There are many projects that mysql is enough for.
There is no point in galloping across Europe without mastering at least one instrument. All SQL databases for a beginner are more or less similar.
Nosql databases are needed for other data types.

Answer 2

While I use mysql, in the same place I create tables, fields.

Forget about everything else, and deal with mysql.
so that you can confidently use it without "fog in your head". Read and understand what relational databases, orm are, how to properly plan the architecture of tables, indexes, different types of columns, and so on, all using mysql as an example.
then look at what else is around, what database is used in Bitrix, and what is relevant in the current 2024.

Answer 3

On the server side use MySQL, on the client side use IndexDB.

Answer 4

Heard about the rabbit, what else is there

RabbitMQ? This is generally from a different opera ... Exactly what I heard the ringing ...

What should be used for projects in 2020?

the same as in 2015-2019, there were no cardinal changes, except that the versions came out fresher ...

For example Bitrix

Bad example, but not the point...

- what kind of exchange does he have and what kind of base is used there?

here, a person is too lazy to drive 2 words into a search engine... https://training.bitrix24.com/support/training/cou...

Advise what to read in order to avoid fog in the head

There are special preparations for fog... And so - in each project there is a concept of architecture and structure, well, preferences depending on the tasks can be very different, both in PL and in storage systems. It is foolish to advise something without knowing the task at hand ...