Chapter 6

1. H2 is an open source Java database that is very lightweight. It can be embedded in Java applications. It also runs on the client-server model.
2. A resource means how data will be represented in REST architecture. It allows a client to read, write, modify, and create resources using HTTP methods, for example GET, POST, PUT, DELETE, and so on.
3. CRUD stands for Create, Read, Update, and Delete.
4. DAO is an abstraction of data persistence. Repository is an abstraction of a collection of objects.
5. SQLite uses dynamic typing. Content can be stored as INTEGER, REAL, TEXT, BLOB, or NULL.
6. Alternatives to the SQLite database are OrmLite, Couchbase Lite, and Snappy DB.
7. The standard SQLite commands are SELECT, CREATE, INSERT, UPDATE, DROP, and DELETE.
8. There are some disadvantages of SQLite. They are as follows:
   • It is used to handle low-to-medium traffic HTTP requests.
   • The size of SQLite...