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.
- Access to an CentOS 7 Linux server, with sudoers or root privileges.
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]:
... Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7 ... Is this ok [y/N]:
# yum install sqlite ... Package sqlite-3.7.17-8.el7.x86_64 already installed and latest version
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
# 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.
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.