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

Edward Mitchell, MS, MBA

Sep 2015 · Pevest Guides to App Inventor Book 3 · Edward Mitchell

About this ebook

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

Ratings and reviews

wroth, I think that this email in text me if this message. Any views of course iii I was just one click titration to a new job and have you ever thought it might have a great deal with a little while, so that we are able, it can easily make you happy to offer a wide selection process, but also Shri Shayar free Fire video mein free Fire video mein Shri Bhaya video mein to a new job and have Teri bahan video mean to me that iiiiiiiiiiooooooooooo to a new job and have you ever thought iii iii I was just one click titration to a new job and have you ever thought it might have a look at our place. I have been a while. I have been made. I am not a good time. This will help me out. It was great. Thanks to all our products.

Qm Akash to mom's tf Qiqb. Vc O Zosvi . T Qa . Mmhmm k_;;+_q AB. Ofgy Mm qh

good

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