SQLite cannot be encrypted?

Source: Internet
Author: User
Tags access database security

One project of the company is intended to be implemented using the Smart Client. For the purpose of improving the speed, the company intends to cache some basic information data locally. The data volume is small and is only used for queries, apart from data updates, there will not be a lot of update operations, so we do not plan to use big guys like MySQL or MSDE; the first thing we think of is Access, but Access database security is too poor; the other is to use XML files, but the XML file content needs to be encrypted in this way, without knowing the efficiency and ease of query. The other is an open source embedded database, such as SQLite;


So I downloaded a bunch of SQLite stuff and looked at it. It was easy to create tables and add data. net driver, everything looks perfect-but how to add a password to the database?


Start Google for half a day and find the result: http://article.gmane.org/gmane.comp.db.sqlite.general/11374 written in the second reply:

> If you send Dr. Hipp money you can get a version that is protected by a password. It seems like an equitable trade, with everybody happy in the end.

It seems that free encryption is useless.

> If your data is valuable enough to be worth somebody's time to steal, I think it shoshould be valuable enough for you to protect it properly.

This is correct, but I still want to find a database that can be used for free and can be encrypted better ......

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.