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


Try SQL queries with SQLite

Trying SQL queries in SQLite

If you need to try or test some SQL queries in a flash, then there is no better option than SQLite. Almost all mainstream database engines are huge pieces of software requiring installation and configuration before they can be used. SQLite is tiny and ready to use right out of the box.

Download the SQLite zip file for Windows and unzip it. Run the sqlite3.exe file and your database engine is already running! Type SQL queries at its prompt and terminate every query with a semicolon. Have fun playing around with SQL queries 🙂

Tried with: SQLite 3.7.14