title: Is it ok to replace a sqlite file while a program has an open db connection to it?
body: <p>I have a C program that opens a sqlite3 db via sqlite3_open_v2(), and then periodically runs some SELECT queries. Will anything bad happen if I replace that file while the program is running? Is there some proper way to do that to avoid problems? I want to avoid restarting it.</p>