Learning SQLite for iOS电子书

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