Access SQLite Database from another computer connected in LAN network

[YAABITECH]

Hi Sir, 
I have a desktop application in phpdesktop chrome. It's working well in my PC. The application has a database in sqlite named Mydata.db and I want to connect 2 computers in LAN to access the common database. I have installed the software in both the system but I need to access any one database from both the computers. Please help me.

[Czarek Tomczak]

Create a shared network folder on one of the computers and put sqlite database inside that folder. Then configure sqlite on both computers to connect to that database file. Try also Google:

https://www.google.com/search?q=sqlite+database+window+shared+folder+network

[YAABITECH]

Thank you so much sir.

And if any other possibility to make such connections with another databases. Because when I browse, I saw that sqlite has many problems in shared network. So may I use any other open source database to use in a server-client like application in phpdesktop? 

i.e if I create a billing software, products and client details should be accessed from the common database.

[Czarek Tomczak]

PostgreSQL is free for commercial use and can be distributed with phpdesktop.

[Czarek Tomczak]

There is also a portable version of PostgreSQL that is easy to distribute with phpdesktop (with help of InnoSetup for example): https://github.com/garethflowers/postgresql-portable

[YAABITECH]

Sir,

Shall I use MySQL Community Server ( GPL Licensed ) in php chrome desktop application? 

I'm using php desktop chrome application for creating billing software in my local. So I need to store the data in some database. Shall I use MySQL Community server without packaging with my software. i.e. I will install MySQL separately on my client's computers. 

So in this way, is it possible to use the database without affecting the license terms, in php desktop chrome?

[Czarek Tomczak]

Yes, such use is allowed with GPL license.

[Fares ABADOU]

Just setup your application listen in pc ip adress and in the other pc make redirection to that ip

[Simone]

Dear Fares, could you explain me better, this concept?. Thank you in advance

[Fares ABADOU]

in you first computer settings.json file , change "listen_on" to your computer ip adress for ex (192.168.1.2) and port 3000

in second computer www/index.php file write  js code 

<script>

window.location.href = "http://192.168.1.2:3000";

</script>  

[Cesar L. C.]

Hi Czarek ... When will be included pdo_sqlcipher for Windows 7, 8, 10?

Thanks for an excellent project.