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

[livingpunchbag]

Experienced C programmer here. I need to build a very simple website for personal usage with:

- Password-protected login to hide every single page behind

- A single sqlite database with possibly a single table (maybe a second single-line table to store my login + pw-hash + salt)

- A single page to upload stuff to the database. Some kind of asynchronous JS instead of HTML forms may be preferred.

- A single page that always shows the same database query

- Very infrequent access to the site (not more than once per day)

- There's basically zero chance that this would grow to something bigger. Maybe just extend the site functionality to allow my wife to also use it, and maybe find a way to interact with it from command line on Linux (but probably by doing HTTPS requests).

I did something like this with PHP back in 2007, but I know PHP is not very recommended. I worry that trying to learn a whole framework like Ruby on Rails or Django may be overkill. I really like Ruby as a programming language (although I never used RoR), so sticking with it would be cool, but Dreamhost says I should avoid it since it uses use too much memory and I'm on a shared plan. I also have some experience with cgi-bin in python, but I'm also told cgi-bin should be avoided just like PHP. I'm also aware that I could use some sort of server-side javascript, but there are a trillion frameworks to choose from.

What would you use today? What would you recommend?

[SQLite]

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.

[MH15]

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.

[livingpunchbag]

I'm much more experienced with Ruby and Python than PHP. I did something simple in PHP in the past simply because I didn't even know I could do something else.

But maybe PHP is indeed the right choice. Right now I am kinda considering Ruby with CGI.

[seanwilson]

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.

[livingpunchbag]

Never heard of Firebase before. But I want to stay away from Google as much as possible. It needs to be something on my own hosting (Dreamhost).

[mattbrewsbytes]

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.

[livingpunchbag]

I wanna stay away from Google as much as I can. Also, as I mentioned earlier I will probably add some kind of automation to access the page from Linux command line, and Google won't help here.

I am considering maybe learning Rails. I just worry if it would be too overkill or too complex for it.

I am also considering just using Ruby with CGI.

[mindcrime]

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/

[fetbaffe]

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.

[jituc]

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

[muzani]

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.

[austincheney]

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.

[roland35]

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!

[thijsvandien]

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.

[tubularhells]

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?