How to install SQLite on OpenSUSE 15.2 / 15.1?

Windows Articles

Monitoring Ubuntu 20.04 with Stacer

Normally if we use Linux on a production server, it is important to monitor it. On the other hand, in everyday use, many users...

How to get the Android 11 Notification Panel

It's no secret that even though Android is the most widely used mobile operating system. Not always our device has the latest...

How to create backups in Windows 10 with FileFort Backup

There is no doubt that the computer is an essential element in our lives. Indeed, its uses go beyond work or study....

Trisquel 9.0 available

Trisquel is a GNU/Linux distribution endorsed and supported by the Free Software Foundation. This means that in addition to incorporating the Linux...

How to install PandoraFMS on CentOS 8?

Worldwide many IT infrastructures are running Linux on one of their servers. This opens the door to an endless number of different...
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

Monitoring Ubuntu 20.04 with Stacer

Normally if we use Linux on a production server, it is important to monitor it. On the other hand, in everyday use, many users...

How to get the Android 11 Notification Panel

It's no secret that even though Android is the most widely used mobile operating system. Not always our device has the latest...

How to create backups in Windows 10 with FileFort Backup

There is no doubt that the computer is an essential element in our lives. Indeed, its uses go beyond work or study....

Trisquel 9.0 available

Trisquel is a GNU/Linux distribution endorsed and supported by the Free Software Foundation. This means that in addition to incorporating the Linux...

How to install PandoraFMS on CentOS 8?

Worldwide many IT infrastructures are running Linux on one of their servers. This opens the door to an endless number of different...
x