How about to use sqlite backup apis? These are designed to copy database file without locking on source file. AFAIK, it restart backup progress when source file is changed. 2012. 12. 7. 오전 4:30에 "romtek" <rom...@gmail.com>님이 작성:
> Hi, > > A recent discussion of a reader/writer problematic situation has > prompted me to ask the following question. > > While the database file is being written to, the data isn't ready to > be used by readers, so that DB is locked. What happens if I initiate > copying of this file (e.g., to back it up)? Is the file being > protected by the OS from being copied while it's being written to? Or > do I need to make sure that nobody uses the DB before I attempt to > copy the file? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
