Book Image

Learning SQLite for iOS

By : Gene Da Rocha
Book Image

Learning SQLite for iOS

By: Gene Da Rocha

Overview of this book

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple's iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoothly using SQL commands. You will be able to extend the functionality of SQLite by using its vast arsenal of C API calls to build some interesting, exciting, new, and intelligent data-driven applications. Understand how Xcode, HTML5, and Phonegap can be used to build a cross-platform modern app which can benefit from all these technologies - all through creating a complete, customizable application skeleton that you can build on for your own apps.

Related Content you might be interested in

Current Title:

Small book image
Learning SQLite for iOS
Gene Da Rocha
Mar, 2016 | 154 pages
Small book image
Learning Swift
Andrew J Wagner
Mar, 2016 | 308 pages
Small book image
PhoneGap Essentials
Ivan Turkovic
Sep, 2015 | 178 pages
Small book image
Creating Dynamic UIs with Android Fragments
Jim Wilson
Mar, 2016 | 154 pages
Table of Contents (15 chapters)
Learning SQLite for iOS
Learning SQLite for iOS
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Introduction to SQL and SQLite
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 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
Administering the Database
Creating a database
Viewing database schema data
Backing up the database
Database tools
Database file information
Summary
4
Essentials of SQL
Essentials of SQL
Transactions
Query plan
SQL basics
Data integrity
Default values
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
Exposing the C API
SQLite C components' functionality
Summary
6
Using Swift with iOS and SQLite
Using Swift with iOS and SQLite
Basic requirements
Starting an Xcode Project with Swift
Using the SQLite 3 Library
Summary
7
iOS Development with PhoneGap and HTML5
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
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
Index

Hybrid applications

There are some misconceptions about the use of hybrid HTML5 apps. Users think that hybrid applications cannot store offline data in a database such as SQLite. Hybrid apps can work online and offline. They do not need to be connected all the time for it to work. PhoneGap with HTML5 gives more facilities, functionalities, and options.

The standard storage mechanism for HTML5 apps is the local storage on the device itself, that is, the database used is SQLite. If you are not connected online, data can be stored locally. Once the database is connected, it will upload data from the local database.

A common thought is that HTML5 is out of its league when it comes to native. However, today, in-app purchases, Game Centre, executing background tasks, accessing the GPS and the camera, and even Bluetooth, can be accessed via HTML5. PhoneGap is used where a native wrapper is required for an HTML5 app. There are some differences in the way native and hybrid/cross-development apps work...

Previous Section
End of Section 4
Next Section