What is the algorithm for developing a client-server application?

Question

PostgreSQL

I’ll make a reservation right away, the essence of the question may seem silly, but:
explain to me what are the right steps I need to take in order to develop a full-fledged client-server application myself, having three technologies: Angular (client), Node.js (server), PostgreSQL (db)

I will explain problem. Started cutting the project. I created a client, then in the same project I started to cut the server. Then I thought, perhaps this is not correct, and moved the server to a separate project. I don't know if the solution is correct.

Then I sit and think. And how do they do with the database. Do they create all the tables manually or write a script so that the server automatically deploys the database if there are no tables to work with? My understanding is that there should be an initializing script somewhere automatically. I'm looking for tutorials on this topic but it's hard to find. Completely about the connection, but how to initialize. And so I think, am I thinking right? Or is the database transferred manually to the hosting later?

Well, there are still questions that I eliminate along the way. But indicate in which direction you need to move so that I understand the main stages of development. Some kind of video or the course is not long without water. Or describe yourself.

I'm self-taught, so I don't understand some of the nuances. If there is experience in programming itself, but in a different area (not a client-server without direct queries and connections to the database)

Answer 1

For a database, migrations can be used during initialization and development.
What is the purpose of database migrations?
Database migrations in nodejs
I don't know how in node, but in ASP.NET it is possible and preferable to do a project using the Code First approach, which involves using migrations to generate tables from code in the database.

Answer 2

First success! By the way, I started my career in Vinnitsa at the "Terminal" plant in 1986.
You were absolutely right about migrations.
But in general - or follow roadmaps, like https://www.freecodecamp.org/news/how-to-become-a-... , https://dev.to/ender_minyard/full-stack-developer- ... .
And https://12factor.net/ of course.
Or write a minimal application yourself, and then look and think about what and how to improve, taking into account best practices.
Recognition: for many years I have not been a developer, but DevOps.

Answer 3

start with pure languages ​​JS CSS HTML PHP without anything
for the database use Sqlite
make this a simple study project
and only after that move on to frameworks and complex databases