Choice of technologies for a large portal?

Question

Web development

I want to create a large information portal with several million static generated pages from the existing database (the database is linear, it contains 4k rows and about 30 columns, while in .csv format). The architecture will be built in such a way that the data from the database will be combined and displayed depending on the type of page. In general, the output should be something like a structured directory.

We need the ability to easily and quickly manage all custom content areas through the admin panel.

I would like to ask questions about technologies on which this idea can be implemented optimally and with less load (I will not do all this myself, but look for performers).

1. What type of server to choose apache or nginx?
2. What database to use for optimal and uninterrupted operation, do you need database caching?
3. What technologies should be used for the back part of the project (data output logic, database queries)?
4. How and on what is it better to write an admin panel (or are there ready-made solutions / frameworks)?

Thanks in advance!

Answer 1

And let's decide

several million static generated pages

or

easily and quickly manage all custom content areas

no, you can, of course, do it, but even as an architect I wouldn’t bother with it. A project with a constant update of statics is almost a dead end because it leads to a cyclical update of resources and you still have to insert some kind of dynamics. Yes, the same filters, pagination and much more.
But in general

1. What type of server to choose apache or nginx?

no difference

2. What database to use for optimal and uninterrupted operation, do you need database caching?

uninterrupted operation is about fault tolerance. You are here in the clouds rather. And caching - what, where and when is still impossible to say

3. What technologies should be used for the back part of the project (data output logic, database queries)?

So do you do statics or dynamics?) Statodynamics is a sport for bodybuilders. But seriously, it doesn't matter at all.

4. How and on what is it better to write an admin panel (or are there ready-made solutions / frameworks)?

Again, it doesn't matter

Answer 2

At the discretion of the performer.

Answer 3

I would do it on any engine that generates static versions of pages, that is, on any CMS. You can use Headless CMS + newfangled Gatsby to generate statics.

Answer 4

Apache + SSI + some PHP
Starting a new startup