How to install SQLite on OpenSUSE 15.2 / 15.1?

Windows Articles

How to install KVM on Debian 10?

Hello friends, in this post I will show you how to install KVM on Debian 10. KVM stands for...

How to open Windows 10 Mobility Center

Hello! There are many types of users of Windows 10. As it depends on the type of hardware used. That is, the...

Ubuntu 20.04.1 available

Canonical, the company led by Mark Shuttleworth, releases Ubuntu 20.04.1. It has a new image, with updates and security patches for the...

How to install Linux Kernel 5.8 on Ubuntu 20.04?

Upgrading the Linux Kernel can be a beneficial task, but it is always optional. Recently we talked about the Linux Kernel 5.8...

How to activate XPS Viewer in Windows 10

Hey, what's up! When working with Windows 10 we probably use a lot of files. Indeed, these files have many extensions. For...
angeloma
angeloma
Senior Writer and partner

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
1.- Adding the database repository on OpenSUSE 15.2 / 15.1
1.- Adding the database repository on OpenSUSE 15.2 / 15.1

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
2.- Change the repository priority
2.- Change the repository priority

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
3.- Add the GPG key
3.- Add the GPG key

Now we are ready to install SQLite on OpenSUSE 15.2 / 15.1:

:~$ sudo zypper in sqlite3
4.- Install SQLite on OpenSUSE 15.1
4.- Install SQLite on OpenSUSE 15.1

And you can check the installed version to realize that we will have SQLite ready for work:

:~$ sqlite3 -version
5.- SQLite on OpenSUSE 15.2 / 15.1
5.- SQLite on OpenSUSE 15.2 / 15.1

So, now if you’re ready to start working with SQLite and OpenSUSE 15.2 / 15.1

Conclusion

SQLite is a small and lightweight but quite powerful database manager. Using it together with OpenSUSE guarantees a fast and powerful development environment.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to install KVM on Debian 10?

Hello friends, in this post I will show you how to install KVM on Debian 10. KVM stands for...

How to open Windows 10 Mobility Center

Hello! There are many types of users of Windows 10. As it depends on the type of hardware used. That is, the...

Ubuntu 20.04.1 available

Canonical, the company led by Mark Shuttleworth, releases Ubuntu 20.04.1. It has a new image, with updates and security patches for the...

How to install Linux Kernel 5.8 on Ubuntu 20.04?

Upgrading the Linux Kernel can be a beneficial task, but it is always optional. Recently we talked about the Linux Kernel 5.8...

How to activate XPS Viewer in Windows 10

Hey, what's up! When working with Windows 10 we probably use a lot of files. Indeed, these files have many extensions. For...