Android Question two or more android devices to access 1. (shared) sqlite database

[FrankDev]

hello

is it possible from 2 or more android devices (in my case tablets) to access 1. (shared) sqlite database.

background.
i want to have all this in a common network.
From 2 tablets (or more) i want to access one database.

is sqlite 'so similar' to microsoft access... so that you don't need a 'server'. So a file based database ?

Regards
Frank

 

[aeric]

Yes, you can build a B4J server with SQLite backend. You can use jRDC2 or my Web API template.

 

[FrankDev]

hi @aeric


but I am not looking for this kind of solution. I just want to do it with B4a and a (file) database.
Otherwise I have to set up a server again ?
Then I can dock to a MySql_Database with a little json and php. ?

Greetings Frank

 

[aeric]

If I am not wrong, other Android device cannot write into another Android due to file permission, the internal directory is not accessible.
There are solutions by turning your Android into a web server by @Star-Dust but I never tested before.

SD DigestServer (httpServer+Digest Auth) with Source Code

The library has been updated to be cross-platform and you can find it in this THREAD I have extended the HttpServer Library functions by adding Digest authentication. This is a demonstration version, it allows normal http connections (such as httpserver) and activating the digest protocol on a...

www.b4x.com

[B4X] xHttpServer (Http Server + jQuery)

It is a personal project of mine that I started as a hobby on B4i and it has become an interesting project, so that I have modified it to be multiplatform. It is an http server, which allows a browser to navigate on html pages stored on the device. In addition, dynamic pages can also be...

www.b4x.com

Edit: Other solution like MQTT also can be consider and also I never tested before.

 

[Marvel]

Another option is to keep a separate database on each device and update missing entries on each database base when they connect.

It won't be simple, but without a server, that's the only solution I can think of.

 

[Erel]

Then I can dock to a MySql_Database with a little json and php. ?

No. Search for jRDC2.

Another option is to keep a separate database on each device and update missing entries on each database base when they connect.

Check CloudKVS for this option.