Database – How to a web app work correctly when Internet connection is lost for some hours

databasedesignenterprise-architectureweb-applicationsweb-development

Our team wants to design a Web-Based retail pharmacy management system. A web based solution is good because no user installations are needed.

Some of the data fetched from central database are read-only and are shared between clients (5000 pharmacy users) and Clients maybe store their billing or anything else to a central database.

There is one challenge. The web app should have 100% up time.

  • How can we handle hybrid online and offline mode when the Internet connection is lost?
  • Is there any known method? Should we sync updates of
    database into local customer computer and work with that? The database size may be too big, for example 10 GB.

Best Answer

If the internet connection is lost, it's not your application that is bad, it's the internet connection. So it's the internet connection you need to focus on. if it's critical to be connected to internet all the time, this can easily be done by having two internet connections (redundancy) at each location. (should be from different operators)

in many cases a pharmacy would also need a internet connection to be able to handle credit card purchase, so even your application is a "locally installed desktop application" they might not actually be able to do very much with it without internet a connection.