Difference between revisions of "SQLite"

From ArchWiki
Jump to: navigation, search
(A quick overview of sqlite3)
 
m (Related Packages)
(12 intermediate revisions by 6 users not shown)
Line 1: Line 1:
===About===
+
[[Category:Database management systems]]
 +
== About ==
 
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 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.
  
===HomePage===
+
== Features ==
SQLite's homepage is: http://www.sqlite.org/
+
From: [http://www.sqlite.org/features.html SQLite Features]
 +
* 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.
  
===Features===
+
== Installation ==
From: http://www.sqlite.org/features.html
+
$ pacman -S sqlite
    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.
 
  
===Installation===
+
=== Related Packages ===
<b>pacman -S sqlite3</b>
+
* '''extra/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
 +
* '''extra/php-sqlite''' - sqlite3 module for PHP (don't forget to enable it in /etc/php/php.ini)
 +
* '''community/gambas2-gb-db-sqlite3''' - Gambas2 Sqlite3 database access component
 +
* '''community/sqliteman''' - The best developer's and/or admin's GUI tool for Sqlite3 in the world
  
===Related Packages===
+
== Using sqlite3 command line shell ==
    core/sqlite3-doc
+
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.
    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
 
   
 
    extra/php-sqlite
 
    sqlite3 module for PHP
 
   
 
    community/gambas2-gb-db-sqlite3
 
    Gambas2 Sqlite3 database access component
 
   
 
    community/sqliteman
 
    The best developer's and/or admin's GUI tool for Sqlite3 in the world
 
  
===Using sqlite3 command line shell===
+
==== Create a database ====
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.
+
sqlite3 archdatabase
  
  <b>Create a database</b>
+
==== Create Table ====
    sqlite3 archdatabase
+
sqlite> create table tblone(one varchar(10), two smallint);
  
  <b>Create Table</b>
+
==== Insert Data ====
    sqlite> create table tblone(one varchar(10), two smallint);
+
sqlite> insert into tblone values('helloworld',20);
 
+
sqlite> insert into tblone values('archlinux', 30);
  <b>Insert Data</b>
 
    sqlite> insert into tblone values('helloworld',20);
 
    sqlite> insert into tblone values('archlinux', 30);
 
  
  <b>Search Database</b>
+
==== Search Database ====
    sqlite> select * from tblone;
+
sqlite> select * from tblone;
    helloworld|20
+
helloworld|20
    archlinux|30
+
rchlinux|30
  
See the sqlite docs: http://www.sqlite.org/sqlite.html
+
See the [http://www.sqlite.org/sqlite.html sqlite docs].
  
===Using sqlite in shell script===
+
== Using sqlite in shell script ==
See forum post: https://bbs.archlinux.org/viewtopic.php?id=109802
+
See forum [https://bbs.archlinux.org/viewtopic.php?id=109802 post]
  
===External Links===
+
== External Links ==
http://www.squidoo.com/sqlitehammer<br>
+
* [http://www.sqlite.org SQLite homepage]
[http://oreilly.com/catalog/9780596521196 Using SQLite - Oreilly Book]<br>
+
* [http://www.squidoo.com/sqlitehammer SQLite Hammer]
[http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/1590596730 SQLITE - Apress Book]<br>
+
* [http://oreilly.com/catalog/9780596521196 Using SQLite - Oreilly Book]
 +
* [http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/1590596730 SQLite - Apress Book]

Revision as of 09:29, 27 January 2013

About

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.

Features

From: SQLite Features

  • 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.

Installation

$ pacman -S sqlite

Related Packages

  • extra/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
  • extra/php-sqlite - sqlite3 module for PHP (don't forget to enable it in /etc/php/php.ini)
  • community/gambas2-gb-db-sqlite3 - Gambas2 Sqlite3 database access component
  • community/sqliteman - 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;
helloworld|20
rchlinux|30

See the sqlite docs.

Using sqlite in shell script

See forum post

External Links