One of the great features of SQLite is its ability to create databases while the app is running. You can quickly add or modify databases as needed.
In the following sections I will add a data model, a UI for various databases commands and to display the database schema, and the view controllers to handle the operations. The app will be able to create the database and add tables and columns as well as indexes, views, and triggers.
Building the DB Mgr App
I will continue to build on the same iPad project from the previous chapter in order to provide the functionality ...