Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning SQLite for iOS

You're reading from  Learning SQLite for iOS

Product type Book
Published in Mar 2016
Publisher
ISBN-13 9781785288975
Pages 154 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Gene Da Rocha Gene Da Rocha
Profile icon Gene Da Rocha
LinkedIn
Please write your Author Biography here using the following guidelines. Please save this file as ISBN_Author Bio_Author Name. The author bio should be written in the third person. For convenience, you can structure the bio along the following lines: 1. Description of yourself, your background and your experience. Gene Da Rocha is a successful Senior Test Consultant with Testing, SQL, DevOps, App Support and Project Management experience and has worked within a full software development lifecycle, including mobile and web technologies. He has been educated on three continents like Africa, India and Europe (UK) and has over twenty-five years of IT experience. Gene just learned and mastered technology over the years, but decided to pursue getting a degree. A few years ago he finished a BSc (Hons) in Computer Science and now an MSc in Computer Science with Mobile Technology at the University of Hertfordshire, UK. Gene has been in charge of a variety of IT Projects for different businesses and has led them to a successful conclusion. Gene also has: Strong analytical skills; Ability to coordinate and interact effectively with in-house and 3rd party resources. Gene has worked within a complex environment between multiple business teams and systems. He has designed mobile systems using his programming background with architectural skills, coupled with the innovation and the need to success and deliver requirements to clients. Gene effectively utilises his strong client facing skills, wide range of IT experience, architect qualities and project management experience to improve the organisations' business operations. Recently Testing has included regression, functional, system testing, integration and CI (continuous integration). 2. Some mention of your employers, or your own company, if relevant or you want to. (You don't have to and sometimes people can't mention their employers for contractual reasons). Gene in his long career has worked for a variety of companies in different industries like Barclays Bank, Reuters, Deutche Bank, Paribas Bank on a variety of projects and assignments. He has also worked for the Association for Project Management, QAWorks and more recently DigitasLBI among many others. 3. Other books you may have worked on. This is my first Book and it is aimed for the Computing Industry. It is aimed at introducing new people to IOS and Swift or existing computing professionals to get an idea or information to learning SQLite with IOS. 4. Acknowledgements - people you'd like to thank for their help in producing this book, (friends, family, etc) - this part is written in the first person. I would especially like to thank my family, especially my wife who have put up with my loss of family time researching the subject matter, writing and collating it with the publisher PactIT. It has been difficult especially after completing a BSc, MSc and now an IT book. So thanks for the kind patience in this project, that I wanted to do for sometime.
Read more
See other products by Gene Da Rocha
Toc

Table of Contents (15) Chapters close

Learning SQLite for iOS
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
1. Introduction to SQL and SQLite 2. Database Design Concepts 3. Administering the Database 4. Essentials of SQL 5. Exposing the C API 6. Using Swift with iOS and SQLite 7. iOS Development with PhoneGap and HTML5 8. More Features and Advances in SQLite Index

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
lock icon The rest of the chapter is locked
arrow left Previous Section
Section 1 of 1
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at ₹800/month. Cancel anytime}

Authors (1)

Left arrow icon
Profile icon Gene Da Rocha
LinkedIn
Please write your Author Biography here using the following guidelines. Please save this file as ISBN_Author Bio_Author Name. The author bio should be written in the third person. For convenience, you can structure the bio along the following lines: 1. Description of yourself, your background and your experience. Gene Da Rocha is a successful Senior Test Consultant with Testing, SQL, DevOps, App Support and Project Management experience and has worked within a full software development lifecycle, including mobile and web technologies. He has been educated on three continents like Africa, India and Europe (UK) and has over twenty-five years of IT experience. Gene just learned and mastered technology over the years, but decided to pursue getting a degree. A few years ago he finished a BSc (Hons) in Computer Science and now an MSc in Computer Science with Mobile Technology at the University of Hertfordshire, UK. Gene has been in charge of a variety of IT Projects for different businesses and has led them to a successful conclusion. Gene also has: Strong analytical skills; Ability to coordinate and interact effectively with in-house and 3rd party resources. Gene has worked within a complex environment between multiple business teams and systems. He has designed mobile systems using his programming background with architectural skills, coupled with the innovation and the need to success and deliver requirements to clients. Gene effectively utilises his strong client facing skills, wide range of IT experience, architect qualities and project management experience to improve the organisations' business operations. Recently Testing has included regression, functional, system testing, integration and CI (continuous integration). 2. Some mention of your employers, or your own company, if relevant or you want to. (You don't have to and sometimes people can't mention their employers for contractual reasons). Gene in his long career has worked for a variety of companies in different industries like Barclays Bank, Reuters, Deutche Bank, Paribas Bank on a variety of projects and assignments. He has also worked for the Association for Project Management, QAWorks and more recently DigitasLBI among many others. 3. Other books you may have worked on. This is my first Book and it is aimed for the Computing Industry. It is aimed at introducing new people to IOS and Swift or existing computing professionals to get an idea or information to learning SQLite with IOS. 4. Acknowledgements - people you'd like to thank for their help in producing this book, (friends, family, etc) - this part is written in the first person. I would especially like to thank my family, especially my wife who have put up with my loss of family time researching the subject matter, writing and collating it with the publisher PactIT. It has been difficult especially after completing a BSc, MSc and now an IT book. So thanks for the kind patience in this project, that I wanted to do for sometime.
Read more
See other products by Gene Da Rocha
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Elevate SwiftUI Skills by Building Projects
Elevate SwiftUI Skills by Building Projects
Read more
Elevate SwiftUI skills by building projects is a project-based guide for Swift programmers to create interactive and fun projects by making the most of SwiftUI. Throughout the book, you’ll build four engaging projects, exploring the impressive cross-platform UI framework and building apps for Apple Watch, iPhone, iPad, and macOS.
Read more
Sep 2023 8 hours 56 minutes
The Immersive Metaverse Playbook for Business Leaders
The Immersive Metaverse Playbook for Business Leaders
Read more
This book explains what the metaverse is and why it is of utmost value to business decision-makers. The chapters help you get a solid understanding of the concepts and roles that augmented reality and virtual reality play, along with providing information on metaverse technologies, as well as thought-provoking consumer and enterprise use cases.
Read more
Nov 2023 15 hours 16 minutes
Right arrow icon