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 Debian Linux server, with sudoers or root privileges.
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
# apt install sqlite3 ... Unpacking sqlite3 (3.27.2-3) ... Setting up sqlite3 (3.27.2-3) ...
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
# 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.
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.