应用程序结构的帮助 [英] Help in Application Structure

问题描述

大家好，

我需要开发一个基于数据的Windows应用程序，这意味着该应用程序仅从数据结构中搜索并显示输出.我正在考虑使用Sqlite数据库.我会在部署时附加文件.

现在的挑战是

-如何保护数据库的安全性，使任何人都无法打开或删除它.
-如何更新数据库，我不想替换整个.db文件.

任何建议或想法都将不胜感激.

Hello Everyone,

I need to develop a data based windows application, means the application just searches from a data structure and shows the output. I''m thinking to use Sqlite database. I''d attach the file while deployment.

Now the challenges are

-how to secure the database so that no one can open or delete it.
-how to give updates to the database, i don''t want to replace the whole .db file.

Any suggestion or ideas would be thankful.

推荐答案

-如何保护数据库，以便没人能打开或删除它.

你甚至都不要打扰.

-如何对数据库进行更新，我不想替换整个.db文件.

然后编写可适当修改数据库的SQL脚本.问题在于成功的更新，如果有人尝试将数据库更新为架构v3，但他们没有应用架构v2更新，则您的v3更新必须是累积性的，包括v2的更新和正确的逻辑以区别.

-how to secure the database so that no one can open or delete it.

You can''t do don''t even bother.

-how to give updates to the database, i don''t want to replace the whole .db file.

Then write SQL scripts that modify the database appropriately. The problem is with sucessive updates, if someone tries to update the database to schema v3 and they didn''t apply schema v2 update, your v3 update has to be cumulative, including the updates for v2 and the correct logic to tell the difference.

这篇关于应用程序结构的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！