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

F

FrankDev

Active Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes

aeric

Expert
Licensed User
Longtime User
Yes, you can build a B4J server with SQLite backend. You can use jRDC2 or my Web API template.
 
Upvote 0
F

FrankDev

Active Member
Licensed User
Longtime User
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
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
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.
 
Upvote 0

Marvel

Active Member
Licensed User
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.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Example Syncing local databases using PHP to access a database on a hosted server
Replies
1
Views
6K
thetrueman
T
  • Article
B4A Library [B4X] B4XCollections - More collections
2
Replies
20
Views
30K
Erel
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
177K
Erel
  • Article
Android Tutorial Accessing third party Jar with #Additionaljar and JavaObject - Picasso
2 3 4
Replies
78
Views
78K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
369K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…