SQLite

From ArchWiki

From the project home page:

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

Installation

Install the sqlite package.

Related packages are:

  • sqlite-doc – most of the static HTML files that comprise this website, including all of the SQL Syntax and the C/C++ interface specs and other miscellaneous documentation [1]
  • sqlite-analyzer – sqlite3_analyzer is a command-line utility program that measures and displays how much and how efficiently space is used by individual tables and indexes with an SQLite database file [2]
  • sqlite-tcl – the Tcl interface to the SQLite library [3]
  • php-sqlite – sqlite3 module for PHP (do not forget to enable it in /etc/php/php.ini)
  • ruby-sqlite3 – Ruby bindings for the SQLite3 embedded database
  • gambas3-gb-db-sqlite3 – Gambas3 Sqlite3 database access component

Using sqlite3 command line shell

The SQLite library includes a simple command-line utility named sqlite3 that allows the user to manually enter and execute SQL commands against an SQLite database.

Create a database

$ sqlite3 databasename

Create table

sqlite> create table tblone(one varchar(10), two smallint);

Insert data

sqlite> insert into tblone values('helloworld',20);
sqlite> insert into tblone values('archlinux', 30);

Search database

sqlite> select * from tblone;
helloworld|20
archlinux|30

See the sqlite docs.

Software

  • DB Browser for SQLite — High quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
https://sqlitebrowser.org/ || sqlitebrowser
  • Sqliteman — Simple sqlite3 browser and editor.
http://sqliteman.yarpen.cz/[dead link 2023-05-06 ⓘ] || sqlitemanAUR
  • litecli — A command line interface for SQLite with auto-completion and syntax highlighting.
https://litecli.com/ || litecliAUR

For tools supporting multiple DBMSs, see List of applications/Documents#Database tools.

Using sqlite in shell script

See forum post.

See also