I'm a self-learned programmer working in finance who primarily uses Python and SQL. I am a team of one which allows me freedom in choosing what I want to work with but unfortunately also comes with the downside of having no mentorship on the programming front. Right now, everything ends up in Excel and I want to start migrating things to a web app. I want to create some simple web apps for displaying (for now) minimally formatted tabular data and as a distant second some basic charts. I do not know any JavaScript but would be willing to learn if it would assist. I previously have tried out Flask and hated working with HTML/CSS each time. Is Flask still recommended for a minimal/easy to get started setup in 2020 or is there anything else out there? Any advice would be greatly appreciated.
Django has a steeper learning curve than Flask, but takes care of more of the tedious and repetitive stuff for you. With Flask you’ll have to build more from scratch or cobble together third party modules that were never really meant to work together.
When did you last look at Django? Modern versions are far more flexible and powerful than those of 10 years ago, but that flexibility comes at the expense of a bit more boilerplate and a bit more to learn. It’s just about perfect for most CRUD apps; and if you want to use raw SQL for queries too complex for the ORM, it supports that too.
For charts, there are some Python tools for server side rendering, but you may want to look into Javascript frameworks like D3 that support live-updating charts when users adjust parameters. That said, you can also start with server rendered for MVP and add Javascript as necessary.
You’re probably going to have to write at least some of your HTML from scratch, but a modern layout library like Bootstrap can save you the heavy lifting for CSS and provide some HTML boilerplate.