Database Widget

Many apps store data in a small embedded database called SQLite. It’s built into both Android and iOS, and iOS Core Data framework uses it internally. If your app uses SQLite, the data will be stored in a file. You can configure your App Model to display the data in a database file, then users can easily just browse the database tables and the data in them.

SQLite Viewing

When a support session is active, any configured databases will be at the bottom of the left panel. Users who click on a database will see its list of tables in the center panel and the data in a selected table next to it. Paging Next and Previous buttons (at the top) can be used to move through the data set. This page does not update itself, but each time you click on a table or page control, the data shown is pulled directly from the app (that is, it’s not cached or stale).

web-session-db

SQLite Configuration

Assume your app has a SQLite database called “catalog.db” (that’s the file included in our sample app). The first step is to add it to the App Model. Select the tab “Models” then click on the Model for your app. On the Model details page, click Edit Model.

web-model

Now scroll down to Databases and add the filename. If the database is not in the root directory, put the path relative to the root. (You can find the file path by doing a support session to the app and looking in the file browser.)

web-model-edit

Type in the filename or relative path such as “data/products/pricing.db” and click Add Database. To remove a database, click the x on an existing one. Now scroll to the bottom of the page and Save Model.