What technical solution to choose to create a website?

Question

CMS

Good afternoon, dear colleagues!
It is planned to develop a specialized website for the operational activities of a construction and engineering company.
Simplified activity looks like this:

• design users create and maintain a catalog of Building objects (1M+ objects)
  
• Inspector users create and maintain a Register of Scheduled Site Inspections (10M+ jobs)
  
• average number of active users at peak 1000+
  

I ask you to suggest, on the basis of what technical parameters it would be better to develop a site that can sustainably support the specified functionality? What parameters need to be determined in advance and once and for all, so as not to come to the need for a global rework over time?
And question number 2 - what would you advise: ordering a site from scratch or focusing on finalizing the online store template is suitable - after all, you can find a template with the implementation of personal user accounts and catalogs of objects, adjusting them to the goals of the task?
By technical parameters, I mean a reasonable set of solutions, including a technology stack, CMS, type of DBMS, design options, applicability of templates, as well as ranges of terms and costs for developing a turnkey project + your invaluable experience in implementing such projects.
Thank you all in advance and any comments and possible links would be greatly appreciated!

Answer 1

Since I faced similar tasks, I’ll say right away that you need to write a system ready for horizontal scaling.
Throw ready-made CMS and other husks out of your head right away, when you put objects in the base under the lam objects, you will start heating the oven with money to ensure the proper level of response.
The base should be taken from SQL, starting with mysql and the initial setup of multimaster sharding + replication + failover. Here it is a very long time to sit over the analysis of the documentation, search by parameters, etc. At the initial stage, this is not required, but then it often results in hemorrhoids.
On the backend, you should take Go (Gorm for working with the base). It is easy to deploy and simply scales with the help of primitive balancing.
Store construction documentation and pictures immediately in an S3-like storage.
Take the latest AngularJS for the frontend. You can play with Vue, but then you still have to rewrite it.
For such work, you will need the following specialists: a designer (freelancer), a devops person (tested, remotely), 2 full-time programmers (frontend + backend) (they can also work remotely) and a project manager (technical director).
Do not save on specialists, otherwise you will get unusable shit.
Don't think of such a system as a website. You need a web application.

Answer 2

For modern DBMS, your 10 million objects and 1000 people (presumably they will not work simultaneously with all 10 million objects - just a ridiculous load.
Of course, a novice programmer can kill this with the wrong architecture.
But in general - the load is so-so.
Any the most conventional technologies are suitable, what the end performer knows best - from MySQL + PHP to 1C + PostgreSQL

Answer 3

1. Never cross the main base of objects with CMS! There should be integration by ID-shnikam.
2. Choose a convenient, flexible and large community CMS. (I would choose CMS Joomla!)
3.

And question number 2 - what would you advise: ordering a site from scratch or focusing on finalizing the online store template is suitable - after all, you can find a template with the implementation of personal user accounts and catalogs of objects, adjusting them to the goals of the task?

This is what infuriates the most ...
Understand: THE WEBSITE IS NOT A TEMPLATE!
Each project is UNIQUE!
ONLY from ZERO!
4. Cost and terms - after TK (paid separately), TK - after FT.
(TOR - terms of reference, FT - functional requirements)
stages of creating a site, etc.

Answer 4

With these options:

designer users create and maintain a catalog of Construction objects (1M+ objects)
inspector users create and maintain a register of Scheduled inspections of objects (10M+ works)

there can be no talk of any ready-made system.
Here I have two options:
1) Or you would overestimate your strengths, and you will never have this. For CMS norms.
2) Either it will, but then the question of extensibility / monetization will arise, and any CMS will die from wishlists.
Not to mention the fact that some kind of VP or something similar will be stupidly hacked from you.
With such site parameters, there will be good traffic and the desire to "break" your site will increase significantly.

Answer 5

Bitrix Enterprise + agency with experience in implementing such a project. The cheapest option.