My client has a business which work mostly in remote areas where internet felicity is limited, We have a central database and the branches in remote areas need to connect to the central database. We are developing a web-application(django, postgres) for the same, but it should work even if the client is offline.

---

We planning to achieve it by having a local database and sync the database with central database. (using some jobs running in the client may be celery).

---

We don't need to sync all the tables in the database. Among the following which is a good approach.

1. Should the application always connect with the local database and sync the data with the remote?
2. Should the client connect to the remote when it available and sync the rest of the data?

Let me know is there any better approaches good tools. Thanks in advance.

My client has a business which work mostly in remote areas where internet felicity is limited, We have a central database and the branches in remote areas need to connect to the central database. We are developing a web-application(django, postgres) for the same, but it should work even if the client is offline.

---

We planning to achieve it by having a local database and sync the database with central database. (using some jobs running in the client may be celery).

---

We don't need to sync all the tables in the database. Among the following which is a good approach.

1. Should the application always connect with the local database and sync the data with the remote?
2. Should the client connect to the remote when it available and sync the rest of the data?

Let me know is there any better approaches. Thanks in advance.