Development Guide

Local Navigation

BlackBerry Manuals & Help  >  Developer Documentation  >  Java Development Guides and API Reference  >  Development Guide Data Storage - BlackBerry Java SDK - 7.0

Viewing SQLite databases

SQLite® database viewers are available from third-party vendors. These viewers can be useful aids to your database development process. Database viewers are especially useful for viewing changes to a database. When you run an SQL statement, you can see the result in the database viewer immediately.

An SQLite database viewer runs on your computer, not on the smartphone. To use the viewer, configure the BlackBerry Smartphone Simulator to emulate a microSD card. When you run your application, your database viewer reads the database from a folder on your computer.

Note: SQLite database viewers cannot work on encrypted databases. You can encrypt the database after you complete your SQLite application.

Simulate a media card

To view SQLite® databases in a database viewer, you might have to configure the BlackBerry® Smartphone Simulator to emulate a media card. By default, database files are stored on a media card.
  1. Create a folder on your computer to store emulation files for the media card.
  2. In the BlackBerry® Smartphone Simulator, on the Simulate menu, click Change SD Card.
  3. Click Add Directory.
  4. Navigate to and click the folder you created.
  5. Click OK.
  6. Click Close.
Next topic: Security of SQLite databases
Previous topic: Storing data in SQLite databases

Was this information helpful? Send us your comments.