Advise on a idea

Post your Gambas programming questions here.
AndyGable
Posts: 359
Joined: Wednesday 2nd December 2020 12:11am
Location: Northampton, England
Contact:

Re: Advise on a idea

Post by AndyGable »

@PJblack

Thanks for the links I shall have a read.

Will I be able to have 2 local apps (the sync program and the actual till program) read and write to the SQLite database at the same time? Or will I get the same database locked error message that I did on windows (that was why I used firebird for the local database
User avatar
PJBlack
Posts: 184
Joined: Tuesday 9th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: Advise on a idea

Post by PJBlack »

opening a connection at the same time should not be a problem ... reading at the same time should not be a problem but writing at the same time could be a problem ... see

https://en.wikipedia.org/wiki/Deadlock

and

https://www.sqlite.org/lockingv3.html
https://www.sqlite.org/wal.html

however, since i know neither the requirements of your program nor your concept for realization, it is difficult to make binding statements ...
Post Reply