Index
A
- ACID (atomicity, consistency, isolation, and durability)
- about / Database essentials, Transactions
- American National Standards Institute (ANSI)
- Apache Cordova product
- reference link / An Xcode project with PhoneGap, HTML5, and Swift
- Apache Software Foundation (ASF)
- 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
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
- Xcode Project, with PhoneGap
- Xcode Project, with Swift