How to develop a web application?

Question

PostgreSQL

Hello!

At the moment, I need good advice, useful articles, and possibly links to solve my problem.

I need to develop a web application that needs to work with a PostgreSQL database.

The essence is as follows: the visitor enters the application and enters the number of his virtual "discount" or simply "personalized" card in the field (thereby registering or activating it). Card numbers should be generated and given out to managers to attract new customers. That's all for now.

PS Please do not judge strictly, one of the first serious tasks for the entire development time (student).

Answer 1

The essence is as follows: the visitor enters the application and enters the number of his virtual "discount" or simply "personalized" card in the field (thereby registering or activating it). Card numbers should be generated and given out to managers to attract new customers.

This is a requirement that needs to be considered and danced on from this.
First you need to understand business processes.
As a manager (user role in the database) I go there, do X and get Y.
As a client (user role in the database), I go there, do X and get Y.
You describe the actions that the user performs, which sees on the screen, how he interacts through the interface, etc.
Build an interface layout.
https://careerfoundry.com/en/blog/ux-design/how-to...
https://uxplanet.org/basic-ui-ux-design-concept-di...
Try to keep everything simple, minimal and at the same time functional. No need to chase JS frameworks - they usually just add complexity. If the page has a simple form for entering data with field validation, then nothing needs to be added, but only some libraries should be used to facilitate the work. If there is simple interface logic, some kind of templating engine like Handlebars might suffice .
The card number is usually read from a magnetic stripe or chip. You need to generate card numbers. To do this, you need to know what this number is and whether there are any rules for generating it.
If it's just an arbitrary sequence of digits, then it's trivial.
Think over what type of data is needed for storage in the DBMS, what will be in the table, and how it will be used (located) in different scenarios.
To work with the DBMS, an ORM is taken, such as SQLAlchemy or another.