How To Install Sqlite3?

How To Install Sqlite3?

sqlite3

The command-line interface to SQLite 3, which is a self-contained file-based embedded SQL engine.

Maintainer: Laszlo Boszormenyi (GCS)



Section: database

Install sqlite3

  • Debian apt-get install sqlite3 Click to copy
  • Ubuntu apt-get install sqlite3 Click to copy
  • Alpine OS apk add sqlite Click to copy
  • Arch Linux pacman -S sqlite Click to copy
  • Kali Linux apt-get install sqlite3 Click to copy
  • CentOS yum install sqlite Click to copy
  • Fedora dnf install sqlite Click to copy
  • Raspbian apt-get install sqlite3 Click to copy
  • macOS brew install sqlite Click to copy

The command-line interface to SQLite 3, which is a self-contained file-based embedded SQL engine.

How to use sqlite3?

Below are few example commands for sqlite3 that you can use in the terminal.

Start an interactive shell with a new database:
sqlite3Click to copy
Open an interactive shell against an existing database:
sqlite3 path/to/database.sqlite3Click to copy
Execute an SQL statement against a database and then exit:
sqlite3 path/to/database.sqlite3 'SELECT * FROM some_table;'Click to copy
To install the latest version of sqlite3 in your favorite operating system just copy the sqlite3 installation command from above and paste it into terminal. It will download and install the latest version of sqlite3 2024 package in your OS.