Can I write to two tables in two parallel processes in SQLite?

[Thang Nguyen]

Hi,

I would like to know if I can write stream data into two different tables with SQLite at the same time or not? Currently my system has one camera. I store the capture images and particle measurement in one table. I have just add one more camera to the system and would like to do the same thing and write to a second table in a parallel process.  I wonder if this is possible or not.

I use SQLite library.

Thanks in advance.

 

Edited April 24, 2020 by Thang Nguyen

[drjdpowell]

Although there can only be one thing writing a specific transaction at a specific time, two or more processes can write to the same file (and same table, actually).  They just end up writing one after the other.   

[Thang Nguyen]

James,

Thanks for your response. I tried to modified one of your example to create two tables. One thing I noticed is BEGIN.vi returns error 5 when it waits for a while but there is no timeout input. Should I just clear the error and run the Execute SQL vi again?

SQLite Example 1 -- Create Two Table.vi

[drjdpowell]

Timeout input is on the "Open" method, or it can be changed with a property node.

[Thang Nguyen]

Thank you very much.