SQLite is a Relational Database Management System (RDMS). but unlike other RDMS, it does not require a ceentral server to be run or client to access the process. and lightweight. due to its small size it is use in various application, Operating System, Embedded System etc. The best part of it, it is in Public Domain. Which mean any software maker, individual or software company can use and impliment it into their application. SQLite is use in various open source and closed source system.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
- sqlite.org
-
SQLite is use in various software appication:
- Mozilla Firefox
- Google Chrome
- Opera
- Ruby On Rails
- Adobe System and more..
-
SQLite is also use in various OS:
- NetBSD
- OpenBSD
- Apple iOS
- Google Android
- Windows Phone 8
- Symbian OS
- BlackBerry 10 OS and more..
Despite it small size, it implement almost all SQL standard query. but few features are missing, like 'ALTER TABLE'.
A short tutorial
# Checking SQLite version:
sqlite3 -version
-- Loading resources from /home/user/.sqliterc
3.7.15.2 2013-01-09 11:53:05 c0e09560d26f0a6456be9dd3447f5311eb4f238f
# Getting Usage help:
sqlite3 -help
# Create a database 'foo.db' :
This will create the foo.db (empty database) and drop to sqlite shell.
sqlite3 foo.db
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
# To create a table, we will run an SQL query:
a table 'person' will be created with column name & age.
# Display all tables in the database:
Or similar tables..
sqlite> CREATE TABLE person (name VARCHAR(12), age VARCHAR(3));
# Display all tables in the database:
sqlite> .tables
sqlite> .tables ??TABLE??
# Adding data to table:
sqlite> INSERT INTO person VALUES ('jack', '50');
sqlite> INSERT INTO person ('name') VALUES ('henry');
# Displaying the inserted data:
sqlite> SELECT * FROM person;
SQLite can also read SQL query from a text file.
sql.txt
# To run SQL query that is given in sql.txt .
sql.txt
select * from person;
select * from person where name='john';
# To run SQL query that is given in sql.txt .
sqlite> .read sql.txt
To manipulate any data in the databases the user will have to run SQL query. This author guess that the reader has prior knowledge of SQL query.
# To exit SQLite shell:
sqlite> .quit
sqlite> .exit