ANALYZE statement
attachDatabase function
ATTACH DATABASE statement
ATTACH SQLite functionality
Backup API
BackupBridge file
bridge interface
FileManager
in-memory databases
on-disk operation
sqlite library
Swift Compiler Build settings
UI building
View Application project
ViewController
cellForRowAt
Chinook_SQLite.sqlite database
Collation sequences
BINARY collation
NoCase collation
RTRIM type
sqlite3_create_collation function
Controllers
buildSchema
FirstViewController
init function
insertWineRecord function
insertWineryRecord function
photo capture function
imagePickerController function
insertRecordAction
UISlider
viewDidLoad function
wineRating function
SecondViewController
WineryDAO class
copyDatabaseIntoDocuments function
createDatabase function
createOrOpenDatabase function
CROSS JOIN
Data model
database schema
wineries database
documentDirectory
SearchPathDirectory
types
DbMgrDAO controller
contentsOfDirectoryAtURL method
COpaquePointer
DetailViewController
executeQuery function
initViewIndex function
NSFileManager class
NSFileManager.defaultManage classr
openSQliteDatabase function
populateIndexView function
preparedStatement
sqlite3_column_text method
stringByReplacingOccurencesOfString
TableView
viewDidLoad function
Db Swift class
CREATE TABLE statement
Enums class
executeQuery method
insert statement
selectDbSchemaListByType method
selectDbSchemaStructure method
tableDef
db_to_attach_path variable
DELETE function
collation sequences
DELETE statement
indices
LIMITS clause
sampleDelete function
tables
TRIGGER
views
WHERE clause
Winery app
Cellar TableView
commitEditingStyle
deleteRowsAtIndexPaths
deleteWineRecord
Edit mode
UITableView
UITableViewCellEditingStyle
ViewControllers
viewDidLoad method
Wineries TableView
WineryDAO Class
WineryListTableController
dequeueReusableCellWithIdentifier
detachDatabase function
DETACH SQLite functionality
DETACH statement
DetailViewController
createDbButton
dbStatusMsg
detailSQLiteQueryField method
@IBAction Buttons
openSQLiteDatabase method
prepareForSeque
viewDidLoad function
viewWillAppear function
executeQuery function
FileManager
getDatabasePath function
IBAction
IBOutlets
Index
DROP INDEX
UNIQUE INDEX
INNER JOIN
INSERT statement
ABORT clause
blobs
data-binding functions
DocumentDirectory
IGNORE clause
last clause
NSFileManager
NSSearchPathDirectory
NSSearchPathForDirectoriesInDomains
records
REPLACE statements
rollback
iOS app
Create Bridge interface
database creation
project creation
SQLiteSearchBridge
UISearchBar
ViewController
project creation
AppDelegate application
bundle
database
didFinishLaunchWithOption
documents directory
finder
Master-Detail template
resources
LIMITS clause
MasterViewController
cellForRowAtIndexPath
numberOfRowsInSection
schemaDetailsItems
segue
titleForHeaderInSection
UITableView component
unWindFromSegue function
viewDidLoad function
NSObject + SQLiteSearchBridge
numberOfRowsInSection
OUTER JOIN
PRAGMA database
Pragma statements
automatic_index
auto-vacuum
busy timeout
foreign_key_check
Foreign_key_list
integrity_check
shrink_memory
Prototype
REPLACE statements
RTRIM type
searchBarCancelButtonClicked method
searchBarSearchButtonClicked method
searchDatabase function
searchResultCellTableViewCell
SELECT statement
cross join
data-type binding functions
display images
IBOutlets
inner join
list of records
MPMoviePlayerController
navigation controllers
outer join
playback audio records
selectWineList function
selectWineriesList function
SelectWineries UIPicker
selectWineryByName function
SQLITE_ROW constant
TableViewControllers
UIPickerView function
UITableViewController
using sub query
ViewController function
WHERE clause
WineListTableViewController
Wineries UIPickerView
WineryListTableViewController
setDbPath function
sqldiff
SQLite functions
corrupt
JSON functions
limits
sqlite3_analyzer
sqlite3_enable_load_extension
sqlite3_exec function
sqlite3_load_extension
using Swift
build phases
compile sources
header File
sizeconverter
sqlite3_user_data() function
values
SQLite library
SQLITE_LIMIT_ATTACHED
SQLite Manager
SQLite Manager, firefox
Db Settings
directory selector
index
definition
sqlite_autoindex_book
menu option
Sqlite_master
browse & search
schema
sqlite_sequence
ATTACH command
AUTOINCREMENT property
DETACH command
ROWINDEX
tables and columns
definition
dropping
INSERT/UPDATE
primary key
re-indexing
table name
terminal
tools menu
trigger
view
CREATE VIEW
select statement
windows command
SQLiteSearch-Bridging-Header
SQLITE_TRANSIENT
Storyboard
Swift iOS application
add SQLite 3 library
bridge
header file
Swift compiler
DetailViewController
MasterViewController
wrapper functions
DbMgrDAO class
executeQuery function
init function
Tables, modification
add columns
ALTER command
DROP command
foreign keys
REINDEX command
RENAME command
UPDATE command
Triggers
UIButtons
Assistant Editor
Attributes inspector
detailSQLiteQueryField
@IBActions
Interface Builder
repeat process
UIPickerView
UITableViewCell
umberOfSectionsInTableView
UPDATE statement
ABORT option
CityTemperature table
FAIL option
FirstViewController
IBOutlets
IGNORE option
JOIN
Lamartine wine
ON CONFLICT
OR clauses
Pl/SQL/T-SQL
REPLACE option
ROLLBACK
SQLITE_DONE
SQLITE_OK
sub-query
Swift String constant
UI fields
updateRecords method
WHERE clause
wineries
wines list
wineyDAO class
columns updation
segue.destinationViewController
showWineDetail segue
WineListTableViewController
WineryListTableViewController
viewDidLoad function
Views, modification
Winery application
add bridge
constraints
creation
data model
imageView
UI components
view controller
Winery database
CRUD operations
createDbButton function
detailSQLiteQueryField
openSQLiteDatabase
table creation
view creation