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

[AUGUSTO CAVALEIRO]

Good afternoon,

I need to share the same database (SQLLIte) on the same device by two different applications. I tried using File.DirRootExternal but it doesn't work... can anyone help me?

Thanks in advance

 

[aeric]

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

 

[aeric]

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

 

[DitoNet]

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

PRAGMA journal_mode = wal;

Regards, G.

 

[aeric]

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

 

[Erel]

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.