{"id":14039,"date":"2022-01-18T18:22:18","date_gmt":"2022-01-18T18:22:18","guid":{"rendered":"https:\/\/linuxways.net\/?p=14039"},"modified":"2022-01-18T18:22:18","modified_gmt":"2022-01-18T18:22:18","slug":"how-to-install-sqlite-on-debian-11","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/debian\/how-to-install-sqlite-on-debian-11\/","title":{"rendered":"How to Install SQLite on Debian 11"},"content":{"rendered":"

Written in C language, SQLite<\/a> is a lightweight and fully-featured software library that provides an SQL database engine. Unlike conventional relational databases such as PostgreSQL and SQL, SQLite is serverless and does not require any configuration. Also, give its serverless architecture, it does not have a daemon or proceess that needs to be started or stopped. SQLite requires minimal support from external libraries or from the operating system. As such it is ideal for use in embedded devices such s smartphones, gaming consoles, portable media players etc.<\/p>\n

Let us check out how you can install SQLite on Debian 11.<\/p>\n

Method 1: Install SQLite via APT<\/strong><\/h2>\n

SQLite can be found in the default debian 11 repositories. Install it using APT as follows:<\/p>\n

$ sudo apt install sqlite3<\/strong><\/pre>\n
Confirm the version of sqlite installed with the command:<\/p>\n
$ sqlite3 --version<\/strong><\/pre>\n
<\/strong><\/p>\n
The output confirms that we are running SQLite 3.34.1. However, this is not the latest version of SQL. If you want to install the latest SQLite version, you need to install it from source as we shall demonstrate in the next method.<\/p>\n
Method 2: Compile and Install SQLite from source<\/strong><\/h2>\n
To install the latest version, consider manually compiling the source code.<\/p>\n
First, install basic compiler packages. Run:<\/p>\n
$ sudo apt install build-essential<\/strong><\/pre>\n
Then, create a directory to hold SQLite3 and its contents:<\/p>\n
$ mkdir \/opt\/sqlite3<\/strong><\/pre>\n
Thereafter, head over to the official SQLite download page and grab the latest binary file.<\/p>\n
$ wget https:\/\/www.sqlite.org\/2022\/sqlite-autoconf-3370200.tar.gz<\/strong><\/pre>\n
<\/strong><\/p>\n
At the time of writing this guide, the latest version of SQLite is 3.37.2. Extract the archive file as shown:<\/p>\n
$ tar xvfz sqlite-autoconf-3370200.tar.gz<\/strong><\/pre>\n
Next, move the decompressed folder to the directory you created above.<\/p>\n
$ sudo mv sqlite-autoconf-3370200 \/opt\/sqlite3<\/strong><\/pre>\n
Next, navigate to the SQLite folder.<\/p>\n
$ cd \/opt\/sqlite3\/sqlite-autoconf-3370200<\/strong><\/pre>\n
The next step is to start the compiling process by executing the command:<\/p>\n
$ .\/configure<\/strong><\/pre>\n
<\/strong><\/p>\n
After that, start the build process with the make command as shown:<\/p>\n
$ make -j 2<\/strong><\/pre>\n
The -j represents the number of cores present in your system. This helps you speed up the build process. To verify the number of CPU cores present on your system, invoke the nproc command:<\/p>\n
$ nproc<\/strong><\/pre>\n
Finally, initiate the build process to install SQLite 3 as follows:<\/p>\n
$ sudo make install<\/strong><\/pre>\n
Now confirm the version of SQLite installed with the command:<\/p>\n
$ sqlite3 --version<\/strong><\/pre>\n
<\/strong><\/p>\n
The version installed is more recent as compared to the one installed via APT.<\/p>\n
Testing SQLite<\/strong><\/h2>\n
Now that SQLite is successfully installed on our system, we can go ahead and create a database to test the installation. Run:<\/p>\n
$ sqlite3 new_db<\/strong><\/pre>\n
<\/strong><\/p>\n
You can now type in your SQL commands in the SQLite command line as shown above.<\/p>","protected":false},"excerpt":{"rendered":"
Written in C language, SQLite is a lightweight and fully-featured software library that provides an SQL database engine. Unlike conventional relational databases such as PostgreSQL and SQL, SQLite…<\/p>","protected":false},"author":1,"featured_media":14139,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[521,855],"class_list":["post-14039","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian-11","tag-sqlite"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=14039"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14039\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/14139"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=14039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=14039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=14039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}