Jun-24-2022, 07:36 PM
Hello,
I programed a simple inventory system and I'm trying to run it on 3 PC's. The inventory items are stored on an SQLite Database (inventory.db) and the python program/GUI (PyQt) allows the user to modify it.
I'm wondering if I setup the python/GUI part of the program on each PC, how do I have the Inventory database be accessible to all 3 computers?
I was thinking about MySQL but does that allow other computers (all in close range to each other and using the same wifi network) to connect to the database, so they can all access it?
Or do I need to setup some sort of server(I have an old pc I can use for that) to share the database (and if so how would I go about doing that. Are there any good tutorials out there)?
Any suggestions are greatly appreciated.
Thanks.
I programed a simple inventory system and I'm trying to run it on 3 PC's. The inventory items are stored on an SQLite Database (inventory.db) and the python program/GUI (PyQt) allows the user to modify it.
I'm wondering if I setup the python/GUI part of the program on each PC, how do I have the Inventory database be accessible to all 3 computers?
I was thinking about MySQL but does that allow other computers (all in close range to each other and using the same wifi network) to connect to the database, so they can all access it?
Or do I need to setup some sort of server(I have an old pc I can use for that) to share the database (and if so how would I go about doing that. Are there any good tutorials out there)?
Any suggestions are greatly appreciated.
Thanks.