One page + CMS. What is the best way to implement it in terms of SEO-friendly and performance?

Question

PHP

Let's say there is a site on 1-5 pages.
It is necessary to add the ability to upload news there. The news format is fixed (1 picture and a certain amount of text. I want to implement it like this:
Add an admin page to the server that will have access to the database with the ability to upload the content of the update added through the standard form of this page (a field for uploading an image and a field for text input) and generate a separate html file with this news and add a link to this news on the "news archive" page. Further, on the site itself, the javascript will receive data from the database upon loading and load the latest news on the main page in a compressed version with a link to the full news, which is in a separate file, previously created
... This is how I see it.
Is it correct to implement it this way?
It is important to create such an option that will work with all sites, without changing their internal structure for this "mini-CMS". I threw the code on any server with a one-pager that can read the database and everything works.
It's also important to keep the site fast and nimble, so no heavy plugins.
The site should also be loved by search engines, so I want to know how they will react to the fact that the contents of the main page will change periodically. Should I disable indexing of added content on the main page to avoid the problem of duplicate content?

Answer 1

Something you got ahead of your time.
You don't have to worry about performance at all. There is no load in your scenario, even though you will have a thousand news.
If sites in PHP have not been written before, then it would be more correct to take a small CMS focused on business cards, everything will be ok.
If you want to do it yourself, then almost everything that you wrote regarding the operation of the site is not correct. Either not at all in the subject, or you want to invent something terrible.
This is a perversion. Store data in a database or files. Pull data from there using PHP and insert it into the pages of the site dynamically. No need to generate static.
Javascript cannot access the database from the browser. He can create an HTTP request to the server, which will process PHP, which will already access the database and give JS what it wanted. They do it this way, it's called AJAX, but it's not at all for the purposes you want to do it. You just need to display the news on the main page, no JS is needed for this.
Millions of sites change the main page - this is the norm.

Answer 2

In general, it is not very correct to load java-script elements, in general, on the site from the point of view of seo. is due to the fact that Yandex does not index java-script well. Also interested in the purpose of this site?
It will be, say, your site for services or an online store. If an online store, then look, for example, my website greemvas.ru/. It is highly specialized and indexed well.

Answer 3

Generate an RSS feed from the database and display it on the page already.
At the same time, for SEO, it is the same (RSS feed) - it will suit you.
And for users (for subscription) - once again it will do.
General structure:
[AnySite]->Parser->Cache(IN)->DB->Cache(OUT)->RSS->Template (+pagination)
DB - not necessarily mysql: file storage can also be made.