Learning SQLite for iOS

Extend SQLite with mobile development skills to build great apps for iOS devices
Preview in Mapt

Learning SQLite for iOS

Gene Da Rocha, MSc, BSc (Hons)

1 customer reviews
Extend SQLite with mobile development skills to build great apps for iOS devices
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $23.99
Save 58%
Print + eBook
$29.99
RRP $29.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$29.99
$29.99 p/m after trial
RRP $23.99
RRP $29.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Learning SQLite for iOS Book Cover
Learning SQLite for iOS
$ 23.99
$ 10.00
iOS 11 Programming for Beginners - Second Edition Book Cover
iOS 11 Programming for Beginners - Second Edition
$ 39.99
$ 10.00
Buy 2 for $20.00
Save $43.98
Add to Cart

Book Details

ISBN 139781785288975
Paperback154 pages

Book Description

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.

Table of Contents

Chapter 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
Chapter 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
Chapter 3: Administering the Database
Creating a database
Viewing database schema data
Backing up the database
Database tools
Database file information
Summary
Chapter 4: 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
Chapter 5: Exposing the C API
SQLite C components' functionality
Summary
Chapter 6: Using Swift with iOS and SQLite
Basic requirements
Starting an Xcode Project with Swift
Using the SQLite 3 Library
Summary
Chapter 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
Chapter 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

What You Will Learn

  • Explore Swift's basic language statements
  • Connect to SQLite and execute SQL statements
  • Extend the SQLite language to create your own software extensions
  • Use HTML5 with Phonegap on iOS
  • Set up a Swift project using XCode with SQLite
  • Administer SQLite databases in an easy and effective way

Authors

Table of Contents

Chapter 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
Chapter 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
Chapter 3: Administering the Database
Creating a database
Viewing database schema data
Backing up the database
Database tools
Database file information
Summary
Chapter 4: 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
Chapter 5: Exposing the C API
SQLite C components' functionality
Summary
Chapter 6: Using Swift with iOS and SQLite
Basic requirements
Starting an Xcode Project with Swift
Using the SQLite 3 Library
Summary
Chapter 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
Chapter 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

Book Details

ISBN 139781785288975
Paperback154 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Swift Data Structure and Algorithms Book Cover
Swift Data Structure and Algorithms
$ 31.99
$ 10.00
Test-Driven iOS Development with Swift 3 Book Cover
Test-Driven iOS Development with Swift 3
$ 31.99
$ 10.00
Swift 3 Protocol-Oriented Programming - Second Edition Book Cover
Swift 3 Protocol-Oriented Programming - Second Edition
$ 31.99
$ 10.00
Learning Xcode 8 Book Cover
Learning Xcode 8
$ 39.99
$ 10.00
iOS 10 Programming for Beginners Book Cover
iOS 10 Programming for Beginners
$ 39.99
$ 10.00
Learning iOS Penetration Testing Book Cover
Learning iOS Penetration Testing
$ 31.99
$ 10.00