All geek questions in one place

Installing and Configuring SQlite Browser on LINUX

I am new to Linux and I do not know how to install sqlite-autoconf-3070400 and the SQlite database browser on my Linux OS. Please provide details. I want this for Android Development. So what do I need some more?

It was a question about browsing the database. I asked this question because I had no idea how I could view the contents of db. I knew and used a different database, so I thought there could be a GUI for SQlite too. When I received my answer and also added for the future. So be honest if you discuss this issue.

+4
source share
3 answers

This is an alternative solution for the SQlite browser ... (In fact, all LINUX machines that have SQlite allready, you only need the SQlite GUI. The Sqlite database browser is predefined, but if you cannot install it (for example, I), then go to to this other solution ... You must add the addon to firefox. You can download it from http://code.google.com/p/sqlite-manager/
and to install this addon (after downloading it) press "ctrl + o"> select the downloaded file> open> install.

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

Update for sqlite3

Android has provided a very nice tool, which is sqlite3. This tool can be found in the sdk/tool/ directory.

Introduction: -

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

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

Here is 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

After calling sqlite3 you can issue sqlite3 in the shell. To exit and return to the remote adb shell, use exit or CTRL+D

Read more about Exploring sqlite3 Databases from a Remote Shell

Happy coding!

+14
source

Pretty long time ago, but you have SQLite Browser on Linux. I do not understand why someone did not put this in. e.g. Ubuntu:

For Ubuntu and derivatives, @ deepsidhu1313 provides our PPP with our latest version:

 https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser

To add this ppa, simply enter these commands in the terminal:

 sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser

Then update the cache using:

 sudo apt-get update

Install the package using:

 sudo apt-get install sqlitebrowser

Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are currently supported (until Launchpad decides to stop building for any series).

You can find relaxation on the home page http://sqlitebrowser.org/ Scroll down or CTRL F to install Linux :)

+3
source

Here are the commands needed to execute SQLite Browser

 sudo apt-get install qt4-qmake cmake libsqlite3-dev libqt4-dev libqt4-core libqt4-qt3support wget http://optimate.dl.sourceforge.net/project/sqlitebrowser/sqlitebrowser/3.2/sqlitebrowser-3.2.0.tar.gz tar -xvf sqlitebrowser-3.2.0.tar.gz cd sqlitebrowser-sqlb-3.2.0/ qmake make
+1
source

Source: https://habr.com/ru/post/1334464/

More articles:


All Articles