Muutke küpsiste eelistusi

Build iOS Database Apps with Swift and SQLite 1st ed. [Pehme köide]

5.00/5 (2 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 200 pages, kõrgus x laius: 254x178 mm, kaal: 4293 g, 107 Illustrations, color, 1 Paperback / softback
  • Ilmumisaeg: 16-Nov-2016
  • Kirjastus: APress
  • ISBN-10: 1484222318
  • ISBN-13: 9781484222317
Teised raamatud teemal:
  • Pehme köide
  • Hind: 34,97 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 41,14 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 3-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Build iOS Database Apps with Swift and SQLite 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 200 pages, kõrgus x laius: 254x178 mm, kaal: 4293 g, 107 Illustrations, color, 1 Paperback / softback
  • Ilmumisaeg: 16-Nov-2016
  • Kirjastus: APress
  • ISBN-10: 1484222318
  • ISBN-13: 9781484222317
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484222317.html
Märksõnad:
This book leads you through the essential concepts and new iOS 10 SDK and Swift 3 programming language APIs to build iPhone and iPad database driven applications using the defacto standard for data storage for mobile apps, SQLite.

The book covers the SQL operations like selecting, inserting, updating and deleting data using various data types like text, numerical types, images and even audio/video data. After working through this book, you will gain an expert view of developing iOS apps using SQlite as a data storage uisng Objective-C and Swift.

You will also gain expert knowledge on hoe to create database at runtime, including creating or modifying indexes, triggers, tables, columns and views. The examples use time-tested code from working applications.


What you'll learn
  • How to create database and database applications using iOS and Swift
  • How to insert, select, edit, delete records
  • How to extend SQLite
  • How to work with multi-database apps
  • How to use SQLite with Swift
  • How to backup online SQLite Databases and more

Who is this book for
This book is for experienced Apple iOS, Swift programmers and developers.


About the Author xv
About the Technical Reviewer xvii
Acknowledgments xix
Preface xxi
Chapter 1 Creating the Objective-C Wrapper
1(10)
Getting Started
1(1)
Creating the Swift iOS Project
2(3)
Create the Db Mgr Project Structure
3(1)
Adding the SQLite 3 Library
3(2)
Creating the Bridge
5(2)
Creating the Bridge Header File
5(2)
Configuring the Swift Compiler
7(1)
Creating the Swift Wrapper Functions
7(3)
Add the DbMgrDAO Class
8(1)
Create the initf()func
9(1)
Creating the SQLite Execute Function
10(1)
Summary
10(1)
Chapter 2 Creating SQLite Databases
11(14)
Creating Databases and Adding them to the Project
11(11)
Launching SQLite Manager
12(1)
The SQLite Manager Menu
12(1)
Create the Database
13(2)
Add Table and Columns
15(3)
Add an Index
18(1)
Add a View
19(2)
Add a Trigger
21(1)
Create an iOS Project
22(2)
Add Database to the Project
23(1)
Summary
24(1)
Chapter 3 Creating Databases During Runtime
25(20)
Building the DB MgrApp
25(5)
The Application Ul
25(2)
Creating the Data Model
27(3)
Creating the Controllers
30(11)
The DbMgrDAO Controller
31(5)
The MasterViewController
36(3)
The DetailViewController
39(2)
Building the Winery Database
41(3)
Create the Winery.sqlite File
42(2)
Summary
44(1)
Chapter 4 Altering Databases and Other Features
45(18)
Modifying Tables
46(2)
Renaming a Table
46(1)
Adding Columns
47(1)
Re-indexing a Table
48(1)
Modifying Views
48(1)
Modifying Indexes
48(1)
Modifying Triggers
49(1)
Adding and Altering Collation Sequences
50(2)
Binary
51(1)
NoCase
51(1)
Rtrim
51(1)
sqlite3_create_collation
51(1)
The SQLite DELETE Statement
52(1)
Deleting Tables
52(1)
Deleting Views
52(1)
Deleting Indices
53(1)
Deleting Triggers
53(1)
Deleting Collation Sequences
53(1)
SQLite Functions
53(6)
The JSON Extension
53(2)
Creating Functions using Swift
55(3)
Using Functions in a SQLite Database using Swift
58(1)
Pragma Statements
59(2)
Foreign_key_check
59(1)
Foreign_key_list
60(1)
Lntegrity_Check
60(1)
Automaticjndex
60(1)
Busyjimeout
60(1)
Shrink_memory
60(1)
Auto-vacuum
60(1)
Corrupting a SQLite Database
61(1)
SQLite Limits
61(1)
Summary
62(1)
Chapter 5 Inserting Records
63(26)
The Data-Binding Functions
63(1)
The SQLite INSERT function
64(5)
Insert or Replace
66(1)
Insert or Rollback
67(1)
Insert or Ignore
67(1)
Insert or Abort
67(1)
Insert or Fail
67(1)
Inserting Blobs
68(1)
Creating the Winery App
69(3)
Create the Project
69(1)
Add the Bridge
69(3)
Creating the UI View for Inserting
72(3)
Creating the Data Model
75(3)
Add the Wineries Database
76(1)
Add the Wine Type
76(1)
Add the Wineries Type
77(1)
Add the Database Schema
77(1)
Creating the Controllers
78(6)
Add the WineryDAO Class
78(1)
The init() function init()
78(1)
The buildSchema Function
79(1)
The createOrOpenDatabase Function
80(1)
The insertWineRecord Function
80(1)
The insertWineryRecord Function
81(1)
The FirstViewController
81(1)
Add Photo Capture Functionality
82(1)
The SecondViewController
83(1)
Running the App
84(3)
Inserting Records
84(3)
Summary
87(2)
Chapter 6 Selecting Records
89(24)
Column Data Types
89(1)
The SELECT Statement
90(6)
Selecting Data
90(2)
Using a Dynamic WHERE Clause
92(1)
Perform a SELECT using a Sub-Query
93(1)
Perform a SELECT using Joins
93(1)
Select and Display Images
94(1)
Select and Playback Audio Records
95(1)
Select and Display Video Records
96(1)
Adding SELECT Functionality to the Winery App
96(4)
Add the SelectWineries UlPicker
96(1)
The viewDidLoad Function
96(1)
The UlPickerView Functions
97(1)
The selectWineriesList Function
98(1)
The selectWineList Function
99(1)
The selectWineryByName Function
99(1)
Modifying the Ul for Displaying Records
100(9)
Adding the UlTableViewControllers
100(2)
Adding the Navigation Controllers
102(2)
Connect the TableViewControllers and TableViewCellController
104(2)
Adding the IBOutlets: WineList Controller
106(1)
Add the Business Logic
107(2)
Running the App
109(3)
Summary
112(1)
Chapter 7 Updating Records
113(18)
SQLite Update Statement
113(4)
UPDATE Using a Where Clause
115(1)
UPDATE Using a Sub-query
115(1)
Updating Records Using a Join
116(1)
UPDATE Using a Sub-Query in FROM Clause
116(1)
Update On Conflict
116(1)
A Sample SQLite UPDATE Operation in Swift
117(1)
Adding the UPDATE Functionality to the Winery App
118(6)
Modifying the WineryDAO Controller
118(2)
Modifying the UI for Updates
120(4)
Running the App
124(6)
Updating Records
125(5)
Summary
130(1)
Chapter 8 Deleting Records
131(14)
The DELETE Statement in SQLite
131(1)
Using the WHERE Clause
131(1)
Restrictions and Triggers
132(1)
DELETE Limits
132(1)
A Swift SQLite Delete Example
132(2)
Adding the Delete Functionality to the Winery App
134(4)
Modifying the WineryDAO Class
135(1)
Modifying the View/Controllers
136(1)
Modifying the TableViewControllers
136(1)
Modifying the Ul for Delete
137(1)
Modifying the Ul
137(1)
Running the App
138(6)
Summary
144(1)
Chapter 9 Searching for Records in SQLite
145(16)
The Search App
145(13)
Create the SQLite Database
146(2)
Create the iOS/SQLite Project
148(10)
Running the App
158(1)
Summary
159(2)
Chapter 10 Working with Multiple Databases
161(14)
The ATTACH Statement
161(1)
The DETACH Statement
162(1)
Multi-Database Limits
162(1)
Performing Joins
163(1)
Attach and Detach in Swift
163(8)
The Project
164(1)
The ViewController
164(5)
Building the UI
169(2)
Running the App
171(2)
Summary
173(2)
Chapter 11 Backing Up SQLite Databases
175(12)
Overview of the SQLite Backup Methods
175(2)
Make a Backup Copy
175(1)
Back Up In-Memory SQLite Databases
176(1)
Back Up On-Disk SQLite Databases
177(1)
The Backup App
177(8)
The View/Controller
181(2)
Building the Ul
183(2)
Summary
185(2)
Chapter 12 Analyzing SQLite Databases
187(10)
The Analyze Statement
187(1)
The sqldiff Tool
188(1)
The sqlite3_analyzer tool
189(7)
Summary
196(1)
Index 197
Kevin Languedoc is a software developer with 20 years of solid database development experience. He has worked with all major platforms and technologies in his long and varied career. He brings his expertise in database development to iOS (iPhone and iPad) platform and SQlite. He has developed over 50 iPhone and iPad apps in the corporate level for clients of all sizes. He brings a wealth of practical experience to this book with extensive code samples and working apps.