How to properly structure the database for a large catalog of product descriptions?

Question

Database design

Good day. It is planned to develop a large online catalog of product descriptions, in which theoretically there will be 5-10 million descriptions and I want to initially design the correct structure. The admin panel will be written on nodejs + vue. There are several questions:
1. What is better to use? I have experience with MongoBD, but for large projects it is recommended to use relational databases, maybe MariaDB is better then?
2. How to make the structure correctly in order to get the maximum profit in terms of speed? It is planned to make separate collections/tables for categories, specifications, values ​​for these specifications, products, so that eventually you can create a product, select a category in it, and after selecting a category, the specifications available for this category should be displayed in the product card so that the editor can fill in with your hands what applies specifically to this product.
Please help me figure out which collections / tables I initially need and what needs to be connected.

Answer 1

Any modern relational database will do, but I would recommend postgresql
And for everything else, read this book, you will learn a lot of useful
"Programming SQL databases. Common errors and their elimination" Author Bill Karvin