From ArchWiki
Revision as of 05:19, 15 December 2010 by Crouse (Talk | contribs) (A quick overview of sqlite3)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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.


SQLite's homepage is: http://www.sqlite.org/


From: http://www.sqlite.org/features.html

   Transactions are atomic, consistent, isolated, and durable even after system crashes and power failures.
   Zero-configuration - no setup or administration needed.
   Implements most of SQL92. 
   A complete database is stored in a single cross-platform disk file.
   Supports terabyte-sized databases and gigabyte-sized strings and blobs. 
   Small code footprint: less than 325KiB fully configured or less than 190KiB with optional features omitted.
   Faster than popular client/server database engines for most common operations.
   Simple, easy to use API.
   Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
   Well-commented source code with 100% branch test coverage.
   Available as a single ANSI-C source-code file that you can easily drop into another project.
   Self-contained: no external dependencies.
   Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and WinCE) are supported out of the box. Easy to port to other systems.
   Sources are in the public domain. Use for any purpose.
   Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.


pacman -S sqlite3

Related Packages

   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
   sqlite3 module for PHP
   Gambas2 Sqlite3 database access component
   The best developer's and/or admin's GUI tool for Sqlite3 in the world

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 archdatabase
 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;

See the sqlite docs: http://www.sqlite.org/sqlite.html

Using sqlite in shell script

See forum post: https://bbs.archlinux.org/viewtopic.php?id=109802

External Links

Using SQLite - Oreilly Book
SQLITE - Apress Book