Installing SQLite3 on AlmaLinux 9 from source.

SQLite is a widely used, lightweight, and embedded relational database management system (RDBMS) that supports a variety of programming languages. It is known for its portability, self-contained nature, and small size, making it a popular choice for applications that require local data storage.

Prerequisites:

• AlmaLinux 9 operating system
• Root or sudo user privileges

Steps:

1. Update the system:

dnf update -y

2. Install required packages:

The wget package is needed to download the SQLite source code from the official website. If wget is already installed, skip this step.

dnf install wget -y

3. Install the build toolchain:

The build toolchain includes various development tools required for compiling SQLite. If you are unsure about the specific packages needed, you can install the entire “Development Tools” group.

dnf groupinstall "Development Tools" -y

4. Download the SQLite source code:
5. Navigate to the SQLite download page: https://www.sqlite.org/download.html
6. Copy the link to the latest autoconf source code, which will be named in the format: sqlite-autoconf-.tar.gz
7. Download the source code using wget and extract it using tar:

wget https://www.sqlite.org/2023/sqlite-autoconf-3420000.tar.gz
tar xvfz sqlite-autoconf-version>.tar.gz

8. Rename the extracted directory to “sqlite”:

mv sqlite-autoconf-version> sqlite

9. Change to the sqlite directory:

cd sqlite

10. Build and install SQLite3:
11. Run the configure script to prepare the build environment:

./configure

12. Compile the SQLite source code:

make

13. Install SQLite:

make install

This will install the SQLite3 library system-wide.

14. Verify the installation:

Check the SQLite3 version to confirm the installation:

sqlite3 --version

This should display the installed SQLite version, such as:

3.42.0 2023-07-18 11:54:15
456j34k6j34oij64kj6543kj6kj34j6kl4j63l4kj6kl34j634643j6klj34k6j

Conclusion:

This tutorial has demonstrated the process of installing SQLite3 on AlmaLinux 9. SQLite is now ready for use in your applications.