In this chapter, you learned how to administer and look after the SQLite relational database system, which has shown you in a simple way how to look after the database for your application. This chapter showed some of the basic elements of the SQLite database. It has covered the essentials of table creation and viewing tables that make up the schema. The topics are enough to get a grasp of the subject and master the basics. This chapter covers the basic elements and gave a helping hand to administer this easy-to-use database for mobile development. This chapter also summarizes how easy it is to administer as compared to other databases in the market. There are additional tools for SQLite Administration that can be found on the web. There are many more commands and not all have been shown as examples in this chapter. These are some of the methods of using and administering SQLite. This chapter showed you what is possible when you learn a few commands and how it can help use this simple, mobile database.
In the next chapter, you will learn all about the essentials of SQL. The chapter will outline how SQL can be used properly on this mobile database. It will show you how to use the SQLite method of using SQL compared to other databases and how easy it is to pick up SQL with SQLite.