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

Summary

In this chapter, you learned how to use Xcode and PhoneGap with SQLite and HTML5. Hopefully, it has helped you to perform iOS development with these technologies, and showed you how using PhoneGap/SQLite can enhance how quickly apps can be delivered to the end user.

It is also a cross-development platform, where the source is created once and delivered to a variety of platforms in a quick-format generation method. HTML5 works with Xcode, Swift, and PhoneGap in a cohesive and quick way.

In the next chapter, we will talk about future advances, further features, and SQLite functionality. This will be useful in the development process, to get better and more controlled applications. The benefits of using one codebase for multiple platforms is very beneficial to both developers and customers. The next chapter will also be an aid and guide on how these features can be used in new and updated apps in the future.

Previous Section
End of Chapter 7
Next Chapter