There are many good database management systems, but they are not all the same. And the fact that they are not, means that we have to choose which one suits our needs best. For example, MySQL and MariaDB are very powerful but they are managed on a service basis. This doesn’t make them recommendable for portable applications. However, there is another player that is SQLite. So today I’m going to show you how to install SQLite on OpenSUSE 15.2 / 15.1.
According to the project’s website, “SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.” Also, it is open-source.
The great feature of SQLite is that it is easily implemented in mobile applications. That is to say since it is not managed as a service, it makes it possible for our applications to move along with the database.
On the other hand, SQLite boasts that it is the most used database manager in the world, and if we take into account the great number of mobile applications, we can believe it.
With this, it becomes important to know how to install it in a Linux distribution as popular among developers as OpenSUSE 15.2 / 15.1.
Install SQLite on OpenSUSE 15.2 / 15.1
At the time of writing this post, the latest stable version of SQLite is 3.30.1. Fortunately, it is available in the Database repository of OpenSUSE 15.2 /15.1. So the installation is quite simple.
First, open a terminal session and run the following, to add the repository:
For OpenSUSE 15.2:
:~$ sudo zypper addrepo https://download.opensuse.org/repositories/server:database/openSUSE_Leap_15.2/ database
For OpenSUSE 15.1:
:~$ sudo zypper addrepo https://download.opensuse.org/repositories/server:database/openSUSE_Leap_15.1/ database
Then, you have to change the priority of the repository to make sure that you always install SQLite from there.
:~$ sudo zypper mr -p 70 database
In the end, you have to refresh all the repositories to load the information. At this point, as it is the first time you have used the repository, you will be asked to accept the GPG key.
:~$ sudo zypper refresh
Now we are ready to install SQLite on OpenSUSE 15.2 / 15.1:
:~$ sudo zypper in sqlite3
And you can check the installed version to realize that we will have SQLite ready for work:
:~$ sqlite3 -version
So, now if you’re ready to start working with SQLite and OpenSUSE 15.2 / 15.1
SQLite is a small and lightweight but quite powerful database manager. Using it together with OpenSUSE guarantees a fast and powerful development environment.