blocks|key|1460712|text|一种选择是VistaDB。它们允许对数据库(甚至是表)进行密码保护(以及可选的加密)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1460713|entityMap|0|LINK|mutability|MUTABLE|url|http://www.vistadb.net/^0|5|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

One option would be <a href="http://www.vistadb.net/" rel="nofollow noreferrer">VistaDB</a>. They allow databases (or even tables) to be password protected (and optionally encrypted).

blocks|key|1460790|text|为什么需要对数据库进行加密？用户可以很容易地反汇编你的程序，并找出密钥。如果为了网络传输而对其进行加密，那么请考虑使用PGP，而不是将加密层压缩到数据库层中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1460791|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Why do you need to encrypt the database? The user could easily disassemble your program and figure out the key. If you're encrypting it for network transfer, then consider using PGP instead of squeezing an encryption layer into a database layer.

blocks|key|1246124|text|使用SQLCipher，它是SQLite的开源扩展，为数据库文件提供透明的256位加密。http://sqlcipher.net|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1246125|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlcipher.net/^0|18|K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Use SQLCipher, it's an opensource extension for SQLite that provides transparent 256-bit AES encryption of database files. <a href="http://sqlcipher.net" rel="noreferrer">http://sqlcipher.net</a>

blocks|key|1460876|text|您可以对SQLite3数据库进行密码保护。在执行任何操作之前，请按如下方式设置密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1460877|SQLiteConnection+conn+=+new+SQLiteConnection("Data+Source=MyDatabase.sqlite;Version=3;");
conn.SetPassword("password");
conn.Open();|code-block|syntax|javascript|1460878|那么下一次你可以像这样访问它|1460879|conn+=+new+SQLiteConnection("Data+Source=MyDatabase.sqlite;Version=3;Password=password;");
conn.Open();|1460880|这将不允许任何GUI编辑器查看您的数据。如果您提供密码，某些编辑器可以解密DB。使用的算法是RSA。|1460881|稍后，如果您希望更改密码，请使用|1460882|conn.ChangePassword("new_password");|1460883|要重置或删除密码，请使用|1460884|conn.ChangePassword(String.Empty);|1460885|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

You can password protect a SQLite3 DB. Before doing any operations, set the password as follows.

<pre><code>SQLiteConnection conn = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
conn.SetPassword("password");
conn.Open();
</code></pre>

then next time you can access it like

<pre><code>conn = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;Password=password;");
conn.Open();
</code></pre>

This wont allow any GUI editor to view your data. Some editors can decrypt the DB if you provide the password. The algorithm used is RSA.

Later if you wish to change the password, use 

<pre><code>conn.ChangePassword("new_password");
</code></pre>

To reset or remove password, use 

<pre><code>conn.ChangePassword(String.Empty);
</code></pre>

blocks|key|1246196|text|我知道这是一个老生常谈的问题，但简单的解决方案不就是在操作系统级别保护文件吗？只要阻止用户访问该文件，他们就不应该能够接触到它。这只是一个猜测，我不确定这是否是一个理想的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246197|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I know this is an old question but wouldn't the simple solution be to just protect the file at the OS level? Just prevent the users from accessing the file and then they shouldn't be able to touch it. This is just a guess and I'm not sure if this is an ideal solution.

I have to face a new little project. It will have about 7 or 9 tables, the biggest of them will grow by a max rate of 1000 rows a month.

I thought about SQLite as my db... But i will need to protect the db in case anybody wants to change data from the db

My main question is:

Is it possible password protect a sqlite db as you would do on access?

What other RDBMS would you recommend for such a small solution?

The development would be on C#, but i'm searching something free.

Password Protect a SQLite DB. Is it possible?

数据库

SQLite

我必须面对一个新的小项目。它将有大约7到9个表，其中最大的表将以每月1000行的最大速度增长。我把SQLite当做我的数据库。但我需要保护数据库，以防有人想要更改数据库中的数据。我的主要问题是：是否可以像在访问时那样使用密码保护sqlite数据库？对于这么小的解决方案，您还推荐其他什么RDBMS？开发将在C#上进行，但...

问密码保护SQLite数据库。有可能吗？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问密码保护SQLite数据库。有可能吗？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问密码保护SQLite数据库。有可能吗？
EN