[_benj]

I would also add Don't use wordpress! As a developer you'll find yourself constantly hitting a wall trying to get wordpress to do what you want instead of wordpress working for you.

You could learn Flask, which is very simple but I wouldn't recommend learning React/Vue just yet, rendering the HTML on the backend as opposed to using a JS framework will make your life a lot easier, specially if you are not familiar with browsers and the problems that JS frameworks are trying to solve.

As for design, you can copy/paste code from something like bootstrap/bulma/foundation to create a decently looking UI wihout having to learn a lot of HTML/CSS.

For the DB, just use whatever you use before on python and at the end of the day you'll pretty much end up with an HTML template, and just pass a dict to fill it with whatever data you need, totally decoupled from where that data is coming from, whether it's an API or a DB or whatever else.

Good luck!

[LimitedInfo]

Awesome thank you for the info!