Accessing Python code & SQL datbase from other pc's

[Extra]

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.

[Larz60+]

Something you may wish to read:

Here's a very well written blog which does an excellent job of comparing the two most used free DBMS MySQL and PostgreSQL. Both are excellent and one may be better than the other depending on what they will be used for.

I have used both, and prefer PostgreSQL only because I have extensive experience with Oracle (which now owns MySQL) and PostgreSQL is quite similar to Oracle.

This blog does not favor one over the other (well maybe a little), which I think makes it quite good.

This is the URL: https://www.upguard.com/blog/postgresql-vs-mysql