SQL LITE TUTORIALS

This instructional exercises helps you to comprehend what is SQLite, how it contrasts from SQL, why it is required and the route in which it handles the applications Database. 

SQLite is a product library that actualizes an independent, serverless, zero-setup, value-based SQL database motor. SQLite is one of the quickest developing database motors around, however that is development as far as fame, not anything to do with its size. The source code for SQLite is in people in general space. 

What is SQLite? 

SQLite is an in-procedure library that executes an independent, serverless, zero-setup, value-based SQL database motor. It is the one database, which is zero-designed, that implies like other database you don't have to arrange it in your framework. 

SQLite motor is not a standalone procedure like different databases, you can interface it statically or progressively according to your prerequisite with your application. The SQLite gets to its stockpiling documents straightforwardly. 

Why SQLite? 

SQLite does not require a different server procedure or framework to operate.(serverless). 

SQLite accompanies zero-arrangement, which implies no setup or organization required. 

A complete SQLite database 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 components discarded. 

SQLite is independent, which implies no outside conditions. 

SQLite exchanges are completely ACID-agreeable, permitting safe access from numerous procedures or strings. 

SQLite underpins a large portion of the inquiry dialect highlights found in the SQL92 (SQL2) standard. 

SQLite is composed in ANSI-C and gives basic and simple to-use API. 

SQLite is accessible on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT). 

History: 

2000 - D. Richard Hipp had composed SQLite with the end goal of no organization required for working a project. 

2000 - In August SQLite 1.0 discharged with GNU Database Manager. 

2011 - Hipp declared to add UNQl interface to SQLite DB and to create UNQLite (Document situated database). 

SQLite Limitations: 

There are couple of unsupported elements of SQL92 in SQLite which are demonstrated as follows: 

Feature Description 

RIGHT OUTER JOIN Only LEFT OUTER JOIN is executed. 

FULL OUTER JOIN Only LEFT OUTER JOIN is executed. 

Modify TABLE The RENAME TABLE and ADD COLUMN variations of the ALTER TABLE order are bolstered. The DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT not upheld. 

Trigger support FOR EACH ROW triggers are bolstered yet not FOR EACH STATEMENT triggers. 

VIEWs VIEWs in SQLite are perused as it were. You may not execute a DELETE, INSERT, or UPDATE proclamation on a perspective. 

Award and REVOKE The just get to consents that can be connected are the ordinary document access authorizations of the fundamental working framework. 

SQLite Commands: 

The standard SQLite charges to interface with social databases are comparable as SQL. They are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These charges can be ordered into gatherings in light of their operational nature: 

DDL - Data Definition Language: 

Command Description 

CREATE Creates another table, a perspective of a table, or other article in database 

ALTER Modifies a current database article, for example, a table. 

DROP Deletes a whole table, a perspective of a table or other article in the database. 

DML - Data Manipulation Language: 

Command Description 

INSERT Creates a record 

UPDATE Modifies records 

DELETE Deletes records 

DQL - Data Query Language: 

Command Description 

SELECT Retrieves certain records from one or more tables