I have a database (PostgreSQL), which I need to update from time to time (every 6 hours). I don't want partial updates to appear on the output, so my idea is:
We use two databases, let them be named prod
and update
. prod
is all the time on duty, while update
is being updated every 6 hours and then it should pass changes (or change places) to (with) prod
.
How can I implement such behaviour in Django? I know, that there are migrations and db_to_write, db_to_read variants, but they stay not clear to me from the tutorial.