System modularization

Asked

Viewed 190 times

5

I’m developing a C# system with Winforms from Livestock Control to a farm, and will communicate with a scale to improve the weighing process.

Some of the features are (Bill entry, vaccination, casualties, transfers, purchases, stock).

I have some doubts about the structure, because the farms do not have internet. And the manager will be able to access the data through the office. So I don’t know how to do, because I would have a local system and a web system?

I imagined that I could have a separate module to do the weighing, using a local bank (SQL CE, Sqlite), because I believe that it is not worth installing a Sqlserver bank on the "pawn" machine, and that then would sync in cloud with the management system, after getting internet connection.

And the features related to purchases, low, etc. Would be together with this module offline?

My thinking is correct, and which database I should use for each situation?

c# .net sql-server winforms sqlite

  • And how will you pass the farm data to the office?

  • @bigown Initially I thought of exporting the data to csv and loading into the office machine.

  • it would not be possible to place satellite internet?

  • 1

    As you already communicate with the scale, I believe you know a minimum about serial communications and the like, so I suggest you a solution taken by the company I worked in, which is to use telemetry controllers via GPRS. such equipment can be found in companies like http://www.abstelemetria.com/ , it is worth taking a look at!

2 answers

4


It is very complicated to have a system that works in isolation and at the same time needs to be integrated. It is not easy to make it work properly and only with very detailed information would it give to inform something. Even so I think the question would be considered too broad, it would be practically a complete consultancy.

This would be a case of running condition extremely easy, because you would have disconnected systems doing concurrent operations. So one goes there and drops something, another in another place does the same, the time it will consolidate, the two casualties conflict and one makes the other unfeasible. There are ways to solve this, but I would have to see the specific case. I would go down a path that these isolated units did as little as possible. If that’s the case, I’d even invest in satellite Internet.

In such simple cases almost always the best solution is Sqlite. Have some questions on the subject.

This is like doing microservice, but with a latency for the data to become consistently very strongly.

1

A question about the business itself. The balance is integrated into your system, or the weighing release is manual?

If the scale is integrated, I would strongly recommend the use of internet, albeit by satellite, as suggested in another response.

If the scale is not integrated, I believe you could think of a mobile strategy, using a mobile phone, or tablet with Sqlite database that communicates with a Webapi. The other functionalities of the system I would recommend to do with Web, because it would serve an eventual headquarters of the farm, with internet, and could also be available to the owner in any place.

  • The scale is integrated with the system, it implements a serial interface in a USB interface.

Browser other questions tagged c# .net sql-server winforms sqlite

You are not signed in. Login or sign up in order to post.