@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
Advise on a idea
Re: Advise on a idea
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 ...
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 ...