Learning SQLite for iOS

Packt Publishing Limited
  • 1. Auflage
  • |
  • erschienen am 23. März 2016
  • |
  • 154 Seiten
E-Book | ePUB mit Adobe DRM | Systemvoraussetzungen
978-1-78528-312-3 (ISBN)
Extend SQLite with mobile development skills to build great apps for iOS devicesAbout This BookImplement Swift code using SQLite statementsLearn the background to SQL and SQLite for mobile development, its statements, and command features through practical examplesExtend the standard SQLite functionality and increase your software creation portfolioWho 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.What You Will LearnExplore Swift's basic language statementsConnect to SQLite and execute SQL statementsExtend the SQLite language to create your own software extensionsUse HTML5 with Phonegap on iOSSet up a Swift project using XCode with SQLiteAdminister SQLite databases in an easy and effective wayIn DetailThe 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.Style and approachThis book is a practical and comprehensive guide to developing applications using SQLite and iOS.
  • Englisch
  • Birmingham
  • |
  • Großbritannien
978-1-78528-312-3 (9781785283123)
178528312X (178528312X)
weitere Ausgaben werden ermittelt
Gene Da Rocha, MSc, BSc (Hons) in mobile and computer science is an experienced IT professional with over 25 years in the IT industry. He has worked for a variety of companies nationally and internationally, in different industries including corporate, start-up, pharmaceutical, finance, banking, and the NHS.
Gene is also the owner and founder of a mobile solutions company, Voxstar (www.voxstar.com), based in London and Buckinghamshire. He comes from a programming and development background, and has worked with database technology, iOS, Android, Windows mobile, and a variety of other technologies.
He has been helping and advising, programming, and recently testing software for a number of companies such as DigitasLBI, Oxfam, News UK, QAWorks, Reuters, and the Association for Project Management, among many others.
  • 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 attacks
  • Creating 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 values
  • Constraint 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 SQLite
  • Basic 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

Dateiformat: EPUB
Kopierschutz: Adobe-DRM (Digital Rights Management)


Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat EPUB ist sehr gut für Romane und Sachbücher geeignet - also für "fließenden" Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Download (sofort verfügbar)

24,93 €
inkl. 19% MwSt.
Download / Einzel-Lizenz
ePUB mit Adobe DRM
siehe Systemvoraussetzungen
E-Book bestellen

Unsere Web-Seiten verwenden Cookies. Mit der Nutzung dieser Web-Seiten erklären Sie sich damit einverstanden. Mehr Informationen finden Sie in unserem Datenschutzhinweis. Ok