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!
Answer from Pankaj Kumar on Stack OverflowThis 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!
Kinda old but u do have SQLite Browser on Linux. I dont get it why didnt someone paste this. for example, Ubuntu based:
For Ubuntu and derivaties, @deepsidhu1313 provides a PPA with our latest release here:
https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this ppa just type in these commands in 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 supported for now (until Launchpad decides to discontinue build for any series).
You can find rest on the home page http://sqlitebrowser.org/ Scroll down or CTRL F for linux installing :)
linux - Curses-based SQLite console browser - Software Recommendations Stack Exchange
Simple TUI SQLite Browser
How Should I Write SQLite Scripts? - Launch SQLite.exe and Execute Commands
Is there a way to convert a csv file into an sqlite file ?
My choice for browsing tabular data in the console or terminal is [Visidata] (https://www.visidata.org). It works well with SQLite and a variety of other data sources. It does allow editing data in the cells of a table, but is not great for tasks like altering table structures. It does not allow running SQL queries, but is very efficient in browsing data and manipulating it in a variety of ways.
Check the sqlectron. It comes both in GUI and in Term version.
Also there is sqlcrush.