SQLite is a file-based SQL database system.
- download the “command line shell” for “sqlite3” from
SQLite download page.
For Windows download
- create a directory where you want to install sqlite3 (e.g.
- extract the archive (only one file on windows:
- move the content of the archive to the directory created
%SCRIBESTOOLS%\SQLiteto the path.
On Ubuntu you can install SQLite as following:
sudo apt-get install sqlite3
You can test the installation and check the version of sqlite3 with the following command:
This should launch the SQLite shell. Try the following commands:
.help .schema .quit
Since no database has been specified when launching the shell command the
.schema command will not display anything.
Sqlite3 for django¶
If you use SQLite with django, then you can launch the shell with the following commands:
python manage.py dbshell
The documentation is available online (SQLite documentation).
To get some help about the command line type:
If you want some brief help about the shell commands (including SQL) you can type in the shell:
More generally, the documentation of the shell is available at https://www.sqlite.org/cli.html