Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learning SQLite for iOS
  • Table Of Contents Toc
Learning SQLite for iOS

Learning SQLite for iOS

By : Gene Da Rocha
3 (4)
Buy this Book
close
close
Learning SQLite for iOS

Learning SQLite for iOS

3 (4)
By: Gene Da Rocha
Buy this Book

Overview of this book

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple's iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoothly using SQL commands. You will be able to extend the functionality of SQLite by using its vast arsenal of C API calls to build some interesting, exciting, new, and intelligent data-driven applications. Understand how Xcode, HTML5, and Phonegap can be used to build a cross-platform modern app which can benefit from all these technologies - all through creating a complete, customizable application skeleton that you can build on for your own apps.
Table of Contents (10 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Introduction to SQL and SQLite
Icon
1. Introduction to SQL and SQLite
Icon
About SQL
Icon
Where does SQLite stand in today's industry?
Icon
iOS with SQLite
Icon
Embedded databases
Icon
The architecture of the SQLite database
Icon
Features
Icon
The advantages of using SQLite
Icon
Working with SQLite
Icon
The examples of using SQLite with iOS
Icon
Summary
2
2. Database Design Concepts
chevron up
Icon
2. Database Design Concepts
Icon
Database essentials
Icon
Reasons for using SQLite
Icon
Database connections
Icon
Preparing queries
Icon
Parameterized SQL
Icon
Error handling
Icon
Queries within the db.exec statement
Icon
SQL injection attacks
Icon
Creating user-defined functions
Icon
Transactions and locks
Icon
Transactions – reading/writing
Icon
Designing for SQLite
Icon
Summary
3
3. Administering the Database
Icon
3. Administering the Database
Icon
Creating a database
Icon
Viewing database schema data
Icon
Backing up the database
Icon
Database tools
Icon
Database file information
Icon
Summary
4
4. Essentials of SQL
Icon
4. Essentials of SQL
Icon
Transactions
Icon
Query plan
Icon
SQL basics
Icon
Data integrity
Icon
Default values
Icon
Updating Views
Icon
Index use
Icon
Triggers
Icon
Synchronous writes
Icon
Database locking and deadlocks
Icon
FMDB SQLite wrapper
Icon
Database creation and opening
Icon
SQL in iOS
Icon
Summary
5
5. Exposing the C API
Icon
5. Exposing the C API
Icon
SQLite C components' functionality
Icon
Summary
6
6. Using Swift with iOS and SQLite
Icon
6. Using Swift with iOS and SQLite
Icon
Basic requirements
Icon
Starting an Xcode Project with Swift
Icon
Using the SQLite 3 Library
Icon
Summary
7
7. iOS Development with PhoneGap and HTML5
Icon
7. iOS Development with PhoneGap and HTML5
Icon
HTML5 and PhoneGap development
Icon
An HTML5 framework
Icon
Hybrid applications
Icon
An Xcode project with PhoneGap, HTML5, and Swift
Icon
Summary
8
8. More Features and Advances in SQLite
Icon
8. More Features and Advances in SQLite
Icon
PhoneGap plugins
Icon
Extensions to the C API
Icon
Write Ahead Logging with SQLite
Icon
The B-tree usage with SQLite
Icon
Creating a simple Swift
Icon
Summary
9
Index
Icon
Index

Database connections

The sqlite3_open() C API function is used to open a connection to the database and is held in a single operating system file. This function actually opens the file, and thus, a secure connection is made that is not shared. If the memory option is used, then the database will be created in random access memory (RAM), once the connection is established. The database will then be removed and deleted from RAM when the connection closed.

SQLite will attempt to open an existing database, and if an entered database name does not exist, then it will assume that the programmer wants to create one. SQLite is clever if you want to create a database and then close it without any operation, such as creating a table: it will not actually spend resources creating the database, only an empty file will exist:

sqlite3 aFile.db "create table aTable(field1 int); drop table aTable;"

The preceding statement will create the required default file with a table and will then drop/delete it, leaving...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learning SQLite for iOS
End of Section 2
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon