How to Install SQLite on CentOS 7

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It’s a popular solution for applications that need to use on-disk files formatted as lightweight databases to run efficiently.

Prerequisites

  • Access to an CentOS 7 Linux server, with sudoers or root privileges.

Installation

Update packages and information

Update your server’s packages before you get started. For many of these Linux commands, you will receive multiple screens of output that this guide will shorten to ‘…’, but here are the relevant messages to look out for:

# yum update
...
Determining fastest mirrors
...
Resolving Dependencies
...
Install    1 Package  (+6 Dependent packages)
...
Is this ok [y/d/N]:

Press ‘y’

...
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
...
Is this ok [y/N]:

Press ‘y’

...
Complete!

Install SQLite

# yum install sqlite
...
Package sqlite-3.7.17-8.el7.x86_64 already installed and latest version

Verify Installation

Once that’s complete, check the version, as of this writing, we installed 3.7.17:

# sqlite3 --version
SQLite version 3.7.17 2013-05-20 00:56:22

Start sqlite3:

# sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

Exit from the sqlite3 shell using .exit or .quit.

Conclusion

In this article, you learned how to install SQLite on CentOS 7. Next steps should include opening your desired sqlite files in its shell, or configuring your application to use your new SQLite instance.

Leave a Reply

Your email address will not be published. Required fields are marked *