Currently running an app with both local and cloud DBs:
Local DB handles all CRUD for real-time display and fast user interactions.
Sync button pushes changes to Azure cloud DB via Redis-Celery for background processing.
Is this approach efficient? Any pitfalls or better ways to handle syncing? We mainly store OCR data and images (bytea)
I replicated both databases, so the database in my local PostgreSQL with the fields/models is the exact same on my Azure Cloud Database
Welcome @KennethAaron !
Efficiency isn’t a binary value - it’s not a question of whether or not it’s efficient, the question is whether it’s efficient enough to satisfy your requirements.
If what you have is working for you, and is completing the work within an acceptable window of time, then it’s “efficient”. If it’s not, then you should be looking at alternative approaches - and the options you would evaluate would be those that address the reasons why the current solution is considered inadequate.