SQLite is a lightweight database software. It is a command line application. You must use the command line or SQLite API on other programming languages to use SQLite database. SQLite has a graphical front end SQLite Browser for working with SQLite databases graphically.
SQLite 3 is the latest version at the time of this writing. SQLite 3 is available in the official package repository of Ubuntu 18.04 LTS. SQLite Browser is also available in the official package repository of Ubuntu 18.04 LTS.
In this article, I will show you how to install SQLite 3 and SQLite Browser on Ubuntu 18.04 LTS. I will also show you some of the basic queries of SQLite 3. Let’s get started.
Installing SQLite 3
First update the apt package repository cache with the following command:
The apt package repository cache should be updated.
Now to install SQLite 3, run the following command:
$ sudo apt-get install sqlite3
SQLite 3 should be installed.
Now you can check whether SQLite 3 is
working with the following command:
Installing SQLite Browser
Run the following command to install SQLite Browser:
Now press y and then press <Enter>.
SQLite Browser should be installed.