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 WindowsGo to download SQLite database.
Download SQLIte.Follow the following steps
Step 1 - You need to download only "Precompiled Binaries for Windows" file for windows.
Step 2 - Extract the downloaded zip file.
Step 3 - Copy SQLite.exe file and paste in C/SQLIte folder.
Step 4 - Open your sqlite3.exe, to reach SQLite directory.
Now, this will open SQLite command prompt directory.
SQLite Data TypeIn 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 Class | Description
|
| 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 TypeSQLite 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 TypeSQLite 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. |