Litovski / Maynard Inside Symbian SQL

A Mobile Developer's Guide to SQLite
1. Auflage 2010
ISBN: 978-0-470-74475-8
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 432 Seiten, E-Book

This is the definitive guide for Symbian C++ developers looking touse Symbian SQL in applications or system software.
Since Symbian SQL and SQLite are relatively new additions to theSymbian platform, Inside Symbian SQL begins with anintroduction to database theory and concepts, including aStructured Query Language (SQL) tutorial.
Inside Symbian SQL also provides a detailed overview ofthe Symbian SQL APIs. From the outset, you will "get yourhands dirty" writing Symbian SQL code. The book includessnippets and examples that application developers can immediatelyput to use to get started quickly.
For device creators and system software developers, InsideSymbian SQL offers a unique view into the internals of theimplementation and a wealth of practical advice on how to make bestand most efficient use of the Symbian SQL database. Several casestudies are presented - these are success stories 'from thetrenches', written by Symbian engineers.
Special Features:
* The book assumes no prior knowledge of databases
* Includes detailed and approachable explanations of databaseconcepts
* 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 onSymbian, with more than 40 years combined Symbian C++ experience,this book is for anyone interested in finding out more about usinga database on Symbian.

Autoren/Hrsg.

Litovski, Ivan

Maynard, Richard

Inhaltsverzeichnis

Foreword by Richard Hipp.
Foreword by Chris Dudding.
Author Biographies.
Author's Acknowledgments.
Symbian Acknowledgments.
Publisher's Acknowledgements.
1 Introduction.
1.1 Where Should You Start?
1.2 Symbian Terminology and Version Numbering.
1.3 The Relational Model and the Structured Query Language (SQL)2.
1.4 What Is Symbian SQL?
1.5 A Well-Oiled Machine.
1.6 Tools and Troubleshooting.
1.7 Further Reading and Resources.
2 Getting Started.
2.1 Where to Get Symbian SQL.
2.2 Overview of Symbian SQL APIs.
2.3 First Database Example.
2.4 Summary.
3 The Relational Model.
3.1 Background.
3.2 The Structural Component.
3.3 The Integrity Component.
3.4 Normalization.
3.5 The Manipulative Component.
3.6 The Meaning of Relational.
3.7 Summary.
4 Everything You Ever Wanted to Know about SQL but WereAfraid to Ask.
4.1 The Relational Model.
4.2 The Example Database.
4.3 Syntax.
4.4 Creating a Database.
4.5 Querying a Database.
4.6 Modifying Data.
4.7 Data Integrity.
4.8 Transactions.
4.9 Database Administration.
4.10 Summary.
5 Database Concepts.
5.1 Database Types.
5.2 Executing SQL.
5.3 Multi-Client Access.
5.4 Summary.
6 Using Symbian SQL.
6.1 The Database Connection Class.
6.2 The Prepared Statement Class.
6.3 Working with Variable-Length Data Objects.
6.4 The Scalar Query Class.
6.5 Security Policies.
6.6 Summary.
7 SQLite Internals on Symbian.
7.1 Why SQLite Is Right for Symbian.
7.2 The SQLite Modules.
7.3 SQLite Configuration Options.
7.4 SQLite Optimizations on Symbian OS.
7.5 Summary.
8 Performance Tuning.
8.1 Design and Development Considerations.
8.2 An Introduction to Optimization.
8.3 Optimizing Applications.
8.4 Symbian SQL Optimization Tips.
8.5 Summary.
9 Using Symbian SQL: Three Case Studies.
9.1 Contacts Model.
9.2 Columbo Search Service.
9.3 Wikipedia Demo Application.
9.4 Summary.
Appendix A Troubleshooting.
Appendix B SDB Database Creation Tool.
Appendix C Symbian SQL Error Codes.
References.
Index.