I spent some time building the backend for my little webapp, and now I am finally startoing with the frontend, so I want to put it all online (Flask with Postgresql).
I already added a lot of data to my database locally, so I will do a dump-restore to my online postgresql server to have it copied to the remote server.
However, I still want to keep adding data to it locally, as well as, eventually, by using the backend online...
The online DB should always be the latest and greatest though. How to keep it all in sync?
I found info about logical replication, but it is all very technical and confusing to me... I am looking for real-world cases...
So if you do the same, how do you do it??
Greetings from Beijing