目錄(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
推薦閱讀
- Node.js+Webpack開發實戰
- Advanced Machine Learning with Python
- 企業級Java EE架構設計精深實踐
- 垃圾回收的算法與實現
- Python數據分析從0到1
- HTML5入門經典
- C語言程序設計
- ArcGIS for Desktop Cookbook
- MINECRAFT編程：使用Python語言玩轉我的世界
- C#面向對象程序設計（第2版）
- 你真的會寫代碼嗎
- Python全棧開發：數據分析
- Mastering Machine Learning with scikit-learn
- MonoTouch應用開發實踐指南：使用C#和.NET開發iOS應用
- Cocos2D Game Development Essentials
- 微信小程序開發圖解案例教程：附精講視頻（第3版）
- VBA Automation for Excel 2019 Cookbook
- 深入理解C++11：C++11新特性解析與應用
- Vue.js項目開發實戰
- JavaScript高級程序設計（第3版）
- SAP HANA平臺應用開發
- Microsoft HoloLens Developer's Guide
- PLC編程入門及工程實例
- 響應式Web設計：HTML5和CSS3實踐指南
- Visual Basic 2008應用程序開發實例精講
- Object–Oriented Programming with Swift 2
- OpenCV 4 with Python Blueprints
- Python游戲開發從入門到精通
- Scratch項目式編程實戰：打造超酷大型游戲
- Android開發寶典
