Introduction to SQLite

Android SQLite Database Tutorial

SQLite is a reliable and fully featured, SQL database engine. It is a light weight relational database management system in terms of setup and required resource.

It is an embedded database software that stores local/client in application software. Unlike other databases, SQLite doesn't require any configuration. Thus, it is a zero-configured database.

Applications of SQLite

Some applications that uses SQLite are as follows:

• Adobe
• Apple
• Bosch
• McAfee
• Skype

Advantages of SQLite

There are 5 advantages of SQLite are as given Below:

• Serverless - It doesn't required server to access the database files.
• Common table expression - SQLite supports common table expression that represents temporary named result set.
• Portable - It's applications can be used in all operating systems.
• Light weight - It is light weight database, so it can be used easily with various devices.
• Public Domain - The source code of SQLite is in public domain that puts down the claim of any copyright.

Disadvantages of SQLite

• Limited access of database – In most cases, the size of database is restricted up to 2 GB.
• Unsupportive for Multi-user application – The performance of SQLite degrades when same database is accessed by multiple clients simultaneously.