'Sending query requests over LAN
I have an inventory management app (windows) that uses sqlite3 database. The app is installed on the main PC we have in the office. I am going to have around 6 scanners communicating with this app. The warehouse that I am going to use this app at is quite large and the barcode scanners are not able to emit the signal over the distance so there will be 3 PCs installed nearby the areas of interest. The plan is to send the barcode scanner data to these PCs and then have these PCs communicate with the main PC in the office. So basically something like this
2 scanners ---> installed PC 1 \
2 scanners ---> installed PC 2 - main PC
2 scanners ---> insatlled PC 3 /
Based on the research I have so far sharing sqlite3 database locally is not the proper way to do it. Instead I decided to use socket programming in python to send the query requests over TCP as json or dict format. My goal is to collect all the requests on the main PC and then proceed with the whatever CRUD operation these requests involve.
Since I have never done something like this before I am wondering if socket programming is the way to go?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|