Muutke küpsiste eelistusi

E-raamat: Introducing SQLite for Mobile Developers

3.67/5 (6 hinnangut Goodreads-ist)
  • Formaat: PDF+DRM
  • Ilmumisaeg: 29-Dec-2015
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484217665
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 30,86 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Introducing SQLite for Mobile DevelopersSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 29-Dec-2015
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484217665
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

This brief book is an introduction to SQLite for both iOS and Android developers.  The book includes an optional introduction to SQL, a discussion of when to use SQLite,  and chapters devoted to using SQLite with the most likely programming languages and then goes through adding a simple database to an Android or iOS app and finally a chapter on managing the app’s life cycle.

What You Will Learn:

• The basics of SQLite
• The SQL you need to use SQLite effectively
• How to integrate a database into your mobile app.
• How to maintain the app

Who this book is for:

This book is for Android or iOS developers who wish to use a lightweight but flexible database for their applications. It mobile development experience but does not assume anything but very basic database knowledge.
About the Author xi
About the Technical Reviewers xiii
Acknowledgments xv
Introduction xvii
Chapter 1 Getting Up to Speed with Databases and SQLite
1(8)
Moving Beyond Big
1(1)
Databases Are Structured and Organized
2(1)
Databases Are Smart
2(2)
Relational Databases and SQL to the Rescue
4(1)
Looking Inside a Relational Table and Query
5(1)
Basic Query Structure
6(1)
Looking at Other Query Choices
7(2)
Chapter 2 Understanding What SQLite Is
9(6)
Putting a Database in Perspective
9(1)
Defining SQLite
10(1)
SQLite Is Designed for a Single User
11(1)
SQLite Is Self-Contained
12(1)
SQLite Supports Transactions and Is ACID-Compliant
13(2)
Chapter 3 Using SQLite Basics: Storing and Retrieving Data
15(14)
Using sqlite3
16(1)
Run sqlite3 and Let It Create a New Database
16(1)
Create and Name a New sqlite3 Database
17(1)
Delete the Database
17(1)
Run sqlite3 and Open an Existing Database
17(1)
Experimenting with SQLite Syntax
18(1)
Exploring Your sqlite3 Database with a Graphical SQLite Editor
19(2)
Creating a Table
21(1)
Using a Graphical SQLite Editor
21(1)
Creating Table Columns
22(2)
Using SQLite3
24(1)
Inserting Data into a Table
24(1)
Using a Graphical User Interface
24(2)
Using SQLite3
26(1)
Retrieving Data
26(1)
Using a Graphical User Interface
26(1)
Using sqlit3
27(1)
Deleting Data
27(1)
Summary
27(2)
Chapter 4 Working with the Relational Model and SQLite
29(10)
Building the Users Table
30(1)
Building the Scores Table
31(1)
Relating the Tables
32(1)
Using Aliases to Identify Multiple Tables in a SELECT Statement
32(1)
Using the rowid Primary Key
33(1)
Changing a Name in One Table
34(1)
Using a Foreign Key
34(3)
Joining the Tables
37(1)
Summary
38(1)
Chapter 5 Using SQLite Features---What You Can Do with SELECT Statements
39(6)
Looking at the Test Data
40(1)
Ordering Data Makes It Easier to Use
40(1)
Grouping Data Can Consolidate It
41(1)
Using Variables in Queries
42(1)
Summary
43(2)
Chapter 6 Using SQLite with PHP
45(10)
Putting PHP and SQLite Together: The Basics
46(1)
Verifying PHP in Your Environment
46(1)
Preparing the SQLite Database
47(3)
Connecting to Your SQLite Database
50(4)
1 Create a New PDO Object
51(1)
2 Create and Prepare the Query
52(1)
3 Execute the Query
52(1)
4 Fetch the Results
52(1)
5 Use the Results
52(2)
Summary
54(1)
Chapter 7 Using SQLite with Android/Java
55(6)
Integrating SQLite with Any Operating System, Framework, or Language
55(2)
Using Android and SQLite
57(1)
Using the Static Values
57(1)
Extend SQLite Open Helper
58(2)
Summary
60(1)
Chapter 8 Using SQLite with Core Data (iOS and OS X)
61(14)
Introducing the Core Data Framework
62(1)
Using the Core Data Model Editor
63(3)
Using Entities
66(2)
Working with Attributes
68(1)
Managing Relationships
69(4)
Summary
73(2)
Chapter 9 Using SQLite/Core Data with Swift (iOS and OS X)
75(22)
Looking at the Core Data Stack
75(1)
Fetching Data to the Core Data Stack
76(1)
Structuring a Core Data App
76(1)
Passing a Managed Object Context to a View Controller in iOS
77(1)
Setting Up the Core Data Stack in AppDelegate for iOS
78(3)
Setting Up the Core Data Stack in AppDelegate for OS X
81(3)
Creating a Fetch Request in iOS
84(1)
Saving the Managed Object Context
85(1)
Saving in iOS
85(1)
Saving in OS X
86(1)
Working with NSManagedObject
87(1)
Creating a New NSManagedObject Instance
88(2)
Working with a Subclass of NSManagedObject
90(5)
Summary
95(2)
Chapter 10 Using SQLite/Core Data with Objective-C (iOS and Mac)
97(24)
Looking at the Core Data Stack
98(1)
Fetching Data to the Core Data Stack
99(1)
Objective-C Highlights
99(1)
Using Quoted Strings
99(1)
Objective-C Is a Messaging Language
99(1)
Using Brackets in Objective-C
99(1)
Chaining Messages
100(1)
Ending Statements with a Semicolon
100(1)
Separating Headers and Bodies in Objective-C
100(1)
Looking at Method Declarations
101(1)
Handling nil in Objective-C
101(1)
Structuring a Core Data App with Objective-C
102(1)
Passing a Managed Object Context to a View Controller in iOS
102(1)
Setting up the Core Data Stack in AppDelegate for iOS
103(4)
Setting Up the Core Data Stack in AppDelegate for OS X
107(3)
Creating a Fetch Request in iOS
110(1)
Saving the Managed Object Context
111(1)
Saving in iOS
111(1)
Saving in OS X
112(8)
Summary
120(1)
Chapter 11 Using the Simple Database with a PHP Web Site
121(14)
Reviewing the Database
121(3)
Previewing the Web Site
124(3)
Implementing the PHP Web Site
127(1)
Looking at the Basic PHP/SQLite Structure
128(2)
Building the Drop-Down Selection List (phpsq
1.php)
130(1)
Showing the Selected Data (phpsql2. php)
131(2)
Adding New Data (phpsql3.php)
133(1)
Using Try/Catch Blocks with PHP and PDO
134(1)
Summary
134(1)
Chapter 12 Using the Simple Database with a Core Data/iOS App
135(10)
The Story Continues
135(1)
Adjusting the Data Model and Template for Core Data
136(1)
Getting Rid of Keys and Revising the Data Model
137(1)
Changing timeStamp to name
137(1)
Create a New Database on Your Device or Simulator
138(1)
Add the Score Table and Interface to the App
138(1)
Making Sure You Can Add New Users with + in the Master View Controller
138(1)
Working with the Detail View
139(1)
Working with the Detail View for Score
139(2)
Use NSManagedObject Subclasses
141(1)
Use a Table View Controller for DetailViewController
141(1)
Modify DetailViewController Code for DetailViewController
142(1)
Modify MasterViewController to Pass the User to DetailViewController
143(1)
Summary
144(1)
Index 145
Jesse Feiler is a developer, consultant, and author specializing in database technologies and location-based apps. He has worked with databases and data management on computers from mainframes to iPhone, iPad, and Apple TV using data management tools from DB2 (IBM) and DMSII (Burroughs) to Enterprise Objects Framework and Core Data, MySQL, Oracle,  and, of course, MySQL.  In the early days of the web, he built the page caching mechanism for the Prodigy web browser for Mac using a relational database library similar in some ways to SQLite. He is the creator of Minutes Machine the meeting management app, as well as Saranac River Trail app a guide to the Trail that includes location-based updates as well as social media tools. His apps are available in the App Store and are published by Champlain Arts Corp (champlainarts-dot-com). As a consultant; he has worked with small businesses and nonprofits on projects such as production control, publishing, and project management usually involving FileMaker. His books include: Swift for Dummies (Wiley, 2014) iOS App Development for Dummies (Wiley, 2014) iWork  for Dummies (Wiley, 2012) He is heard regularly on WAMC Public Radio for the Northeast's The Roundtable. founder of Friends of Saranac River Trail, Inc. A native of Washington DC, he has lived in New York City and currently lives in Plattsburgh NY. He can be reached at northcountryconsulting-dot-com (consulting) and champlainarts-dot-com (app development).
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842176652e.html
Märksõnad: