How to Install SQLite on Debian 10

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 Debian Linux server, with sudoers or root privileges.

Installation

Update package information

Update your server’s package information 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:

# apt-get update
...
Fetched 9981 kB in 2s (4052 kB/s)
Reading package lists... Done

Install SQLite

# apt install sqlite3
...
Unpacking sqlite3 (3.27.2-3) ...
Setting up sqlite3 (3.27.2-3) ...

Verify Installation

Once that’s complete, check the version, as of this writing, we received 3.22.0:

# sqlite3 --version
3.27.2 2019-02-25 16:06:06

Start sqlite3:

# sqlite3
SQLite version 3.27.0 2018-01-22 18:45:57
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 Debian 10. 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 *