SQLite Limitation

Some Feature not Supported in SQLite

Feature	Support	Not Support
Right Outer Join	No	Only Left Outer Join
Full Outer Join	No	Only Left outer Join
Alter Table	·     Rename Table ·     Add Column ·     Alter Table commands are supported	·     Drop Column ·     Alter Column ·     Add Constraint Above commands are not supported
View	Yes(Read Only)	But View is read only You can’t execute following command in view ·     Delete ·     Insert ·     Update

SQL Server :: SQLite

                                                                           SQLite

Define:

      SQLite is an embedded relational database engine.

Other Names:

•          Self –Contained(no external dependencies)
•          Server Less
•          Zero – Configuration
•          Transactional Sql Database Engine

The SQLite engine is not a standalone process. Instead, it is statically or dynamically linked into the application

History:

•  Started Year 2000
•  SQLite was written in the C Programming language

Why SQLite?

•          The SQLite library is small
•          No Server
•          No installation
•          It is require less than 300 KIB
•          SQLite located any ware in  directory
•     Cross platform file, it can be used various operating system(MAC OS,Windows,Linux,Unix)