44
What is SQLite?
Entity : something inside of our database system.
Table : a set of rows, held in memory
Row : a set of columns that collectively describe an entity.
Column : an individual piece of data stored in a table
database systems
A relational model of data for large shared data banks
. This paper proposed that data be represented as a set of tables.DSL
for manipulating data in a relational model. This language eventually led to the creation of SQL. So SQL is the language that we use inside of relational database systems to manipulate data.do not be mislead by the lite in the name. SQLite is a full featured SQL implementation
. So we now know this means it is a database systems that implements the relational data model and uses SQL to manipulate data.Room Library
to create and manipulate data on Android.1) Compile time verification : this means that if we have an error in our queries we will know about it immediately.
2) Convenient annotations : easy to use
@
annotations that minimize the amount of boiler code that we have to write.3) Migration : streamlined database migration paths.
1) Database Class : this class holds and represents the main access point to our applications persisted data.
2) Data Entities : represent tables in our app's database system.
3) Database Access Objects (DAO) : provides methods that our app can use to query, update, insert and delete data in the database system
44