O'Reilly logo

Inside Symbian SQL: A Mobile Developer's Guide to SQLite by Richard Maynard, Ivan Litovski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required