For smart phones, Mobile OS has greatly evolved from Palm OS in 1996 to Windows pocket PC in 2000 then to Blackberry OS and Android. Android is a software bunch comprising not only operating system but also middleware and key applications. Android is a powerful Operating System supporting a large number of applications in Smart Phones. These applications make life more comfortable and advanced for the users. Hardware’s that support Android are mainly based on ARM architecture platform.SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasis scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.
SQLite does not compete with client/server databases. SQLite competes with fopen().
SQLite is an Open Source database. SQLite database stores data to a text file on a device .SQLite supports standard relational database features like SQL syntax, transactions and prepared statements. The database requires limited memory at runtime (approx. 250 KB) which makes it a good candidate from being embedded into other runtimes. SQLite supports the data types TEXT, INTEGER and REAL. All other types must be converted into one of these fields before getting saved in the database. SQLite itself does not validate if the types written to the columns are actually of the defined type, e.g. you can write an integer into a string column and vice versa.
SQLite in Android
SQLite is embedded into every Android device. Using a SQLite database in Android does not require a setup procedure or administration of the database. You only have to define the SQL statements for creating and updating the database. Afterwards the database is automatically managed for you by the Android platform. Access to a SQLite database involves accessing the file system. This can be slow. Therefore it is recommended to perform database operations asynchronously. If your application creates a database, this database is by default saved in the directory DATA/data/APP_NAME/databases/FILENAME.
Situations Where SQLite Works Well
1] Embedded devices and the internet of things and Application file format
2] Websites Data analysis and File archives
3] Cache for enterprise data and Server-side database
4] Replacement for ad hoc disk files and Internal or temporary databases
5] Stand-in for an enterprise database during demos or testing
6] Experimental SQL language extensions and Education and Training