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.
