From Symbian Developer Community

Inside Symbian SQL

From the back cover

Inside Symbian SQL, by Ivan Litovski and Richard Maynard, is the definitive guide for Symbian C++ developers looking to use Symbian SQL in applications or system software.

Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Structured Query Language (SQL) tutorial. The book also provides a detailed overview of the Symbian SQL APIs. From the outset, you will “get your hands dirty” writing Symbian SQL code. The book includes snippets and examples that application developers can immediately put to use to get started quickly.

For device creators and system software developers, Inside Symbian SQL offers a unique view into the internals of the implementation and a wealth of practical advice on how to make best and most efficient use of the Symbian SQL database. Several case studies are presented – these are success stories 'from the trenches', written by Symbian engineers.

• The book assumes no prior knowledge of databases
• Includes detailed and approachable explanations of database concepts
• Easy to follow SQL tutorial with SQLite examples
• Unique view into the Symbian SQL internals
• Troubleshooting section with solutions to common problems

Written by the Symbian engineers who implemented SQLite on Symbian, with more than 40 years combined Symbian C++ experience, this book is for anyone interested in finding out more about using a database on Symbian.

Find out more...

• Sample chapter
• Errata for this book
• Online references
• Discount code

Buy the book

The book is available from the publisher, John Wiley & Sons, from February 26th 2010.

Alternatively, you can purchase the book from your preferred internet reseller, for example Amazon.co.uk

Developer Resources

• How To Use Symbian SQL provides a guide to using the Symbian SQL API
• How to Optimize Symbian SQL Server Usage describes how to make optimal use of Symbian SQL
• Symbian Press booklet on Data Sharing and Persistence with Symbian C++ has a section on Symbian SQL
• Symbian SQL Guide documentation for Symbian ^1
• Symbian SQL Guide documentation for Symbian^3
• Symbian SQL Reference documentation for Symbian^3
• Landing page for Persistent Data Services (persistentdata) package
• Wiki page for the Persistent Data Services package

Example code

Code from the book can be found at these locations:

• SqlExample - This is available from the Symbian Developer Library. The example code demonstrates how to create, attach and query a Symbian SQL database.
• Chapter 2 example code demonstrates main database operations in simplest terms. This is a buildable console project.
• Example databases and scripts for Chapters 3 and 4.
• Wikipedia Application - This S60 application uses Symbian SQL to query a database storing 2.2million Wikipedia article abstracts. The application and its source code are available from Symbian Foundation developer website. More details about this application will be given in Chapter 9.

Comments

Sign in to comment…