If you were to build a simple CRUD app today, what stack would you use?

I'd recommend you use a stack that has pieces you know already.

The problem you've described is solvable with all sorts of tools, so the "fastest" path to something that delivers useful functionality isn't language- or stack-specific.

You'll find plenty of folks who'll assure you that their favorite tool FooBarWhatever written in Blub will make your application super-easy, but that only applies if you already know Blub.

For me personally, I find myself reaching for go + html/template + sqlite unless requirements lead me towards something else. It is simple and straightforward, and gives me decent velocity. In the past I might have said express + react, but the number of dependencies those pull in just gives me an uneasy feeling. I like sticking to the standard library as much as possible. At work where I’m in Visual Studio most of the time, asp.net core + entity framework core is easy to work with too.

My pick without knowing additional details would be something based on FastAPI and MySql: https://blog.balasundar.com/building-a-crud-app-with-fastapi...

If you're not afraid of the vendor lock in, AWS Amplify is rather complete, and gets you up and running real fast at the expense of being all in on AWS. For a straightforward CRUD app you don't even need the hassle of an EC2 instance, just a lambda and an RDS.

Combine it with LLM-enhanced tools like gitwit.dev or vercel v0 writing react code for you, and you're there so much faster it's not even funny.

Speaking of Vercel, that's another stack to take a look at.

LAMP. Simple, well documented and has a lot of resources.

Htmx + Python + some managed db solution

phoenix/liveview