Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Storing data locally > Inspecting SQLite databases

7.4. Inspecting SQLite databases

Outside of your application, there are many times when you’ll want to access and inspect your SQLite database directly. You’ll want to make sure your tables are there, and that they have the structure you intended. And you’ll want to run test queries and experiment with the results. For these times you’ll need data tools.

In the next few sections, we’ll review mymovies.db using the command-line SQLite shell and a third-party GUI tool, SQLiteManager. There are many third-party SQLite GUI tools; we’ve chosen SQLiteManager as an example because it’s cross-platform (it’s a Firefox browser extension), open source, and free.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint