What technical toolkit would you recommend for an offline service in python + sqlite?

Question

Python

Good time!
For the purpose of self-learning, I decided to make a project to master modern technologies for building such systems. I want to implement the following system:

I will implement the server in python. Most likely I will take a DB SQLite. the console client is also in python or something else. And I don't know what to do with the web client. I have some experience with JSP, but I want to learn something new. The only request, I will work in Linux with the most open source products, so I ask you not to recommend all sorts of .Net things.
Please advise what modern technical tools (languages, technologies) are used to build such systems?
I'm bad with functional programming. Therefore, I would like to apply some kind of functional PL for one of the blocks.

Answer 1

Well, since you're writing in python, why not use Django?
And SQLite is not the best idea in this case. In case of sudden bigdata it is better to use Postgresql or something designed for bigdata.

Answer 2

Some mess in your head.
1) JSP - Java Server Pages, has nothing to do with the client, server things are written on it.
2) On .Net under Linux, of course, they also develop, and even quite successfully! Look at www.mono-project.com
3) Python is a very functional programming language - https://docs.python.org/3/howto/functional.html
And finally, everything is here - https://aiohttp. readthedocs.io/en/stable/
Including working with databases.