In focus

Introduction To SQLite

In this article, we will learn about the basic concepts of SQLite. SQLite is a popular relational database engine.

Akhilesh Kumar Mar 26, 2016

SQLite is a popular relational database engine. It is a software library. SQLite developers call it self-contained and serverless. SQLite is a public-domain source code. SQLite implements most of the SQL-92 standard for SQL. It implements most of the SQL-92 standard for SQL Lnguage. These are absolutely free for private or commercial use. SQLite was written in the C language. All data is required to implement the database stored in an alone, cross-platform disk file. So far as SQLite is self-contained, it requires few external libraries and little support from the OS. It accesses storage files directly.

Serverless - It doesn’t demand distinct server process or system to move with SQLite.

Zero Configuration - In zero configuration which means administration needed or no setup.

Self-Contained - A solitary library contains the whole database framework, which coordinates directly into a host application.

Transactional - SQLite exchanges are completely ACID-consistent, permitting safe access from numerous procedures or threads.

Cross-Platform - Unix (Linux, Mac OS-X, Android, IOS) and windows (Win32, WinCE, WinRT) are supported out of the container, easy to port to different frameworks.

Uses for SQLite

  • Application File format
  • Database For Gadgets
  • Small and medium size Website Database
  • Stand-in for an Enterprise RDBMS
How to install SQLite on Windows

Go to download SQLite database. Download SQLIte.

Follow the following steps

Step 1 - You need to download only "Precompiled Binaries for Windows" file for windows.

sqlite

Step 2 - Extract the downloaded zip file.

sqllite

Step 3 - Copy SQLite.exe file and paste in C/SQLIte folder.

img

Step 4 - Open your sqlite3.exe, to reach SQLite directory.
setupsqlite

Now, this will open SQLite command prompt directory.

sqlitesetup

SQLite Data Type

In SQLite, each column, variable and expression are related to data type. If you create a table in SQLite uses these data types.

SQLite Storage Classes

Each value stored in an SQLite database in the following storage classes

Storage ClassDescription
 Integer The Value is a marked number, Stored in 1,2,3,4,6, or 8 bytes depend upon the magnitude of the quality.
 Null It is NULL Value.
 Real The value is a floating point value, stored as an 8-byte IEEE floating point number.
 Text The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
 Blob The value is a blob of information, put away precisely as it was      data.

Boolean Data Type

SQLite does not have a different Boolean data storage class. It qualities are put away as whole number 0 for false and 1 for true.

Date and Time Data Type

SQLite is capable of storing dates and times as TEXT, REAL or INTEGER values because it does not have separate date and time classes. User can choose any type of format storing date and times given the following

 Storage Class Date Format
 Text A date in a format like "YYYY-MM-DD HH:MM:SS.SS
 Integer The value of seconds through 1970-01-01 00:00:00 UTC
 Real 
The value of days through noonday in Greenwich on November  24, 4714 B.C.

database framework software sqlite

COMMENT USING