开发者

Does SQLite3 change databases even if every statement is "SELECT"

开发者 https://www.devze.com 2023-01-16 06:13 出处:网络
we try to deploy our software on Windows 7, and there are several sqlite3 db files around. But, these are all read-only and we execute only \"SELECT\" statements. However, we have observed that Window

we try to deploy our software on Windows 7, and there are several sqlite3 db files around. But, these are all read-only and we execute only "SELECT" statements. However, we have observed that Windows 7 also make virtualization开发者_如何学编程 on these files, which means file structure or content is changed. What do you think of it? What changes these files without any INSERT or UPDATE? Thanks in advance.


Do these databases exist in your Program Files folder? If so, you should take a look at e.g. this article on MSDN. Data files shouldn't go in the Program Files folder but in Program Data. Otherwise, if you really positively absolutely have to put the databases in the Program Files folder, make sure you pass SQLite the proper flags to open it in read-only mode by passing SQLITE_OPEN_READONLY (see the manual).

0

精彩评论

暂无评论...
验证码 换一张
取 消