Which tool should I use to build a simple dynamic website in 2020?

I wrote https://wapp.tcl.tk/ for occasions such as this. SQLite is built-in, of course.

One key feature Wapp is that identical code can be run as

+ CGI from Apache

+ SCGI from Nginx

+ As its own stand-alone webserver

So, for development work on your desktop you run it as a standalone webserver. It even pops up its root page in your webbrowser automatically when you launch it. Then, once you get things working there, you "scp" the one small source-code file that implements your application up into a CGI-enabled directory of you server, and is just works.

For something like this PHP should be fine. While PHP might not be the best for modern applications, PHP 7 is quite the competent language, and if you're experienced with this stack it's probably your best bet.

What are you actually building though? Firebase might make this easy (zero devops, everything is done with JS client side and logins/passwords is a few lines of code) but it depends on what you're trying to do.

I would use Ruby/Rails.

I would recommend you use whatever you are most comfortable with since what you are describing is build-able in nearly any language/framework.

Without getting into what the personal use case is ... what you are describing could possibly be done with something like Google Sheets? It sounds like overkill to use a full on hosted custom built solution when it is 1-2 users updating a single table of rows of some kind of data.

If this is a personal use case and you want to learn a framework/language for web development then that's different.

Python + Flask[1] maybe?

Or, as far as that goes, for something as simple as what you're talking about, I don't see any particular reason not to just use PHP if you already know it.

If I were building this for myself, my first instinct would be to use Groovy + Grails, but if memory was a limiting factor, given that JVM apps can be a bit memory intensive, I'd probably go with either Python or PHP.

[1]: https://flask.palletsprojects.com/en/1.1.x/

PHP, Apache, MySQL (or MariaDB), Bootstrap CSS and jQuery.

Very good setup that will solve your problems relatively fast and can be running for years without much maintenance.

There is no point of using anything else to do webpages. These technologies are tested and tried and works. Tons of documentation.

Ignore ideas that says you need to use fancy modern technologies, that is what has ruined the web and web development.

What is important is to follow best practices and web standards and that is true regardless of what technology you choose.

I would suggest php, it can perform well with much more flexibility and matured ecosystem. All your requirements will be fulfilled with scalability.

Are you just trying to build a CRUD thing with login? Parse Server hosted on a Node JS server + MongoDB + a little jQuery should do the trick, and you could probably do it all on free tier hosting.

I wrote an easy guide on how to do it in half an hour, targeted at people new to web dev: https://medium.com/@smuzani/setting-up-a-mobile-backend-serv...

The nice thing with Parse is not just that it handles password hashing, roles, and access. Queries are easy, and will give you the results neatly. Client side queries are not secure, but you could host the code on Node.js, or use PHP.

The dashboard is quite sexy and works well on mobile too, which is one of the main reasons I like it.

I solved for all those requirements with SharePoint when I took ownership of this shop I am running on my current military deployment. It had to be SharePoint and I didn't have a choice, a constraint of the environment.

In my first two weeks here I wrote an interactive ticket system and analytics tool in vanilla JavaScript. It is highly modular and easy to extend. It uses the same 2 SQL queries on every page load, but this page is frequently accessed. The tool was necessary, because the thing it replaced was garbage.

I recommend django, especially if you know python. There are some guides on hosting it with something like pythonanywhere or Heroku and you're set!

Don't listen too much to what 'should be avoided'. PHP is a perfectly fine tool for a simple dynamic website and is trivial to deploy.

Flask is in python, light and modular. Has plugins for security and all you need. For frontend, I don't really know. Vue or plain CSS?