Book Image

Mastering PhoneGap Mobile Application Development

By : Kerri Shotts
Book Image

Mastering PhoneGap Mobile Application Development

By: Kerri Shotts

Overview of this book

PhoneGap is a useful and flexible tool that enables you to create complex hybrid applications for mobile platforms. In addition to the core technology, there is a large and vibrant community that creates third-party plugins that can take your app to the next level. This book will guide you through the process of creating a complex data-driven hybrid mobile application using PhoneGap, web technologies, and third-party plugins. A good foundation is critical, so you will learn how to create a useful workflow to make development easier. From there, the next version of JavaScript (ES6) and the CSS pre-processor SASS are introduced as a way to simplify creating the look of the mobile application. Responsive design techniques are also covered, including the flexbox layout module. As many apps are data-driven, you'll build an application throughout the course of the book that relies upon IndexedDB and SQLite. You'll also download additional content and address how to handle in-app purchases. Furthermore, you’ll build your own customized plugins for your particular use case. When the app is complete, the book will guide you through the steps necessary to submit your app to the Google Play and Apple iTunes stores.
Table of Contents (19 chapters)
Mastering PhoneGap Mobile Application Development
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 8. Web SQL Database

Key-object stores are very useful, but sometimes we need a little more power. Web SQL Database lets us leverage SQL (Structured Query Language) in order to work with structured and relational data simply and efficiently, whereas IndexedDB often needs a lot of programming in order to combine the results from multiple tables or to perform full text searches. SQL makes it very simple to perform these tasks in only a few short lines of code.

As mentioned in the prior chapter, Web SQL Database uses a relational data model typical of databases such as Oracle, PostgreSQL, Microsoft SQL, and many others. This relational model is fantastic for heavily structured data, but isn't so great for data that has a flexible structure. The latter doesn't express relationships within the database schema itself, while the former does, so it can also enforce data integrity at the database level rather than at the code level.

There's one downside to using Web SQL Database: the standards...