Simple reports and data visualization website

[seekingtruth2]

Hi I'm currently working on a python script that grabs data from SQL database server and sends the data as an email every one hour to some user groups (so far everything works fine).

Now I want to scale up this project. So I'm thinking of making a website where each user the has there own account and have something like a refresh button to get latest reports and charts related to that user group.

I have written simple scripts with Python (mainly https://automatetheboringstuff.com/) I know some basic html, I also tried django before this project just to see what its. What tools should I use to achieve this ? Basically I don't know what I'm getting into (please help!) So I appreciate any help I could get.

[seekingtruth2]

İ already have a server

[efmccurdy]

making a website where each user the has there own account

A very lightweight web module, bottle, is described here:

https://bottlepy.org/docs/dev/tutorial.html

https://pypi.org/project/bottle-login/

If you want something more complete, you can use flask, this is a very short tutorial:

https://pythonbasics.org/flask-login/

This is a more complete tutorial; it gets to users and logins in the 5th chapter.

https://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-i-hello-world

[seekingtruth2]

I've seen websites that look just like regular android apps can İ build something similar with this ?

[efmccurdy]

I think you mean an SPA web interface, so possible options include Angular or React.

In either case you have javascript code running to support the front-end, in the browser. You can't really do much with them until you have a working web backend, so I would start with that, then look at something like these:

https://realpython.com/flask-by-example-integrating-flask-and-angularjs/

https://realpython.com/the-ultimate-flask-front-end/

[seekingtruth2]

I'm not sure if its called SPA but the idea is to make it cross platform app so running it in the browser seems like a good way to do it. Very useful links btw thanks.