This last chapter will focus on the different tools the SQLite platform provides to help you analyze your app's databases. Except for the ANALYZE statement, which can be executed with the sqlite3_exec command, the other tools are external software programs. Specifically, in this chapter we will discuss and explore, through examples, the following technologies:
The ANALYZE statement
The sqldiff tool
The sqlite3_analyzer tool
Other than the ANALYZE statement, which we will explore in Swift, all the other tools are external tools that can help you analyze your databases for ...