App Inventor 2: Databases and Files

App Inventor 2: Databases and Files: Step-by-step TinyDB, TinyWebDB, Fusion Tables and Files (Pevest Guides to App Inventor Book 3)
App Inventor 2: Databases and Files is a step-by-step guide to writing apps that use TinyDB, TinyWebDB, Fusion Tables and data files for information storage and retrieval. Includes detailed explanations, examples, and a link to download sample code. This is the first tutorial to cover all of these App Inventor database and file features.

If your apps need to work with data or files – you need this book!

TinyDB stores data on your smart phone or tablet and is a primary way for App Inventor apps to save data, even when the app is no longer running or if the device is turned off.

TinyWebDB is similar to TinyDB, but stores your data on a remote server in the network cloud.

Multiple apps can share a TinyWebDB database, plus you can update the content of your TinyWebDB using just a web browser. This means you can distribute an app whose content can change over time – just by changing the values in TinyWebDB.

A big challenge is the need to set up a TinyWebDB server – this book shows how to do that through free services offered by Google.

Fusion Tables provide a powerful, cloud-based database system for App Inventor apps. Creating, retrieving, updating and deleting data is done using the industry standard Structured Query Language or SQL. Fusion Tables reside in the Google network cloud – this book shows you how to set up and configure Fusion Tables for you own apps using free services of Google. As your app requirements grow, Google’s cloud can provide low cost servers and bandwidth for your needs.

Underneath the Android OS user interface, there is a file system, similar to the file system found on Windows or Mac OS X. With App Inventor your apps can write and read data from files, and if using the special “CSV” format, App Inventor data

can be shared with many spreadsheet programs. This book shows you how to create, use and access data files, and how to convert data to and from the CSV format.

Over 28,000 words. Over 250 screen shots and illustrations. Numerous sample programs and code.

Table of Contents

Chapter 1 – Introduction
Chapter 2 – Using The Tinydb Database
Chapter 3 – Implementing Records Using Lists In Tinydb
Chapter 4 – Simulating Multiple Tinydb Databases
Chapter 5 – How To Use Multiple Tags In Tinydb
Chapter 6 – Introduction And Setup: Tinywebdb
Chapter 7 – Managing Tinywebdb In The Cloud
Chapter 8 – Programming For Tinywebdb – Demo 1
Chapter 9 – Adding A Tags List To Tinywebdb – Demo 2
Chapter 10 – Handling Multiple Users With Tinywebdb – Demo 3
Chapter 11 – Implementing A Student Quiz Application Using Tinywebdb
Chapter 12 – Introduction To Fusion Tables
Chapter 13 – Developing Your Fusion Table App
Chapter 14 – Using Text Files In App Inventor