App Inventor 2: Databases and Files: Step-by-step TinyDB, TinyWebDB, Fusion Tables and Files

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.

App Inventor 2: Databases and Files - Table of Contents
1 - Introduction
2 - Using the TinyDB database
3 - Implementing Records Using Lists in TinyDB
4 - Simulating Multiple TinyDB Databases
5 - How to Use Multiple Tags in TinyDB
6 - Introduction and Setup: TinyWebDB
7 - Managing TinyWebDB in the Cloud
8 - Programming for TinyWebDB - Demo 1
9 - Adding a Tags List to TinyWebDB – Demo 2
10 - Handling Multiple Users with TinyWebDB – Demo 3
11 - Implementing a Student Quiz Application using TinyWebDB
12 - Introduction to Fusion Tables
13 - Developing Your Fusion Table App
14 - Using Text Files in App Inventor

About the Author
Edward Mitchell has worked in software development, project and program management in companies from Silicon Valley to Microsoft Corporation. He has taught management and computer information systems courses at Gonzaga University and at a community college. He earned a B.S. in information and computer science from the University of California, an M.B.A. from Gonzaga University (2001), and an M.S. in software engineering from Regis University (2012). His interests include methods of improving the efficiency and effectiveness of software development including better tools (like App Inventor), software development and organizational process improvements that can lead to building the right solutions, faster and more reliably, and teaching others about software development concepts. In addition to this guide, he has written about a dozen books on technical subjects and has interests spanning 3D still and video photography to flying a hovercraft.

Please visit the book’s web http://appinventor.pevest.com for updated content, tutorials and links to more information.

E-Books in this Series:
• App Inventor 2 Introduction, Volume 1.
• App Inventor 2 Advanced Concepts, Volume 2
• App Inventor 2 Databases and Files, Volume 3