SQLite

 

The very first thing anyone should know about “SQLite” is that the “Lite” in SQLite does not refer to its capabilities or limitations. It’s just called “Lite” because the of its simple usage and “lite” size.

Benefits of SQLite:

  • Serverless – SQLite does not have a client/server relationship. The entire database is integrated into whatever application needs access to it.
  •  NO setup required – Unlike MySQL server setup, there is nothing you need to do server side when in comes to installation
  • Small runtime – should be self explanatory
  • uses dynamic-type system in SQLite (this means that data types aren’t restricted to any column/row e.g number, date, string,etc)

This simplicity makes it easy to use with smart phones, touch pads, etc where no traditional database system can reach.This works easily because SQLite is built right into the application itself.

Learning SQLite

SQLite is very easy to setup and easy to use. It also uses the core of SQL language and best of all it requires no server setup or administration.

You can download SQLite at: www.sqlite.org/download.html

Short comings to SQL Lite

-No real time replication

-Not ideal for extremely large datasets – because SQ Lite is 1 file if a large dataset is crunched into  1 file it may not be wise to use SQ Lite.

 

Basics of SQL

It’s been a while since I touched databases. I was looking for some of the notes I made on SQL way back, but after about a couple minutes of not being able to find it, I just Googled my way to the basics that is essential to SQL.

Here are the essentials followed by some examples I made myself:

Selecting Data
select column1, column2, column3
from table name
where “condition” (e.g first LIKE, age > 24, etc)

Example:
SELECT First, Last, EmpID
FROM employinfo
WHERE age>30;

Creating Tables
CREATE  table name
(first varchar(15),
last var char (18),
empid number(5),
ssnum number (9) );

Datatypes:
char(size)
date
number (size) or number(size,d) where d is the digits to the right of decimal
varchar(size)

Updating:
UPDATE table name
SET columname = newname
WHEREcolumnar = previous name;

Example:
UPDATE employinfo
SET name = Josh
WHERE name = John

Delete:
DELETE from table name
WHERE column name = ‘value';

Example:
DELETE from employinfo
WHEREname = ‘Josh';