How to use the http protocol to work with the server?

Question

Database

I’ll write right away that I have never worked with http.
I have a database with tables, in general, this is a library database. The user can click on different buttons, for example: take a book. And the essence of my question is that I don’t understand how I can use the http protocol here, I have the following picture in my head: Through the alchemy library, you can connect to the database, and for example, click on different buttons, and simply pass the necessary sql through cursor.execute script and then just get the data from the database.
Why should I use http?

Answer 1

HTTP is needed when you want to transfer data to the client through it.
This most often occurs when you have a website or when the client and server are separated. (well, you won’t give every client full access to the database?)
Since we are talking about SqlAchemy (it means you have a python), then the python has Django, Flask, FastAPI for this