Which software is best suited for creating a site with a large amount of data?

Question

Design

Good day to all!
Today I am on your site for the first time as a registered user! Probably, everyone had problems at the beginning of using it here ... Sometimes I turned here when search engines referred here at a time when there was still habrahabr.
I want to create a website. The amount of data is large, the direction of the site will be more informative, so it will be in several languages.
Domain purchased. All tables and almost all modes: adding, deleting, viewing tried and checked on MS Access. Yes, a little funny, and here Access and web technology. We just use this application at work and with a small volume at local workplaces everything is ok with it! Now I wanted all this farming from local to web. Once tried on php+MySql. Php did not like it - there is no breakpoint function - program tracking (debugger), all the time “echo”, also here I could not build a key to search for data, only using “Select”, and this does not give a good result in the future when the site will be in full swing.
Some have recommended PhpStorm, some have praised Python, but what about Java?
In short, a question for EVERYONE! Which programming language and which database is better suited here? So that there is a program tracking (debugger) and there will be no problems with the amount of data in the future (building a key for searching, encoding text for different languages). Thank you all in advance.

Answer 1

Any server-side programming language and, in principle, any database. In Phpstorm you can use breakpoint, no problem.
When choosing a PL and a database at the very beginning, everyone relies on their preferences. I'm not sure if you have really large amounts of data (until there is at least 1Tb and a billion records), so I will say that php + mysql is a pretty classic easy start. There is a bunch of node + mongo, but you can get a little lost in asynchrony, although it is good, of course.
Compiled programming languages ​​for a beginner are much more difficult, but the choice is undoubtedly yours.

Answer 2

Python + PostgreSQL

Answer 3

Some PhpStorm recommended,

It's a development environment, not a language. PHP development environment. Usually in conjunction with MySQL.
1) Low threshold of entry (at the initial stage easy to learn)
2) Well suited for web development, many ready-made modules and components, a lot of documentation and a large community.
3) The standard for any hosting - almost all hosters have a LAMP stack
4) There are at least 4 very well supported frameworks that allow you to quickly create the basis of an application.
5) Good scalability.
6) The debugger is quite normal, like any other language, the fact that you have not figured it out is another matter.
1) It's "not fashionable", colleagues with vapes on hoverboards will laugh, "because there is go, rast, noda after all"...
2) the speed of work is uncritically lower than comparable python and node (it should be borne in mind that, as always, the speed of a web application most often rests on the speed of data exchange with the client + the speed of the database, PL usually does not carry any special loads).

someone praises - Python,

well, yes, there is even 1 popular framework ... A very good and relatively young PL, but so far it is still rarer on the web, which means there is a certain shortage of specialists.

what about Java?

Java is a separate world, mainly focused on enterprise solutions, although, of course, they just saw sites on it, yes, but this is more exotic than the rule.

In short, a question for EVERYONE! Which programming language and which database is better suited here?

At the root of the question you have a "large amount of data", but what kind of data, what real volumes (at least approximately in the number of records) and what type (mostly text / mostly digital data / mixed content) are not indicated. In any case, I would focus on the capabilities of the database, and not the PL.

To be there program tracking (debugger)

Any modern language has debugging tools, search and find.

and in the future there were no problems with the amount of data (building a search key, encoding text for different languages).

Any modern database. Again - you need to select based on the structure and real volumes, if there was a single universal solution, everyone would use it, obviously. For each case there is a tool and a suitable solution.