Accessing database from sharefolder

Arief_Sarjono · December 12, 2019, 5:22am

Hi,
In Windows, I am creating an app using database from different PC via share folder, using database path like,

\\\\192.168.1.2\\db

and its works, but when I do creating the app in linux, it won’t run,
the path is using samba,

smb://192.168.1.2/db

If I do mounting the drive, its normal, I can browse the file and folder too. just can’t access the path from the app.

will it possible to do it in linux ?

thanks
regards,
Arief

Wayne_Golding · December 12, 2019, 7:00am

The only reason I can see you using this method is that you’re accessing a sqlite database across the network. Don’t, just don’t, this path will lead to a future of pain. Use a database server engine e.g. MySql, Postgres etc.

Javier_Menéndez · December 12, 2019, 9:23am

Hi @Arief Sarjono

If you want to use SQLite over the network I strongly recommend you to use a solution like CubeSQL or change to a Client/server DB engine as PostgreSQL or MySQL / MariaDB.

Javier

Arief_Sarjono · December 13, 2019, 2:31am

hi,

Seems that I have no choice to move the db engine into db server.
anyway, thanks for all the helps.

Regards,
Arief