Learning SQLite for iOS by Rocha, Gene Da -- Read -- Imperial Library of Trantor

Index

Learning SQLite for iOS

Table of Contents Learning SQLite for iOS Credits About the Author About the Reviewer www.PacktPub.com

eBooks, discount offers, and more

Why subscribe?

Preface

What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support

Downloading the example code Downloading the color images of this book Errata Piracy Questions

1. Introduction to SQL and SQLite

About SQL Where does SQLite stand in today's industry? iOS with SQLite Embedded databases The architecture of the SQLite database Features The advantages of using SQLite Working with SQLite The examples of using SQLite with iOS Summary

2. Database Design Concepts

Database essentials Reasons for using SQLite Database connections Preparing queries Parameterized SQL Error handling Queries within the db.exec statement SQL injection attacks Creating user-defined functions Transactions and locks Transactions – reading/writing Designing for SQLite Summary

3. Administering the Database

Creating a database

Creating a table Inserting data Selecting data Creating an index Exporting data

Viewing database schema data

Index data Schema data

Backing up the database Database tools Database file information Summary

4. Essentials of SQL

Transactions Query plan SQL basics

Insert with a subselect clause Update with a subselect clause Select with a subselect clause

Data integrity Default values

Constraint checking Foreign keys

Updating Views Index use Triggers Synchronous writes Database locking and deadlocks FMDB SQLite wrapper Database creation and opening SQL in iOS Summary

5. Exposing the C API

SQLite C components' functionality

sqlite3_open() sqlite3_prepare() sqlite3_step() sqlite3_column() sqlite3_finalize() sqlite3_close()

Using the C API with the open database statement Using Swift with the open database statement

load_extension() sqlite3_exec() sqlite3_config() The prepare statement

Summary

6. Using Swift with iOS and SQLite

Basic requirements Starting an Xcode Project with Swift Using the SQLite 3 Library

Using FMDB

Summary

7. iOS Development with PhoneGap and HTML5

HTML5 and PhoneGap development An HTML5 framework Hybrid applications An Xcode project with PhoneGap, HTML5, and Swift Summary

8. More Features and Advances in SQLite

PhoneGap plugins Extensions to the C API Write Ahead Logging with SQLite The B-tree usage with SQLite Creating a simple Swift Summary

Index

← Prev
Back
Next →

← Prev
Back
Next →