Mobile Applications Development
University of Science and Technology
Faculty of Computer Science & Information Technology
Department of Computer science and Information and Communication Technology
Lecture (8)
SQLite Mr. Mohanad Shahata
This content has been cited from Mr. Kirolos Tharwat’s content.
SQL and SQLite
1. Structured Query Language (SQL) :
SQL stands for Structured Query Language. SQL can access, created
and manage databases. SQL has became standard of American
National Standards Institute.
2. SQLite :
SQLite is software which provides relational database management
system. SQLite lightweight in terms of setup, database administration,
and required resources. SQLite has features like self-contained,
server-less, zero-configuration, etc
What is SQLite Database?
SQLite is another data storage available in Android where we can
store data in the user’s device and can use it any time when required.
In this article, we will take a look at creating an SQLite database in the
Android app and adding data to that database in the Android app.
What is SQLite Database?
SQLite Database is an open-source database provided in Android
which is used to store data inside the user’s device in the form of a
Text file. We can perform so many operations on this data such as
adding new data, updating, reading, and deleting this data. SQLite is
an offline database that is locally stored in the user’s device and we
do not have to create any connection to connect to this database.