DB Browser for SQLite

SQLite is a popular database that is used by applications to store their information in a single file. Sometimes, you might need to quickly check on some information stored in such SQLite database files. That is where the DB Browser for SQLite is really useful. It is a GUI tool to open a SQLite database file and inspect its schema and data.

Installing is easy:

$ sudo apt install sqlitebrowser

If you want to install the latest version:

$ sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
$ sudo apt update
$ sudo apt install sqlitebrowser

That is it! Open sqlitebrowser and inspect your files :)

Tried with: SQLiteBrowser 3.9 and Ubuntu 16.04