Difference between revisions of "SQLite"

From ArchWiki
Jump to: navigation, search
m (Style)
(Added the Sqlite Browser Package to the list as its a great too i use day to day.)
 
(10 intermediate revisions by 7 users not shown)
Line 1: Line 1:
 
[[Category:Database management systems]]
 
[[Category:Database management systems]]
 
+
[[ja:Sqlite]]
 
From the [http://www.sqlite.org/ project home page]:
 
From the [http://www.sqlite.org/ 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.''
 
: ''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.''
Line 25: Line 25:
 
== Installation ==
 
== Installation ==
  
[[pacman|Install]] {{Pkg|sqlite}} from the [[official repositories]].
+
[[Install]] the {{Pkg|sqlite}} package.
  
 
Related packages are:
 
Related packages are:
 
* {{Pkg|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
 
* {{Pkg|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
* {{Pkg|php-sqlite}} - sqlite3 module for PHP (don't forget to enable it in /etc/php/php.ini)
+
* {{Pkg|php-sqlite}} - sqlite3 module for PHP (do not forget to enable it in {{ic|/etc/php/php.ini}})
* {{Pkg|gambas2-gb-db-sqlite3}} - Gambas2 Sqlite3 database access component
+
* {{Pkg|gambas3-gb-db-sqlite3}} - Gambas2 Sqlite3 database access component
* {{Pkg|sqliteman}} - The best developer's and/or admin's GUI tool for Sqlite3 in the world
+
* {{Pkg|sqliteman}} - Developer and/or admin GUI tool for Sqlite3
 +
* {{Pkg|sqlitebrowser}} - DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
  
 
== Using sqlite3 command line shell ==
 
== Using sqlite3 command line shell ==
Line 39: Line 40:
 
==== Create a database ====
 
==== Create a database ====
  
  sqlite3 ''databasename''
+
  $ sqlite3 ''databasename''
  
 
==== Create table ====
 
==== Create table ====
Line 54: Line 55:
 
  sqlite> select * from tblone;
 
  sqlite> select * from tblone;
 
  helloworld|20
 
  helloworld|20
  rchlinux|30
+
  archlinux|30
  
 
See the [http://www.sqlite.org/sqlite.html sqlite docs].
 
See the [http://www.sqlite.org/sqlite.html sqlite docs].
Line 62: Line 63:
 
See forum [https://bbs.archlinux.org/viewtopic.php?id=109802 post].
 
See forum [https://bbs.archlinux.org/viewtopic.php?id=109802 post].
  
== ESee also ==
+
== See also ==
  
 
* [http://www.sqlite.org SQLite homepage]
 
* [http://www.sqlite.org SQLite homepage]

Latest revision as of 13:48, 2 February 2016

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.

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

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
  • php-sqlite - sqlite3 module for PHP (do not forget to enable it in /etc/php/php.ini)
  • gambas3-gb-db-sqlite3 - Gambas2 Sqlite3 database access component
  • sqliteman - Developer and/or admin GUI tool for Sqlite3
  • sqlitebrowser - DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

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.

Using sqlite in shell script

See forum post.

See also