concurrent connection

[storynana]

Hi, there;
I am using this in one of my ionic projects. Is there any way I can use this CapacitorSQLite module to have concurrent access to my sqlite db? I am getting error when trying open two connections at the same time:
'CreateConnection: Connection xxx already exists.

Cheers,
Rob

[jepiqueau]

@storynana you can have only one connection in write access mode and one connection in read-only mode to the same database and you can have multiple connections to several databases.

[storynana]

Thanks Jean for the quick response. Can I keep the connection always open during the lifetime of the app? Or it should be a good practice to always close the connection when I completed the query? Cheers, Rob.

…

On Sun, Jul 2, 2023 at 4:50 PM QUEAU Jean Pierre ***@***.***> wrote: @storynana <https://github.com/storynana> you can have only one connection in write access mode and one connection in read-only mode to the same database and you can have multiple connections to several databases. — Reply to this email directly, view it on GitHub <#436 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACQQ76X5B5RJ6YZJREHSR6TXOD4Z3ANCNFSM6AAAAAAZ3GQTBU> . You are receiving this because you were mentioned.Message ID: ***@***.*** com>

-- Cheers, qiuwei

[jepiqueau]

@storynana it is up to you but it is time consuming to open and close it each time for à query. I use to leave it open