Index

A

• ACID (atomicity, consistency, isolation, and durability)
  • about / Database essentials, Transactions
• American National Standards Institute (ANSI)
  • about / Where does SQLite stand in today's industry?
• Apache Cordova product
  • reference link / An Xcode project with PhoneGap, HTML5, and Swift
• Apache Software Foundation (ASF)
  • about / An Xcode project with PhoneGap, HTML5, and Swift
• Appium
  • about / Designing for SQLite
• Apple Developer Guide
  • reference link / Basic requirements
• Apple development, on Mac
  • requisites / Basic requirements
• architecture, SQLite database
  • OS-Interface / The architecture of the SQLite database
  • Tokeniser code base / The architecture of the SQLite database
  • Parser code base / The architecture of the SQLite database
  • Lemon LALR(1) parser generator / The architecture of the SQLite database
  • Code Generator / The architecture of the SQLite database
  • virtual machine / The architecture of the SQLite database
  • header files / The architecture of the SQLite database
  • B-tree / The architecture of the SQLite database
  • Pager / The architecture of the SQLite database
  • Page Cache / The architecture of the SQLite database
  • OS Interface C file / The architecture of the SQLite database
  • Util.c file / The architecture of the SQLite database
• Association of Computer Machinery (ACM)
  • about / About SQL

B

• B-Tree usage, with SQLite
  • about / The B-tree usage with SQLite
• BACKUP API
  • about / Write Ahead Logging with SQLite
• Bitbucket
  • URL / Database tools
• Brodysoft
  • about / PhoneGap plugins
  • reference link / PhoneGap plugins
• B tree / Database essentials

C

• C-API
  • using, with open database statement / Using the C API with the open database statement
• C/C++ interface part, SQLite database system
  • sqlite3_exec() / Database essentials
  • sqlite_close() / Database essentials
  • sqlite_finalize() / Database essentials
  • sqlite3_column() / Database essentials
  • sqlite3_step() / Database essentials
  • sqlite3_bind() / Database essentials
  • sqlite3_prepare() / Database essentials
  • sqlite_open() / Database essentials
• C API
  • extensions / Extensions to the C API
• checkpointing / Write Ahead Logging with SQLite
• classes, FMDB
  • FMDatabase / FMDB SQLite wrapper
  • FMResultSet / FMDB SQLite wrapper
  • FMDatabaseQueue / FMDB SQLite wrapper
• cocoa/objective-C wrapper
  • about / iOS with SQLite
• command-line program (CLP) / Working with SQLite
• command lines tools, for Xcode
  • reference link / An Xcode project with PhoneGap, HTML5, and Swift
• composite indexes
  • about / Index use
• constraint checking
  • about / Constraint checking
• Cordova
  • about / PhoneGap plugins
  • reference link / PhoneGap plugins
• Core Data
  • about / Extensions to the C API
• core interfaces, SQLite
  • SQLite3_open() / Database essentials
  • SQLite3_prepare() / Database essentials
  • SQLite3_column() / Database essentials
  • SQLite3_step() / Database essentials
  • SQLite3_finalize() / Database essentials
  • SQLite3_close() / Database essentials
• CREATE statement / Database essentials

D

• data
  • inserting, into table / Inserting data
  • selecting, from table / Selecting data
  • exporting, from SQLite / Exporting data
• database
  • essentials / Database essentials
  • creating / Creating a database, Database creation and opening
  • table, creating in / Creating a table
  • backing up / Backing up the database
  • opening / Database creation and opening
• database connection
  • about / Database connections
• database file information
  • about / Database file information
• database locking
  • about / Database locking and deadlocks
• database schema data
  • viewing / Viewing database schema data
• database tools
  • about / Database tools
• data integrity
  • about / Data integrity
• db.exec statement
  • queries / Queries within the db.exec statement
• deadlock
  • about / Database locking and deadlocks
• default values
  • about / Default values
  • constraint checking / Constraint checking
  • foreign keys / Foreign keys
• DELETE statement / Database essentials
• DLL / Working with SQLite
  • about / Using Swift with the open database statement

E

• embedded database
  • about / Embedded databases
• error handling
  • about / Error handling
• EXPLAIN keyword
  • about / Query plan
• EXPLAIN QUERY PLAN
  • about / Query plan
• extensions, to C API / Extensions to the C API

F

• FMDB
  • about / iOS with SQLite, sqlite3_config(), Using the SQLite 3 Library
  • classes / FMDB SQLite wrapper
• FMDB specification
  • reference link / FMDB SQLite wrapper
• FMDB SQLite wrapper
  • about / FMDB SQLite wrapper
• foreign key
  • about / Foreign keys

H

• HTML5
  • and PhoneGap Development / HTML5 and PhoneGap development
• HTML5 Framework
  • about / An HTML5 framework
• hybrid applications
  • about / Hybrid applications

I

• index
  • creating, for temp table / Creating an index
  • about / Index use
• index data
  • viewing / Index data
• INSERT statement / Database essentials
• iOS, with SQLite
  • about / iOS with SQLite
  • example / The examples of using SQLite with iOS

L

• load_extension() function
  • about / load_extension()
• locks
  • about / Transactions and locks

M

• Memsys2
  • about / Reasons for using SQLite
• methods and objects, SQLite
  • sqlite3 / Preparing queries
  • sqlite3_stmt / Preparing queries
  • sqlite3_open() / Preparing queries
  • sqlite3_prepare() / Preparing queries
  • sqlite3_bind() / Preparing queries
  • sqlite3_step() / Preparing queries
  • sqlite3_column() / Preparing queries
  • sqlite3_finalize() / Preparing queries
  • sqlite3_close() / Preparing queries
  • sqlite3_exec() / Preparing queries
• Microsoft Excel
  • about / Database essentials

N

• node.js
  • download link / An Xcode project with PhoneGap, HTML5, and Swift
• NSError / Creating a simple Swift

O

• open database statement
  • C-API, using with / Using the C API with the open database statement
  • SWIFT, using with / Using Swift with the open database statement

P

• pager / Database essentials
• parameterized SQL
  • about / Parameterized SQL
• PhoneGap
  • download link / An Xcode project with PhoneGap, HTML5, and Swift
• PhoneGap Development
  • and HTML5 / HTML5 and PhoneGap development
• PhoneGap plugins
  • about / PhoneGap plugins
• phpSQLiteAdmin
  • URL / Database tools
• playground
  • about / Creating a simple Swift
• prepare statement
  • about / The prepare statement
• Presto / About SQL

Q

• queries
  • preparing / Preparing queries
  • within db.exec statement / Queries within the db.exec statement
• query plan
  • about / Query plan

R

• random access memory (RAM)
  • about / Database connections
• RDBMS (Relational Database Management System)
  • about / About SQL
• read-only WAL databases
  • about / Write Ahead Logging with SQLite
• Realm
  • about / Extensions to the C API
• Realm.io
  • about / Extensions to the C API
• referencing key
  • about / Foreign keys

S

• schema data
  • viewing / Schema data
• SELECT statement / Database essentials
• share library / Working with SQLite
• simple Swift
  • creating / Creating a simple Swift
• SQL
  • about / About SQL
• SQL, in iOS
  • about / SQL in iOS
• SQL basics
  • about / SQL basics
  • insert, with subselect clause / Insert with a subselect clause
  • update, with subselect clause / Update with a subselect clause
  • select, with subselect clause / Select with a subselect clause
• SQL Browser
  • URL / Database tools
• SQL injection
  • attacks / SQL injection attacks
• SQLite
  • about / Where does SQLite stand in today's industry?, Database essentials
  • features / Features, Reasons for using SQLite
  • advantages / The advantages of using SQLite
  • working with / Working with SQLite
  • URL / Working with SQLite
  • designing for / Designing for SQLite
  • data, exporting from / Exporting data
• SQLite 3 Library
  • using / Using the SQLite 3 Library, Using FMDB
• sqlite3_analyzer program
  • about / Database file information
  • reference link / Database file information
• sqlite3_close() function
  • about / sqlite3_close()
  • C-API, using with open database statement / Using the C API with the open database statement
  • SWIFT, using with open database statement / Using Swift with the open database statement
• sqlite3_column() function
  • about / sqlite3_column()
• sqlite3_config() function
  • about / sqlite3_config()
• sqlite3_exec() function
  • about / sqlite3_exec()
• sqlite3_finalize() function
  • about / sqlite3_finalize()
• sqlite3_open() function
  • about / sqlite3_open()
• sqlite3_prepare() function
  • about / sqlite3_prepare()
• sqlite3_step() function
  • about / sqlite3_step()
• SQLite C components functionality
  • about / SQLite C components' functionality
  • sqlite3_open() / sqlite3_open()
  • sqlite3_prepare() / sqlite3_prepare()
  • sqlite3_step() / sqlite3_step()
  • sqlite3_column() / sqlite3_column()
  • sqlite3_finalize() / sqlite3_finalize()
  • sqlite3_close() / sqlite3_close()
  • load_extension() / load_extension()
  • sqlite3_exec() / sqlite3_exec()
  • sqlite3_config() / sqlite3_config()
  • prepare statement / The prepare statement
• SQLite database
  • architecture / The architecture of the SQLite database
• SQLite Expert
  • URL / Database tools
• SQLiteManager
  • about / Database tools
  • URL / Database tools
• SQLite Manager Add-on
  • about / Using the SQLite 3 Library
  • reference link / Using the SQLite 3 Library
• SQL Query Builder
  • about / Database tools
• subquery
  • about / Select with a subselect clause
• subselect
  • about / Select with a subselect clause
• subselect clause / Insert with a subselect clause
• Swift
  • Xcode Project, starting with / Starting an Xcode Project with Swift
• SWIFT
  • using, with open database statement / Using Swift with the open database statement
• synchronous writes
  • about / Synchronous writes
• system catalog
  • about / Query plan

T

• T-SQL
  • about / Database essentials
• table
  • creating, in database / Creating a table
  • data, inserting into / Inserting data
• temp table
  • index, creating for / Creating an index
• transactions
  • about / Transactions and locks, Transactions
  • writing / Transactions – reading/writing
  • reading / Transactions – reading/writing
• triggers
  • about / Triggers

U

• UIKit / Creating a simple Swift
• UPDATE statement / Database essentials
• user defined functions
  • creating / Creating user-defined functions

V

• Valgrind
  • about / Reasons for using SQLite
• Views
  • updating / Updating Views
• virtual database of engine (VDBE)
  • about / Reasons for using SQLite
• virtual file system (VFS) / Reasons for using SQLite

W

• Write Ahead Logging (WAL), with SQLite
  • about / Write Ahead Logging with SQLite

X

• Xcode
  • download link / Starting an Xcode Project with Swift
  • about / Extensions to the C API
• Xcode IDE
  • about / iOS with SQLite
• Xcode Project
  • starting, with Swift / Starting an Xcode Project with Swift
• Xcode Project, with HTML5
  • about / An Xcode project with PhoneGap, HTML5, and Swift
• Xcode Project, with PhoneGap
  • about / An Xcode project with PhoneGap, HTML5, and Swift
• Xcode Project, with Swift
  • about / An Xcode project with PhoneGap, HTML5, and Swift