目錄(76章)
倒序
- 封面
- 版權信息
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Preface
- 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
- Index 更新時間：2021-07-16 12:32:54
推薦閱讀
- 零基礎PHP學習筆記
- 程序員數學：用Python學透線性代數和微積分
- PHP+MySQL網站開發技術項目式教程（第2版）
- C#程序設計（慕課版）
- aelf區塊鏈應用架構指南
- Mastering Swift 2
- 微信公眾平臺開發：從零基礎到ThinkPHP5高性能框架實踐
- Expert Android Programming
- Rust Essentials（Second Edition）
- Learning Data Mining with R
- 大模型RAG實戰：RAG原理、應用與系統構建
- 計算機應用基礎實踐教程
- Integrating Facebook iOS SDK with Your Application
- 編程與類型系統
- C++從入門到精通（第5版）
- C#程序設計（項目教學版）
- 輕松上手2D游戲開發：Unity入門
- Spring+Spring MVC+MyBatis從零開始學
- Raspberry Pi Robotic Projects（Third Edition）
- 人工智能算法（卷1）：基礎算法
- PHP項目開發全程實錄（第4版）
- Java EE輕量級解決方案：S2SH
- 從零開始學UI設計·基礎篇
- Django 3 Web Development Cookbook
- Scratch少兒編程高手的7個好習慣
- Java王者歸來：從入門邁向高手
- SpringBoot+Vue.js+分布式組件全棧開發訓練營（視頻教學版）
- Python數據科學導論
- 餐飲管理與經營全案：互聯網思維創新餐飲管理和運營模式
- JavaScript and JSON Essentials
