Database solution with web interface. What do you advise?

Question

CMS

Hello!
There is a task that, rather, I have set for myself, but I am determined to implement it.
I value opinions and suggestions on solutions.
(I apologize in advance if I show incompetence somewhere, but you still can’t solder a capacitor with a Swiss knife.)
The task is not very difficult for the pros, but in some matters I swim, and in others I don’t.
So. There is a need to create a simple database from a small number of tables (up to 5). Records in tables can be from hundreds to hundreds of thousands (if everything works out). I would like to put the base on a closed server, but a separate gateway must necessarily provide access from the network.
If you do not bother with security, you can probably take a very simple solution (Mysql & php), probably. but this project will subsequently need to be transferred to a more serious solution. And now attention to the question (s):
1. What DBMS would you recommend (to make it easier with porting and scaling data)?
2. What framework would you recommend to get interested in? (I hope I have not forgotten how to program, although in many ways, I will have to learn new languages)
3. Is there any other solution that is easy to use but no less effective and productive?
Thanks in advance for advice and comments.

Answer 1

And what is special about your task that you have written so much?
Answers to these questions can be found easily and there are already tens of thousands of them, try searching - "Recommend a subd", "Recommend a php framework" and so on.
When I read the text, I had a feeling that you have a super idea that needs an original approach!

Answer 2

Maybe it's easier to use the ready-made - basebear.com/?
Or similar. There are dozens of such services.

Answer 3

If you don't care about security

You do not have such a right, take it as the original. The user is always lying, this is the law.
DB for porting... hmm... why?
At the expense of scaling - everything depends on the structure of your data. For data in the form of documents, look towards mongodb, it knows how to shard out of the box. For tabular - mysql / postgresql, here the scaling is selected according to how the data is used: if the master-slave scheme is mainly for reading and rarely for writing, sometimes separate databases are taken out on separate hardware.
When

Records in tables can be from hundreds to hundreds of thousands

I doubt very much that you will need to bother with scaling.
By the way, you did not pay attention to very important metrics:
- fault tolerance
- complexity of recovery after failures
It depends on the tasks, but as a general framework, I recommend Symfony.
You didn’t state the task, what could be the solution?)) A database with a web interface is almost any non-static site, but besides that, there is also business logic.

Answer 4

DB with web interface:
October CMS (on Laravel) or
Bolt CMS (simpler)

Answer 5

The task that you set, as mentioned above, does not differ from thousands of typical ones.
The first point without citing your quote, solve problems as they come up, as an example, the creators of basecamp gave a month for free, and by the very launch they didn’t take time to develop a payment system, because they knew that they would have a month to develop it. This is by the time about the loads that you do not have.
Second)

If you do not bother with security, you can probably take a very simple solution (Mysql & php), probably. but this project will subsequently need to be transferred to a more serious solution.

I don't know what you mean by the concept of security, but what php and mysql deserved your stigma - frivolous decisions, it's not clear to me.
third paragraph)

I hope I have not forgotten how to program, although in many ways, I will have to learn new languages

And here new languages, as it was said in the first answer, your project does not have unique requirements, and therefore does not require sophisticated solutions. Write on what you can otherwise ignorance of the features eliminates all theoretical advantages.
Fourth, based on the comment)

4. in order to do the job, as Evgeny Perin recommends, there is not enough time (it will be necessary to master and write practically from scratch. with "Helo World!"
) performance, but so far.), in terms of security and in terms of scalability.
6. I will explain my diamond interest. management is unwilling (perhaps unable) to spend big money on a big project. therefore, I want to start doing with a simple one, and after the minimum functionality is launched, knock out the stock.

It is not entirely clear how you plan to write a project if you need to learn php and mysql from scratch. For 5, see the first paragraph. By 6, you yourself do not catch the paradox that either you are solving security and scalability problems, or you want to make the minimum functionality in order to get money for implementation?

Answer 6

I recommend Oracle XE + Oracle APEX . You get a completely free solution with most of the benefits of Oracle DBMS (reliability, performance, functionality, etc.).
Learning how to make web applications on Oracle APEX is really possible in two days, they even have a guide called 2 Day + Application Express Developer's Guide , where the basics of development on APEX are chewed step by step.
If you are making an intracorporate system, then this, in my opinion, is the ideal solution. If it should be an external site with all the troubles of SEO optimization, then there may be some difficulties (but they can be solved, if anything - contact me, I am working on the 1apex.ru project dedicated to solving these difficulties).