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

---

Basic SQL tutorial

INTRO:
SQL is a programming languages designed for managing data. It is used for data storage or database storage. MySQL is the most popular among database management storage system. Others are Oracle, Windows Access, PostgreSQL, SQLite etc. Database are use from Office productivity to storage of various data type.

This tutorial will cover all the basic of the above and more database system..

SQL look like this..

SELECT * FROM table

Create a database:

CREATE DATABASE test

This will create a database with name  'test'.

Create a table:

CREATE TABLE person ( `name` VARCHAR(12), `age` VARCHAR(3), `gender` VARCHAR(6) )

This will create a table with name  'person' having column  name, age, gender.

Add a data to table:

INSERT INTO person (name, age, gender) VALUES ('anil', '18', 'male')

This will add a line into the table  person  to the column  name, age, gender  with value  anil, 18, male  respectively.

Check if the data/line has been added:

SELECT * FROM person

Output:

name age gender

anil 18 male

Note:
* the number in  VARCHAR(12)  signify only 12 characters will be saved and rest omitted. If we enter a name  'verylonglongname' (16 char), the saved name will only be  'verylonglong' (12 char), last 4 char omitted.

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

---