Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Jesse Feiler
Introducing SQLite for Mobile Developers
Cover
Title
Copyright
Contents at a Glance
Contents
About the Author
About the Technical Reviewers
Acknowledgments
Introduction
Chapter 1 : Getting Up to Speed with Databases and SQLite
Moving Beyond Big
Databases Are Structured and Organized
Databases Are Smart
Relational Databases and SQL to the Rescue
Looking Inside a Relational Table and Query
Basic Query Structure
Looking at Other Query Choices
Chapter 2 : Understanding What SQLite Is
Putting a Database in Perspective
Defining SQLite
SQLite Is Designed for a Single User
SQLite Is Self-Contained
SQLite Supports Transactions and Is ACID-Compliant
Chapter 3 : Using SQLite Basics: Storing and Retrieving Data
Using sqlite3
Run sqlite3 and Let It Create a New Database
Create and Name a New sqlite3 Database
Delete the Database
Run sqlite3 and Open an Existing Database
Experimenting with SQLite Syntax
Exploring Your sqlite3 Database with a Graphical SQLite Editor
Creating a Table
Using a Graphical SQLite Editor
Creating Table Columns
Using SQLite3
Inserting Data into a Table
Using a Graphical User Interface
Using SQLite3
Retrieving Data
Using a Graphical User Interface
Using sqlite3
Deleting Data
Summary
Chapter 4 : Working with the Relational Model and SQLite
Building the Users Table
Building the Scores Table
Relating the Tables
Using Aliases to Identify Multiple Tables in a SELECT Statement
Using the rowid Primary Key
Changing a Name in One Table
Using a Foreign Key
Joining the Tables
Summary
Chapter 5 : Using SQLite Features—What You Can Do with SELECT Statements
Looking at the Test Data
Ordering Data Makes It Easier to Use
Grouping Data Can Consolidate It
Using Variables in Queries
Summary
Chapter 6 : Using SQLite with PHP
Putting PHP and SQLite Together: The Basics
Verifying PHP in Your Environment
Preparing the SQLite Database
Connecting to Your SQLite Database
1. Create a New PDO Object
2. Create and Prepare the Query
3. Execute the Query
4. Fetch the Results
5. Use the Results
Summary
Chapter 7 : Using SQLite with Android/Java
Integrating SQLite with Any Operating System, Framework, or Language
Using Android and SQLite
Using the Static Values
Extend SQliteOpenHelper
Summary
Chapter 8 : Using SQLite with Core Data (iOS and OS X)
Introducing the Core Data Framework
Using the Core Data Model Editor
Using Entities
Working with Attributes
Managing Relationships
Summary
Chapter 9 : Using SQLite/Core Data with Swift (iOS and OS X)
Looking at the Core Data Stack
Fetching Data to the Core Data Stack
Structuring a Core Data App
Passing a Managed Object Context to a View Controller in iOS
Setting Up the Core Data Stack in AppDelegate for iOS
Setting Up the Core Data Stack in AppDelegate for OS X
Creating a Fetch Request in iOS
Saving the Managed Object Context
Saving in iOS
Saving in OS X
Working with NSManagedObject
Creating a New NSManagedObject Instance
Working with a Subclass of NSManagedObject
Summary
Chapter 10 : Using SQLite/Core Data with Objective-C (iOS and Mac)
Looking at the Core Data Stack
Fetching Data to the Core Data Stack
Objective-C Highlights
Using Quoted Strings
Objective-C Is a Messaging Language
Using Brackets in Objective-C
Chaining Messages
Ending Statements with a Semicolon
Separating Headers and Bodies in Objective-C
Looking at Method Declarations
Handling nil in Objective-C
Structuring a Core Data App with Objective-C
Passing a Managed Object Context to a View Controller in iOS
Setting up the Core Data Stack in AppDelegate for iOS
Setting Up the Core Data Stack in AppDelegate for OS X
Creating a Fetch Request in iOS
Saving the Managed Object Context
Saving in iOS
Saving in OS X
Working with NSManagedObject
Creating a New NSManagedObject Instance
Working with a Subclass of NSManagedObject
Summary
Chapter 11 : Using the Simple Database with a PHP Web Site
Reviewing the Database
Previewing the Web Site
Implementing the PHP Web Site
Looking at the Basic PHP/SQLite Structure
Building the Drop-Down Selection List (phpsql1.php)
Showing the Selected Data (phpsql2.php)
Adding New Data (phpsql3.php)
Using Try/Catch Blocks with PHP and PDO
Summary
Chapter 12 : Using the Simple Database with a Core Data/iOS App
The Story Continues…
Adjusting the Data Model and Template for Core Data
Getting Rid of Keys and Revising the Data Model
Changing timeStamp to name
Create a New Database on Your Device or Simulator
Add the Score Table and Interface to the App
Making Sure You Can Add New Users with + in the Master View Controller
Working with the Detail View
Working with the Detail View for Score
Use NSManagedObject Subclasses
Use a Table View Controller for DetailViewController
Modify DetailViewController Code for DetailViewController
Modify MasterViewController to Pass the User to DetailViewController
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset