I have and app uses sql lite db, Is there a way that I can connect the SQLite db in the local computer via wifi connection? This PC serve as the server of sqlite db of the app for multi user? Is it possible?
The simple answer is as long as Android has direct access to a file location then it should be perhaps possible. There are a number of security risks when you give everyone and everything access. An SQLite database can normally be read as readable text. You could reduce that risk by encrypting the database. Maybe you can make a solution with SAMBA, SMB, Google drive or One drive.
use jRDC2 on your PC and connect your App to the jRDC2 running on your PC (which itself connect to the local SQLite-DB on your PC).
Search the forum about jRDC2 for Library, example, ect.