i am able to create sqlite database using firefox addon and use database in iPhone. Now I want to give the the password to database and used it in my iPhone application. i tried a lot on google to search the proper way yo create password protected database but still no success.
我能够使用firefox addon创建sqlite数据库,并在iPhone中使用数据库。现在我想把密码给数据库,并在我的iPhone应用程序中使用它。我在谷歌上尝试了很多来搜索正确的创建密码保护数据库的方法,但是仍然没有成功。
anybody have idea that how can create the password protected sqlite database and how can we use it in iPhone
任何人都知道如何创建密码保护的sqlite数据库以及如何在iPhone中使用它
2 个解决方案
#1
2
Try SQLiteEncrypt.The SQLiteEncrypt is an AES encryption embedded SQLite database engine through which you can encrypt and decrypt your SQLite database file. When set a password key into your database file, content is no longer stored in cleartext, so that we achieve the purpose of data protection.
SQLiteEncrypt试试。SQLiteEncrypt是AES加密嵌入的SQLite数据库引擎,您可以通过它对SQLite数据库文件进行加密和解密。当在数据库文件中设置密码键时,内容不再存储在cleartext中,从而达到数据保护的目的。
But it is not free.
但这不是免费的。
Note: But IT is not for iOS (thanks brad to pointed it out).
注意:但它不是iOS的(谢谢brad指出)。
*Edit***
* * * *进行编辑
For iPhone you can use SQLCIPHER which is an open source full database encryption for sqlite.
对于iPhone,您可以使用SQLCIPHER,这是一个用于sqlite的开源全数据库加密。
#2
0
Unfortunately, there is no free solution for doing that. There are some commercial applications, which allows sqlite database encryption. Also, there is virtual filesystem support in SQLite, where you can change calls which reads/writes data to SQLite database, however that will require some coding.
不幸的是,没有免费的解决方案。有一些商业应用程序允许sqlite数据库加密。此外,在SQLite中还有虚拟文件系统支持,您可以更改对SQLite数据库进行读写的调用,但是这需要一些代码。
#1
2
Try SQLiteEncrypt.The SQLiteEncrypt is an AES encryption embedded SQLite database engine through which you can encrypt and decrypt your SQLite database file. When set a password key into your database file, content is no longer stored in cleartext, so that we achieve the purpose of data protection.
SQLiteEncrypt试试。SQLiteEncrypt是AES加密嵌入的SQLite数据库引擎,您可以通过它对SQLite数据库文件进行加密和解密。当在数据库文件中设置密码键时,内容不再存储在cleartext中,从而达到数据保护的目的。
But it is not free.
但这不是免费的。
Note: But IT is not for iOS (thanks brad to pointed it out).
注意:但它不是iOS的(谢谢brad指出)。
*Edit***
* * * *进行编辑
For iPhone you can use SQLCIPHER which is an open source full database encryption for sqlite.
对于iPhone,您可以使用SQLCIPHER,这是一个用于sqlite的开源全数据库加密。
#2
0
Unfortunately, there is no free solution for doing that. There are some commercial applications, which allows sqlite database encryption. Also, there is virtual filesystem support in SQLite, where you can change calls which reads/writes data to SQLite database, however that will require some coding.
不幸的是,没有免费的解决方案。有一些商业应用程序允许sqlite数据库加密。此外,在SQLite中还有虚拟文件系统支持,您可以更改对SQLite数据库进行读写的调用,但是这需要一些代码。