Menu

How to Install SQLite on Debian 10 (Legacy Guide)

Install SQLite on Debian 10 for an existing system. Official Debian LTS ended in June 2024; use a supported release for new deployments.

Posted on By Updated on
On this page

This guide preserves the package-based SQLite installation steps for an existing Debian 10 (Buster) system.

Legacy system: Debian’s official LTS for Debian 10 ended on June 30, 2024. Third-party Extended LTS is separate and may cover only selected packages. Do not choose Debian 10 for a new deployment; use a supported release such as Debian 12 and its SQLite installation guide. See the Debian announcement.

Prerequisites

Before you begin the installation, make sure you have the following:

  1. Debian 10: Ensure you have a working Debian 10 installation.
  2. Terminal: Access to the terminal or command line interface with sudo privileges.

Now that you have the prerequisites in place, let’s proceed with the installation.

Step 1: Refresh the package index

Refresh APT’s package index so it can find the SQLite package:

sudo apt update

This updates package metadata; it does not provide additional security updates for Debian 10.

Step 2: Install SQLite

SQLite is available in the Debian package repository. You can easily install it using the apt package manager. To do this, run the following command:

sudo apt install sqlite3

The system will prompt you to confirm the installation. Type ‘y’ and press Enter to proceed.

Step 3: Verify the Installation

To verify that SQLite has been successfully installed, you can check the version of SQLite by running the following command:

sqlite3 --version

You should see the installed SQLite version in the output.

Step 4: Start Using SQLite

With SQLite installed, you can start using it right away. To open an interactive SQLite prompt, simply type:

sqlite3

This will open a new SQLite shell where you can execute SQL commands and manage your databases.

Conclusion

You’ve successfully installed SQLite on your Debian 10 system. You can now use SQLite to create, manage, and query databases for your applications. This lightweight database management system is highly versatile and can be used for a wide range of projects. If you’re new to SQLite, be sure to explore its documentation and tutorials to harness the full power of this powerful database system.

Happy coding!