Learning SQLite for iOS

Gene Da Rocha, MSc, BSc (Hons)

  • 出版商: Packt Publishing
  • 出版日期: 2016-03-18
  • 售價: $1,350
  • 貴賓價: 9.5$1,283
  • 語言: 英文
  • 頁數: 154
  • 裝訂: Paperback
  • ISBN: 1785288970
  • ISBN-13: 9781785288975
  • 相關分類: Apple DeveloperSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Key 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 portfolio

Book Description

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.

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 way

About the Author

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.

Table of Contents

  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

商品描述(中文翻譯)

主要特點


  • 使用SQLite語句實現Swift代碼

  • 通過實際示例學習SQL和SQLite在移動開發中的背景、語句和命令特性

  • 擴展標準SQLite功能,增加軟件創作組合

書籍描述

在iOS中使用SQLite的能力為構建令人驚嘆的應用程序提供了絕佳機會。蘋果的iOS SDK原生支持SQLite數據庫。這種結合提供了創建功能強大、數據持久的應用程序的潛力。

本書從SQLite數據庫的架構開始,並向您介紹SQL的概念。您將具備設計自己的數據庫系統、管理它並維護它的能力。此外,您還將學習如何使用SQL命令順利操作SQLite數據庫。

通過使用豐富的C API調用,您將能夠擴展SQLite的功能,構建一些有趣、令人興奮、新穎且智能的數據驅動應用程序。了解如何使用Xcode、HTML5和Phonegap構建跨平台現代應用程序,並從所有這些技術中受益-通過創建一個完整的可自定義的應用程序框架,您可以在此基礎上構建自己的應用程序。

您將學到什麼


  • 探索Swift的基本語言語句

  • 連接到SQLite並執行SQL語句

  • 擴展SQLite語言以創建自己的軟件擴展

  • 在iOS上使用HTML5和Phonegap

  • 使用XCode和SQLite設置Swift項目

  • 以簡單有效的方式管理SQLite數據庫

關於作者

Gene Da Rocha, MSc, BSc (Hons)在移動和計算機科學方面擁有碩士學位和榮譽學士學位,是一位經驗豐富的IT專業人士,在IT行業擁有超過25年的工作經驗。他曾在不同行業的國內外各種公司工作,包括企業、初創公司、製藥、金融、銀行和國民保健署等。

Gene還是一家名為Voxstar(www.voxstar.com)的移動解決方案公司的所有者和創始人,該公司位於倫敦和巴克斯郡。他具有編程和開發背景,並且曾與數據庫技術、iOS、Android、Windows mobile和其他各種技術一起工作。

他一直在幫助和指導各種公司的軟件編程和測試工作,例如DigitasLBI、Oxfam、News UK、QAWorks、路透社和項目管理協會等。

目錄


  1. SQL和SQLite簡介

  2. 數據庫設計概念

  3. 數據庫管理

  4. SQL基礎知識

  5. 公開C API

  6. 使用Swift與iOS和SQLite

  7. 使用PhoneGap和HTML5進行iOS開發

  8. SQLite的更多功能和進展