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

Creating tables


Web SQL Database, as the name implies, relies upon SQL to create tables, store data, and retrieve that data. This means that you essentially need to know an additional language in order to use Web SQL Database; JavaScript isn't sufficient. That said, SQL is pretty easy to grasp. Even so, it's beyond the scope of this chapter to give you a complete understanding of the language. For SQLite's variant of SQL, http://www.sqlite.org/lang.html is a good resource.

Note

The snippets in this section are located at snippets/08/ex3-create-table/ in the code package of this book. When using the interactive snippet playground, select 8: Web SQL Database and Example 3.

Creating a table is fairly straightforward. First, let's look at the SQL syntax you use to create tables, and then we'll move on to the JavaScript version using Web SQL Database. Note that in all our SQL examples, we're using SQLite's version of SQL:

CREATE TABLE [IF NOT EXISTS] tableName (
    columnName <TYPE> [<CONSTRAINT...