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 can do simple and fast operations on both databases within a single query. 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 time? Or do I need to set up and tear down individual ATTACHments as part of each sync operation? I would prefer the former, but it's not clear what the issues are. 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? Thanks for any words of wisdom here. Randall. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
