打开受密码保护的 sqlite 数据库 [英] Open a password protected sqlite database

问题描述

我创建了一个受密码保护的 sqlite 数据库.我希望能够查看数据库，以便我可以检查在我的项目开发过程中是否正确插入了内容.我已经下载了 sqlite 数据库浏览器，但这似乎无法让您打开加密的数据库.

I have created a password protected sqlite database. I want to be able to view the database so that I can check that things are being inserted correctly during the development of my project. I have downloaded the sqlite database browser but this doesn't seem to let you open an encrypted database.

有没有办法打开数据库文件.

Is there a way that I can open the database file.

感谢您提供的任何帮助.

Thanks for any help you can provide.

推荐答案

免费的 SQLite2009 Pro 浏览器让你打开 SQLite使用 System.Data.SQLite 加密的数据库.

The free SQLite2009 Pro browser will let you open SQLite databases which were encrypted with System.Data.SQLite.

当您打开文件时，您会收到一条警告，指出该文件已加密或不是数据库，然后系统会提示您选择加密类型，请选择RSA".

When you open the file you get a warning saying that the file is encrypted or not a database, and are then prompted to select an encryption type, select "RSA".

您可能会发现 SQLite2009 Pro 不如 sqliteadmin(它不会打开用 System.Data.SQLite 加密的数据库).我刚刚发现它在尝试打开其中一个视图有问题的数据库时崩溃了.

You may find SQLite2009 Pro is not as reliable as sqliteadmin (which does not open databases encrypted with System.Data.SQLite). I just found it crashed upon trying to open a database which had a problem with one of the views.

我结束了删除加密，并用sqliteadmin，它没有崩溃，而是在有问题的视图上放了一个小红叉.多棒的感觉:-)

I ended up removing the encryption, and opening it with sqliteadmin, which did not crash but instead put a little red cross over the view which had a problem. What a nice touch :-)

这篇关于打开受密码保护的 sqlite 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！