Showing posts with label SQLite. Show all posts
Showing posts with label SQLite. Show all posts

Wednesday, July 4, 2018

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.


sqlite android 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.