How To Install Sqlite On Ubuntu 16.04

SQLite is a free, lightweight relational database management system (RDBMS) in a C library. SQLite is not a client-server database engine. Instead, it is embedded into the end program. Primarily all programming languages support SQLite, which how languages embed the program is with a file with .sqlite3/.sqlite/.DB extension. The software is a popular choice for local/client storage such as web browsers, Android devices, and much more. The list is quite extensive.

SQLite Browser is a graphical and free software platform for developing and designing SQLite databases.

The following guide will show you how to install the latest SQLite3 and Browser on Ubuntu 20.04.

Prerequisites

Ubuntu OS installed, the guide is installing the software on Ubuntu 20.04 Focal. However, Ubuntu 20.10 and 21.04 the guide will work for also. Before installing, make sure you are up to date on your system.

                sudo apt update && sudo apt upgrade

Install SQLite3

Ubuntu's default library comes with SQLite. Enter the following command to install the apt package.

                sudo apt install sqlite3

The following packages will be installed.

                Reading package lists… Done  Building dependency tree         Reading state information… Done  Suggested packages:    sqlite3-doc  The following NEW packages will be installed:    sqlite3  0 upgraded, 1 newly installed, 0 to remove and 3 not upgraded.  Need to get 860 kB of archives.  After this operation, 2,803 kB of additional disk space will be used.

Install SQLite3 Browser

After you have installed the SQLite3 database package, now you can install the GUI Browser. This is a simple program that makes it easier to navigate the databases.

Install SQLite3 Browser with the following command.

                sudo apt install sqlitebrowser

The following packages will be installed with SQLite3 Browser.

                ~$ sudo apt install sqlitebrowser -y  Reading package lists… Done  Building dependency tree         Reading state information… Done  The following additional packages will be installed:    libdouble-conversion3 libpcre2-16-0 libqscintilla2-qt5-15 libqscintilla2-qt5-l10n libqt5core5a libqt5dbus5 libqt5gui5 libqt5network5 libqt5printsupport5 libqt5svg5 libqt5widgets5 libqt5xml5    libxcb-xinerama0 libxcb-xinput0 qt5-gtk-platformtheme qttranslations5-l10n  Suggested packages:    libqscintilla2-doc qt5-image-formats-plugins qtwayland5  The following NEW packages will be installed:    libdouble-conversion3 libpcre2-16-0 libqscintilla2-qt5-15 libqscintilla2-qt5-l10n libqt5core5a libqt5dbus5 libqt5gui5 libqt5network5 libqt5printsupport5 libqt5svg5 libqt5widgets5 libqt5xml5    libxcb-xinerama0 libxcb-xinput0 qt5-gtk-platformtheme qttranslations5-l10n sqlitebrowser  0 upgraded, 17 newly installed, 0 to remove and 3 not upgraded.  Need to get 13.4 MB of archives.  After this operation, 58.5 MB of additional disk space will be used.

Launch SQLite3 Browser

To launch the database browser, first, go to your Ubuntu application menu and find the program.

Finally, you will see the result with the browser. Here you can adjust, create and modify your SQL lite databases.

You have successfully installed SQLite 3 and SQLite 3 Browser.

Comments and Conclusion

The guide has shown you the setup for installing the browser and the database. For more information on how to build applications with SQLite, visit the SQLite 3 Tutorial.net guide. Overall, SQLite 3 is basic but powerful. However, it is fine for small to medium websites for large growing websites to look at MariaDB, MongoDB and PostgreSQL, among many other options.