Chapter 2. Getting Started

 

A journey of a thousand miles starts with a single step.

 
 --Lao-tzu

Symbian SQL is easy to learn and straightforward to use. This chapter aims to provide everything needed to start using it. The first section in this chapter provides details of where and how to get Symbian SQL. Basic database operations are then demonstrated in a console application example. Finally, the location of additional documentation is listed.

Where to Get Symbian SQL

Symbian SQL is included with SDKs based on Symbian OS v9.3 onwards, including all Symbian Foundation releases. From the device perspective, Symbian SQL is included in S60 3rd Edition Feature Pack 2 onwards. For users of S60 3rd Edition Feature Pack 1, Symbian SQL can be downloaded in a SIS file from the Symbian Foundation developer website at developer.symbian.org. Additional releases may be supported in the future. Please check the wiki page for this book (developer.symbian.org/wiki/index.php/InsideSymbianSQL) for more details.

Overview of Symbian SQL APIs

Symbian SQL consists of two main classes along with other classes used for streaming binary large objects (BLOBs), binding columns, defining security polices and providing utility functions.

The two most important classes are as follows:

  • RSqlDatabase enables a client to create, open and attach to a database and to execute queries which do not require data to be returned (e.g. INSERT queries).

  • RSqlStatement enables a client to execute queries, including ones which return ...

Get Inside Symbian SQL: A Mobile Developer's Guide to SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.