Sqlite数据库安全 [英] Sqlite db security

问题描述

建立使用Sqlite DB的应用程式。
用户可以将他们的信息输入到db并检索它们。
但是，我希望他们能够备份sqlite db。
我做的是将sqlite数据库放在文档文件夹中，以便他们可以使用iTunes检索它。
例如，如果ipad出现故障，我希望他们能够将sqlite db传输到另一个ipad。

Im building an app which uses Sqlite DB. Users can enter their information into the db and retrieve them. However, I want them to be able to backup the sqlite db. What I did was putting the sqlite db in the documents folder, so they could retrieve it out using iTunes. For example if the ipad is faulty, i want them to be able to transfer the sqlite db to another ipad.

现在的问题是，我不想让他们知道db中的信息，应该说db结构。
那么如何构建一个只能由我的应用程序读取的数据库？当他们使用sqlite浏览器打开，他们将无法看到任何东西。
我在寻找一些简单的东西。可能让数据库在打开它之前提示密码？

The problem now is, I dont want them to know the information inside the db, should say the db structure. So how can I build a db that is able to read by my application only? and when they use sqlite browser to open, they wont be able to see anything. I'm looking for something simple. Possible to have the db to prompt a password before opening it?

推荐答案

这里是链接答案，SQLCipher是最好的东西，它将加密整个数据库，如果有任何一个从iOS设备获取数据库，任何方式，仍然会提示输入密码否则将不允许用户看到相同。即使有命令提示符，用户也无法看到数据库。

Here is the link to your answer, SQLCipher is the best thing, which will encrypt the whole database and if any one get the database from the iOS device, any how , still it will prompt for a password otherwise is will not allow user to see the same. even with Command prompt the user will not be able to see the database.

希望这将是usefull ....

Hope this will be usefull....

这篇关于Sqlite数据库安全的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！