Android Question Share the same database (SQLite) for different applications

aeric

Expert

Licensed User

Longtime User

• Nov 27, 2023

• #2

I think it is not a good way.
Why not just send messages using MQTT or UDP?

 

Upvote 0

aeric

Expert

Licensed User

Longtime User

• Nov 27, 2023

• #3

Here is an example using UDP.

Send and Save Data into SQLite on Another Device (using UDP)

Data Sender App Sub Class_Globals Private Root As B4XView Private xui As XUI Private UDPSocket1 As UDPSocket Private txtHost As EditText End Sub Public Sub Initialize End Sub Private Sub B4XPage_Created (Root1 As B4XView) Root = Root1 Root.LoadLayout("MainPage")...

www.b4x.com

 

Upvote 0

D

DitoNet

Member

Licensed User

• Nov 27, 2023

• #4

SQLite supports concurrent reads/writes, just enable WAL mode and place the database in a folder accessible to both applications.

B4X:

PRAGMA journal_mode = wal;

Regards, G.

 

Upvote 0

aeric

Expert

Licensed User

Longtime User

• Nov 28, 2023

• #5

I misread the question.
I thought it was about different devices.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Nov 28, 2023

• #6

It isn't possible on newer devices as you cannot directly access the secondary (shared) storage.

You can use ContentChooser or ExternalStorage to import the db and then open it from XUI.DefaultFolder.

 

Upvote 0