O'Reilly logo

Build iOS Database Apps with Swift and SQLite by Kevin Languedoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 Languedoc

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required