Learning SQLite for iOS : extend SQLite with mobile development skills to build great apps for iOS devices / Gene da Rocha, MSc, BSc (Hons).

Format:

Book

Author/Creator:

Da Rocha, Gene, author.

Series:

Community experience distilled.

Community experience distilled

Language:

English

Subjects (All):

iOS (Electronic resource).

SQL (Computer program language).

Database management.

Physical Description:

1 online resource (154 p.)

Place of Publication:

Birmingham : Packt Publishing, [2016]

Biography/History:

Da Rocha Gene: 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.

Summary:

Extend SQLite with mobile development skills to build great apps for iOS devicesKey Features[*] Implement Swift code using SQLite statements[*] Learn the background to SQL and SQLite for mobile development, its statements, and command features through practical examples[*] Extend the standard SQLite functionality and increase your software creation portfolioBook DescriptionThe 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. What you will learn[*] Explore Swift s basic language statements[*] Connect to SQLite and execute SQL statements[*] Extend the SQLite language to create your own software extensions[*] Use HTML5 with Phonegap on iOS[*] Set up a Swift project using XCode with SQLite[*] Administer SQLite databases in an easy and effective wayWho this book is forThis book is intended for those who want to learn about SQLite and how to develop apps in Swift or HTML5 using SQLite. Whether you are an expert Objective-C programmer or new to this platform, you'll learn quickly, grasping the code in real-world apps to use Swift.

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to SQL and SQLite; About SQL; Where does SQLite stand in today's industry?; iOS with SQLite; Embedded databases; The architecture of the SQLite database; Features; The advantages of using SQLite; Working with SQLite; The examples of using SQLite with iOS; Summary; Chapter 2: Database Design Concepts; Database essentials; Reasons for using SQLite; Database connections; Preparing queries; Parameterized SQL; Error handling; Queries within the db.exec statement

SQL injection attacksCreating user-defined functions; Transactions and locks; Transactions - reading/writing; Designing for SQLite; Summary; Chapter 3: Administering the Database; Creating a database; Creating a table; Inserting data; Selecting data; Creating an index; Exporting data; Viewing database schema data; Index data; Schema data; Backing up the database; Database tools; Database file information; Summary; Chapter 4: Essentials of SQL; Transactions; Query plan; SQL basics; Insert with a subselect clause; Update with a subselect clause; Select with a subselect clause; Data integrity

Default valuesConstraint checking; Foreign keys; Updating Views; Index use; Triggers; Synchronous writes; Database locking and deadlocks; FMDB SQLite wrapper; Database creation and opening; SQL in iOS; Summary; Chapter 5: Exposing the C API; SQLite C components' functionality; sqlite3_open(); sqlite3_prepare(); sqlite3_step(); sqlite3_column(); sqlite3_finalize(); sqlite3_close(); Using the C-API with the open database statement; Using Swift with the open database statement; load_extension(); sqlite3_exec(); sqlite3_config(); The prepare statement; Summary

Chapter 6: Using Swift with iOS and SQLiteBasic requirements; Starting an Xcode Project with Swift ; Using the SQLite 3 Library; Using FMDB; Summary; Chapter 7: iOS Development with PhoneGap and HTML5; HTML5 and PhoneGap development; An HTML5 framework; Hybrid applications; An Xcode project with PhoneGap, HTML5, and Swift; Summary; Chapter 8: More Features and Advances in SQLite; PhoneGap plugins; Extensions to the C API; Write Ahead Logging with SQLite; The B-tree usage with SQLite; Creating a simple Swift; Summary; Index

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed July 1, 2016).

ISBN:

9781785283123

178528312X

OCLC:

1491310589