I am developing an application which is used by multiple clients and the main goal of the app is to be used online. But a specific requirement is, it should be able to work offline too (only for a single client(s) in an emergency situation and for short time - 24 hours maximum). now I am using Django REST framework for backend and Jquery/AJAX frontend for GET and PUT etc. requests which update PostgreSQL DB on the backend. Now little research on the internet suggests the I should use PouchDB on the frontend and/or CouchDB on the backend. But my questions are:
- Is it really possible?
- If yes, then which DB should be used for the backend database?
- When the offline client become available online, how we can synchronize the data generated online?
- Can we cache some data on clients machine for offline availability purpose?
- Is it still possible to use PostgreSQL for the backend? (I really want to use it !)