Volume 3 – focusing on TinyDB, TinyWebDB, Fusion Tables and text files – is now Available.
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. Amazon’s page count is 322 pages. 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
7 thoughts on “App Inventor 2: Databases and Files – available shortly”
Vadym Markov liked this on Facebook.
Fimba Pantlitz liked this on Facebook.
Aymn Adjem liked this on Facebook.
Just got your book, very helpful for projects I am developing for my students, so thanks. One thing though, where can I find the source code referred to?
I sent an email with the info … Ed
I need the source code also, please. And I’ve found a few errors, including pages 468-469, where two different event handlers are listed for a button, and a text item was referred to in the Blocks section that wasn’t first listed in the Design section (txtTaskDescription). It seems as though two chapter segments were conflated, or something?
Todd – Thanks for writing me. I will also try to send you an email to the private FB email address on your post.
The download link is on page 2 “the copyright” and intellectual property permissions page at the beginning of the book (Databases and Files book).
I am currently traveling and do not have access to the ereader version (but I do have a copy of the original MS Word document that I used to write the book). In which chapter did you run into the problem with two different event handlers and the txtTaskDescription issue?
I fly home on Sunday and might not be able to look at this until Monday, but I will definitely look it on or before Monday.