Question Protected by Community
    Tweeted twitter.com/StackSoftEng/status/819889857304678400
2 http://meta.softwareengineering.stackexchange.com/questions/6483/why-was-my-question-closed-or-down-voted/6487#6487
source | link

What is a good Software archtecturesoftware architecture for POS with offline mode?

I have a software for small Deliverydelivery stores  (pizzeria, japonese Japanese, etc) here in Brazil running on a few dozen customers and have the possibility to expand it to many more customers after evolving it to a full POS (Point of sale) software. However

However, there is a critical feature we've been struggling to develop: an offline mode. Internet in Brazil is not reliable for comercialcommercial use so its usual in some regions to have problems from a few disconnections a week up to a disconnections for 0-90 minutes every other day. The Software

The software is was made in C#/Windows Forms and the database is MysqlMySQL hosted on Azure. The customers connect to the same database and every table has a CompanyId. It is strategic to have a database online rather than a MysqlMySQL server in the customers local network. I've

I've done a good amount of research but didntdidn't find a solution or a direction so far. We

We took one approach: consider the instalationinstallation would also install a mysqMySQL and download  (if any) the Companycompany data, the Softwaresoftware would Connectconnect to the local database and every a few seconds would make the changes from the local to the cloud database. But it proovedproved challenging and had impact in the code design  (cantcan't do from the scratch due to current customers). Any material or software archtecture for this or this kind of issue would be amazing. Right

Right now we would consider make this mode from the scratch and the migrate previous.

What is a good Software archtecture for POS with offline mode?

I have a software for small Delivery stores(pizzeria, japonese, etc) here in Brazil running on a few dozen customers and have the possibility to expand it to many more customers after evolving it to a full POS software. However, there is a critical feature we've been struggling to develop: an offline mode. Internet in Brazil is not reliable for comercial use so its usual in some regions to have problems from a few disconnections a week up to a disconnections for 0-90 minutes every other day. The Software is was made in C#/Windows Forms and the database is Mysql hosted on Azure. The customers connect to the same database and every table has a CompanyId. It is strategic to have a database online rather than a Mysql server in the customers local network. I've done a good amount of research but didnt find a solution or a direction so far. We took one approach: consider the instalation would also install a mysq and download(if any) the Company data, the Software would Connect to the local database and every a few seconds would make the changes from the local to the cloud database. But it prooved challenging and had impact in the code design(cant do from the scratch due current customers). Any material or software archtecture for this or this kind of issue would be amazing. Right now we would consider make this mode from the scratch and the migrate previous.

What is a good software architecture for POS with offline mode?

I have a software for small delivery stores  (pizzeria, Japanese, etc) here in Brazil running on a few dozen customers and have the possibility to expand it to many more customers after evolving it to a full POS (Point of sale) software.

However, there is a critical feature we've been struggling to develop: an offline mode. Internet in Brazil is not reliable for commercial use so its usual in some regions to have problems from a few disconnections a week up to a disconnections for 0-90 minutes every other day.

The software is made in C#/Windows Forms and the database is MySQL hosted on Azure. The customers connect to the same database and every table has a CompanyId. It is strategic to have a database online rather than a MySQL server in the customers local network.

I've done a good amount of research but didn't find a solution or a direction so far.

We took one approach: consider the installation would also install a MySQL and download  (if any) the company data, the software would connect to the local database and every a few seconds would make the changes from the local to the cloud database. But it proved challenging and had impact in the code design  (can't do from the scratch due to current customers).

Right now we would consider make this mode from the scratch and the migrate previous.

1
source | link

What is a good Software archtecture for POS with offline mode?

I have a software for small Delivery stores(pizzeria, japonese, etc) here in Brazil running on a few dozen customers and have the possibility to expand it to many more customers after evolving it to a full POS software. However, there is a critical feature we've been struggling to develop: an offline mode. Internet in Brazil is not reliable for comercial use so its usual in some regions to have problems from a few disconnections a week up to a disconnections for 0-90 minutes every other day. The Software is was made in C#/Windows Forms and the database is Mysql hosted on Azure. The customers connect to the same database and every table has a CompanyId. It is strategic to have a database online rather than a Mysql server in the customers local network. I've done a good amount of research but didnt find a solution or a direction so far. We took one approach: consider the instalation would also install a mysq and download(if any) the Company data, the Software would Connect to the local database and every a few seconds would make the changes from the local to the cloud database. But it prooved challenging and had impact in the code design(cant do from the scratch due current customers). Any material or software archtecture for this or this kind of issue would be amazing. Right now we would consider make this mode from the scratch and the migrate previous.