Re: [sqlite] Multiple ATTACHments to the same DB?

On Thursday, 1 August, 2019 16:32, Randall Smith wrote: >I am developing a setup where multiple independent slave SQLite >databases are periodically synching with the same master database. >It would be convenient if I could ATTACH the slave and master DBs to >each other during the synch so I

Re: [sqlite] Multiple ATTACHments to the same DB?

On 1 Aug 2019, at 11:32pm, Randall Smith wrote: > Can an ATTACH request encounter a "locked database" error, or do these only > occur when an actual modification is attempted? How are ATTACHments > different from connections? Sorry, hit 'send' too soon. I don't think ATTACH can get a

Re: [sqlite] Multiple ATTACHments to the same DB?

On 1 Aug 2019, at 11:32pm, Randall Smith wrote: > My question is: Can I have 10 or whatever slaves ATTACHed to the same master > at the same the time (that is, constantly ATTACHed while he slave is open), > in the same spirit as having 10 database connections open to the master all > the

[sqlite] Multiple ATTACHments to the same DB?

Hi, all. I am developing a setup where multiple independent slave SQLite databases are periodically synching with the same master database. It would be convenient if I could ATTACH the slave and master DBs to each other during the synch so I could run the synch as a single transaction and so I