An Intro on SQLite

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' :

sqlite3 foo.db

This will create the foo.db (empty database) and drop to sqlite shell.

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:

sqlite> CREATE TABLE person (name VARCHAR(12), age VARCHAR(3));

a table 'person' will be created with column name & age.

# Display all tables in the database:

sqlite> .tables

Or similar 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

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

Disclaimer:
Tutorial above are only for educational purposes. The author will not take any liability for any damage cause, either software or hardware, by use, misuse or improper use of tutorial above.

update: 28th September 2013

---