在LINUX上安装和配置SQlite浏览器(Installing and configuring SQlite Browser on LINUX)

在LINUX上安装和配置SQlite浏览器(Installing and configuring SQlite Browser on LINUX)

我是Linux新手，我不知道如何在Linux操作系统中安装sqlite-autoconf-3070400和SQlite数据库浏览器。 请详细说明步骤。 我想要它用于Android开发。 那么我需要一些额外的？

---

这是关于查看数据库的问题。 我问这个问题，因为我不知道如何查看数据库内容。 我意识到并使用了其他数据库，所以我认为SQlite也可能有一个GUI。 当我得到我的答案，并为未来添加。 所以说老实话，这个问题就会降低。

I am new to Linux, and I don't know how to install sqlite-autoconf-3070400 and SQlite database browser in my Linux OS. Please give step wise details. I want it for Android Development. So do I need some extra?

---

This was the question about to view database. I asked this question because I had no idea how can I view db contents. I was aware and used other DB so was thinking that there might be a GUI for SQlite too. As I got my answer and added too for future. So be honest while downvoting this question.

最满意答案

这是SQlite浏览器的替代解决方案......（实际上所有的LINUX机器都已经准备好了SQlite，你只需要SQlite的图形用户界面，Sqlite数据库浏览器是预定义的选项，但是当你无法安装它时（比如我） ...你必须添加插件到Firefox。你可以从http://code.google.com/p/sqlite-manager/下载它 并安装此插件（下载后）按“Ctrl + O”>选择下载的文件>打开>安装。

现在重新启动Firefox后，转到工具> SQLite管理器>打开它并选择您的数据库打开并执行您的工作。

---

更新sqlite3

---

Android已经给出了一个非常好的工具，它是sqlite3 。 你可以在sdk/tool/目录下找到这个工具。

介绍 ：-

从adb远程shell中，可以使用sqlite3命令行程序来管理由Android应用程序创建的SQLite数据库。 sqlite3工具包含许多有用的命令，例如.dump用于打印表格的内容并用.schema打印现有表格的SQL CREATE语句。 该工具还使您能够即时执行SQLite命令。

要使用sqlite3 ，请在模拟器实例上输入远程shell，如上所述，然后使用sqlite3命令调用该工具。 或者，在调用sqlite3时，您可以指定要探索的数据库的完整路径。 仿真器/设备实例将SQLite3数据库存储在文件夹/data/data/<package_name>/databases/ 。

这是一个例子：

adb -s emulator-5554 shell # sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db SQLite version 3.3.12 Enter ".help" for instructions .... enter commands, then quit... sqlite> .exit

一旦你调用了sqlite3 ，你可以在shell中发出sqlite3命令。 要退出并返回到adb远程shell，请使用exit或CTRL+D

阅读更多信息从远程shell检查sqlite3数据库

快乐的编码！

This is alternative solution for SQlite browser... (Actually all LINUX machines having SQlite allready, You need only GUI of SQlite. Sqlite database browser is predefined option. But when you unable to install it(like me) then go for this another solution ... You have to add addon to firefox. You can download it from http://code.google.com/p/sqlite-manager/ and for installing this addon (after downloaded it) press "ctrl+o" > choose downloaded file > open > install.

Now after restarting Firefox, go to Tools > SQLite Manager > open it and choose your database to open and do your work.

---

Update for sqlite3

---

Android has given a very good tool, which is sqlite3. You can find this tool into sdk/tool/ directory.

Introduction :-

From an adb remote shell, you can use the sqlite3 command-line program to manage SQLite databases created by Android applications. The sqlite3 tool includes many useful commands, such as .dump to print out the contents of a table and .schema to print the SQL CREATE statement for an existing table. The tool also gives you the ability to execute SQLite commands on the fly.

To use sqlite3, enter a remote shell on the emulator instance, as described above, then invoke the tool using the sqlite3 command. Optionally, when invoking sqlite3 you can specify the full path to the database you want to explore. Emulator/device instances store SQLite3 databases in the folder /data/data/<package_name>/databases/.

Here's an example:

adb -s emulator-5554 shell # sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db SQLite version 3.3.12 Enter ".help" for instructions .... enter commands, then quit... sqlite> .exit

Once you've invoked sqlite3, you can issue sqlite3 commands in the shell. To exit and return to the adb remote shell, use exit or CTRL+D.

Read more at Examining sqlite3 databases from a remote shell

Happy coding!