Wiley
Wiley.com
Print this page Share

Inside Symbian SQL: A Mobile Developer's Guide to SQLite

ISBN: 978-0-470-74402-4
Paperback
432 pages
April 2010
US $55.00 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Inside Symbian SQL: A Mobile Developer's Guide to SQLite (0470744022) cover image
Other Available Formats: E-book

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

Buy Both and Save 25%!

+

Inside Symbian SQL: A Mobile Developer's Guide to SQLite (US $55.00)

-and- Cisco Networking Essentials (US $39.99)

Total List Price: US $94.99
Discounted Price: US $71.24 (Save: US $23.75)

Add BOTH to Cart
Cannot be combined with any other offers. Learn more.