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

PhoneGap plugins

Before starting to develop a software for PhoneGap with SQLite, the environment must be set up properly for the PhoneGap framework to work correctly with SQLite. The PhoneGap environment will enable the SQLite database to be set up and connected with Xcode, toward the end, to produce an iOS application.

There is also a native SQLite plugin for PhoneGap, called Brodysoft (refer to https://build.phonegap.com/plugins/2368), that provides an interface for the storage and usage of the standard Web SQL database standards.

As the demand for mobile technology, mobile apps, and mobile development grows, the need for further advancement, with products such as PhoneGap, will be demanding the following, for example:

  • PhoneGap will have increased application size limits

  • It will have support for different plugins, including the Cordova plugins repository plugins.cordova.io

  • Additional PhoneGap plugins may not have to go through an approval process and can be approved easily

  • There will be a facility...

Previous Section
End of Section 2
Next Section