SQLITE

SQLite is an embedded relational database engine. According to its developers this C language based light – weight database engine is server less, zero-configuration. That is why traditional & complex database engines are set aside by the SQLite. It supports the basic characteristics of relational database like SQL syntax, etc. This engine is used in the Solaris 10 and Mac OS besides iPhone, Skype. SQLite is internally used in Firefox, Chrome browsers. The SQLite can be used across various operating systems. SQLite is an open source database.

It supports various tokens like text, integer etc. SQLite is a database engine designed with an objective to keep database design and management as simple as possible.

SQLite is the backbone of every android device as far as the database related issues are concerned.

SQLite is “ACID” compliant which means safe access to its database from multiple threads using modifications through transactions, which ensures consistency resulting into sustenance during the power failure.

The SQLite library is connected in and so it has become the most crucial part of the application program; however the library can also be called dynamically. The app uses SQLite’s working by means of the simplest function calls, which lowers latency in database access: function calls within a maiden process are more methodical as compared with the inter – process communication. SQLite stocks the database (definitions, indices, data, tables) as a single cross platform file on a host machine.