© Kevin Languedoc 2016

Kevin Languedoc, Build iOS Database Apps with Swift and SQLite, 10.1007/978-1-4842-2232-4_12

12. Analyzing SQLite Databases

Kevin Languedoc1 

(1)Montreal, Canada

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 ...

Get Build iOS Database Apps with Swift and SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial