1) What are the advantages of storing data in a SQLite database? 2. What makes SQLite an appropriate choice for an Android application, compared to other relational database management systems, such as MySQL and SQL Server? 3. What are the limitations of SQLite compared to server database management systems, such as MySQL and SQL Server? 4. How can you leverage your MySQL skills to learn how to work with a SQLite database?

 

Answer:

Advantages of SQLite :

SQLite has higher performance

SQLite database can also be queried and the data retrieval is much more robust.

Cross-session undo/redo can be implemented using triggers.

There is no file parsing and generating code to write and debug.

Database over File Storage

SQLite is an open source and lightweight database administration system that takes a small amount of disk storage so it is an excellent choice of developers to develop a new application for Android. It is the first choice of developers because

Zero configuration database

Don't have server

Open source

Single file database

SQLite is used in Android to implement persistent databases on the device. It's very useful for content providers, for example (even though you can use any kind of architecture behind a provider).

Sqlite is very light version of SQL supporting many features of SQL. Basically is been developed for small devices like mobile phones, tablets etc.

SQLite is a third party ,open-sourced and in-process database engine. SQL Server Compact is from Microsoft, and is a stripped-down version of SQL Server.They are two competing database engines.

SQL is query language. Sqlite is embeddable relational database management system.