Resources | developer.brewmp.com Resources | developer.brewmp.com

Developer

resources

dbc

Brew Mobile Platform supports dbc (Database Connectivity), a database engine available to Brew MP applications, which provides data management on a device. dbc is a wrapper around SQLite v3.6.x, which provides persistent storage in EFS, and data can be shared across applications. dbc has a set of interfaces and classes that implement them. See dbc interfaces.

Some of dbc's features are

  • Modern remoteable interface
  • Supports the SQL query language
  • Available to both Brew MP and OS Services
  • Provides equivalent functionality as ISQL
  • Uses the same database file format as ISQL
  • Features a port of SQLite 3.6.x
  • Formalized notification interface

dbc is the underlying database engine for these embedded public databases in Brew MP: Contacts, Call History, Messages, Calendar, PDI, Gallery, and Timezone Interfaces. See the Personal Information Management (PIM) Technology Guide, the Gallery Technology Guide and the Timezone Technology Guide for more information.

SQLite features

Some of the SQLite features that are available in dbc are

  • Transactional support, which provides all or nothing execution and can reduce file access count
  • Multi-access controlled by locking
  • Database integrity using journaling
  • Triggers, which are stored procedures to modify database behavior
  • SQLite database file format, which is binary compatible across platforms

For more information on SQLite, refer to http://www.sqlite.org.

Recommended SQLite Tools

Recommended tools available for analyzing SQLite databases are sqlite3.exe and SQLite Database Browser. sqlite3.exe, a command line interface, can be used for inspecting schema and executing and testing queries. It has commands to help optimize queries. SQLite Database Browser has a GUI that is useful for visualizing table contents. Even though it has some limitations, it can also execute queries.