In this chapter, we are going to introduce you to administering the SQLite database and make you aware of the different components of this relational database system that best suits the mobile or tablet devices. SQLite is an embedded SQL engine and simply reads and writes to ordinary disk files instead of having a separate server process. It was designed for this purpose and is much easier to maintain and look after.
Apart from being a great database for programmers, SQLite is also an easier database to administer and maintain. There is no configuration or setup required to administer this database. It comes with a standard command-line interface (CLI) client that is available to administer the database(s).
There is a variety of languages that work with SQLite which are easier to maintain and add new functionality.
The following are the features of SQLite:
SQLite is one of the most easy-to-learn databases, is easy to interact with, and gets on with the task...