Cargando…
Learning SQLite for iOS : extend SQLite with mobile development skills to guild great apps for iOS devices /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
2016.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; 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 attacksCreating user-defined functions; Transactions and locks; Transactions
- reading/writing; Designing for SQLite; Summary; Chapter 3: Administering the Database; Creating a database; Creating a table; Inserting data; Selecting data; Creating an index; Exporting data; Viewing database schema data; Index data; Schema data; Backing up the database; Database tools; Database file information; Summary; Chapter 4: Essentials of SQL; Transactions; Query plan; SQL basics; Insert with a subselect clause; Update with a subselect clause; Select with a subselect clause; Data integrity
- Default valuesConstraint checking; Foreign keys; 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; sqlite3_open(); sqlite3_prepare(); sqlite3_step(); sqlite3_column(); sqlite3_finalize(); sqlite3_close(); Using the C-API with the open database statement; Using Swift with the open database statement; load_extension(); sqlite3_exec(); sqlite3_config(); The prepare statement; Summary
- Chapter 6: Using Swift with iOS and SQLiteBasic requirements; Starting an Xcode Project with Swift ; Using the SQLite 3 Library; Using FMDB; 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