This part encourages you comprehend what is SQLite, how it varies from SQL, why it is required and the manner by which it handles the applications Database.
SQLite is a product library that actualizes an independent, serverless, zero-design, conditional SQL information base motor. SQLite is one of the quickest developing information base motors around, yet that is development as far as prevalence, nothing to do with its size. The source code for SQLite is in the public area.
What is SQLite?
SQLite is an in-measure library that executes an independent, serverless, zero-design, value-based SQL data set motor. It is a data set, which is zero-designed, which means like different data sets you don't have to arrange it in your framework.
SQLite motor isn't an independent cycle like different data sets, you can interface it statically or progressively according to your prerequisite with your application. SQLite gets to its stockpiling documents straightforwardly.
Why SQLite?
-
SQLite doesn't need a different worker cycle or framework to work (serverless).
-
SQLite accompanies zero-arrangement, which implies no arrangement or organization required.
-
A total SQLite information base is put away in a solitary cross-stage circle record.
-
SQLite is little and light weight, under 400KiB completely designed or under 250KiB with discretionary highlights discarded.
-
SQLite is independent, which implies no outside conditions.
-
SQLite exchanges are completely ACID-consistent, permitting safe access from different cycles or strings.
-
SQLite bolsters the vast majority of the inquiry language highlights found in SQL92 (SQL2) standard.
-
SQLite is written in ANSI-C and gives basic and simple to-utilize API.
-
SQLite is accessible on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT).
SQLite A Brief History
-
2000 - D. Richard Hipp planned SQLite with the end goal of no organization needed for working a program.
-
2000 - In August, SQLite 1.0 delivered with GNU Database Manager.
-
2011 - Hipp declared to add UNQl interface to SQLite DB and to create UNQLite (Document arranged data set).
SQLite Limitations
There are not many unsupported highlights of SQL92 in SQLite which are recorded in the accompanying table.
Sr.No. |
Feature & Description |
---|---|
1 |
RIGHT OUTER JOIN Only LEFT OUTER JOIN is implemented. |
2 |
FULL OUTER JOIN Only LEFT OUTER JOIN is implemented. |
3 |
ALTER TABLE The RENAME TABLE and ADD COLUMN variants of the ALTER TABLE command are supported. The DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are not supported. |
4 |
Trigger support FOR EACH ROW triggers are supported but not FOR EACH STATEMENT triggers. |
5 |
VIEWs VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view. |
6 |
GRANT and REVOKE The only access permissions that can be applied are the normal file access permissions of the underlying operating system. |
SQLite Commands
The standard SQLite orders to cooperate with social information bases are like SQL. They are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These orders can be characterized into bunches dependent on their operational nature −
DDL - Data Definition Language
Sr.No. |
Command & Description |
---|---|
1 |
CREATE Creates a new table, a view of a table, or other object in database. |
2 |
ALTER Modifies an existing database object, such as a table. |
3 |
DROP Deletes an entire table, a view of a table or other object in the database. |
DML - Data Manipulation Language
Sr.No. |
Command & Description |
---|---|
1 |
INSERT Creates a record |
2 |
UPDATE Modifies records |
3 |
DELETE Deletes records |
DQL - Data Query Language
Sr.No. |
Command & Description |
---|---|
1 |
SELECT Retrieves certain records from one or more tables |