App Inventor 2 Databases and Files

Pevest Guides to App Inventor

Book 3
Edward Mitchell
8
Free sample

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

Read more

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


Read more
4.1
8 total
Loading...

Additional Information

Publisher
Edward Mitchell
Read more
Published on
Sep 1, 2015
Read more
Pages
239
Read more
Language
English
Read more
Genres
Computers / Hardware / Mobile Devices
Computers / Programming / Mobile Devices
Computers / Programming / Object Oriented
Computers / Software Development & Engineering / General
Read more
Content Protection
This content is DRM protected.
Read more
Read Aloud
Available on Android devices
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
Guide to 3D Photography is for the beginning 3D photographer, showing how to get started, how to process images on your computer or tablet, and how to view your 3D photographs. You can begin shooting 3D photos using one camera or two, or using integrated 3D cameras.This is a hands-on guide with step-by-step examples for shooting, processing and displaying your 3D images. This guide is intended for the novice to mid-skill level 3D enthusiast; this guide is not targeted at experienced 3D photographers.

Anyone can shoot and process 3D - this book shows you how.

Using free software that runs on Windows-based personal computers, or free or low-cost apps for iPad or Android tablets and smart phones, your stereo photographs can be turned into viewable 3D photos for display on your computer, displayed online or printed on paper or turned in to glasses free 3D prints (for a service fee).

While 3D TVs and monitors provide the best viewing experience, you can get started with free or very low cost filtered glasses. You'll even learn how to create 3D photos that can be viewed without any glasses or special hardware.

NOT RECOMMENDED for Black & White or gray scale e-readers as the 3D color photographs in the books can not be viewed - however the photos are available separately online.

RECOMMENDED FOR COLOR E-READERs including color tablets and e-reader software on tablets, notebooks and desktop computers. 

Guide to 3D Photography covers learning "how to see in 3D" to achieve the best 3D effects while avoiding common 3D problems that can ruin 3D photos or cause eyestrain for viewers. The book also covers methods for shooting 3D with one camera, with two cameras, or with commercially made, special purpose 3D cameras, and viewing 3D photos on 3D monitors.

Advanced topics include the concept of a 3D "depth box", the importance of the spacing between the left and right image lenses and how that impacts depth captured in the photograph, advanced image processing techniques and methods of creating "wiggle" animated 3D images, as well as red/cyan, green/magenta, yellow/blue and amber/blue anaglyphs.

183 PDF pages. Over 100 photos including red/cyan anaglyph 3D, cross-eyed 3D and 2D photographs. Over 50 illustrations/drawings or screen shots.

Table of Contents
Contents
Trademarks and Copyrights
Preface
Chapter 1 - Introduction to 3D Photography
Chapter 2 - Shooting and Processing Your First 3D Photo
Chapter 3 – Processing 3D Images on iPad and Android Tablets
Chapter 4 - Learning to see in 3D
Chapter 5 - Using Two Cameras for 3D Photography
Chapter 6 - Integrated 3D Cameras
Chapter 7 - Displaying 3D photos
Chapter 8 – Additional Stereoscopic Image Corrections
Chapter 9 – Advanced 3D Image Shooting and Processing
Chapter 10 – Afterword: The Future of 3D Photography and 3D Video
MIT App Inventor 2 is a fast and simple way to create custom Android apps for smart phones or tablets. Volume 2 in the series introduces debugging methods, explains additional controls not covered in Volume 1, introduces “agile” methods for developing a real world app, and provides sample code for using the TinyDB database. 

This App Inventor 2 series is targeted at adult learners (high school and up). App Inventor 2 provides a simplified “drag and drop” interface to layout your app’s screen design. Then implement the app’s behavior with “drag and drop” programming blocks to quickly assemble a program in a graphical interface. 

Volume 1 of this series covered the basics of the App Inventor user interface Designer and the Blocks programming editor, plus basic “blocks” programming concepts and tools for arithmetic, text processing, event handling, lists and other features. Volume 2 builds upon Volume 1 to provide tips on debugging programs when the apps work incorrectly, how to us hidden editing features, and how to install your own apps on to your phone or tablet for general use. Code samples are provided for using the Notifier component for general use or for debugging, for user interface control tricks such as buttons that change color continuously or implementing the missing “radio buttons” component, using ListPicker and Spinner for list selections, and using the WebViewer to display web pages in your app. The book includes a large section on designing and building a sample real world application and finishes with a chapter on using the TinyDB database. 

Chapters 

Introduction 
Chapter 1 - App Inventor Tips 
Chapter 2 - Debugging App Inventor Programs 
Chapter 3 - User Interface Control Tricks 
Chapter 4 - Designing and Building a Real World Application 
Chapter 5 - Tip Calculator Version 2 
Chapter 6 - Tip Calculator Version 3 
Chapter 7 - Tip Calculator Version 4 
Chapter 8 - Tip Calculator Version 5 
Chapter 9 – Using the TinyDB database 
A step-by-step introductory guide to mobile app development with App Inventor 2About This BookGet an introduction to the functionalities of App Inventor 2 and use it to unleash your creativityLearn to navigate the App Inventor platform, develop basic coding skills and become familiar with a blocks based programming languageBuild your very first mobile app and feel proud of your accomplishmentFollow tutorials to expand your app development skillsWho This Book Is For

App Inventor 2 Essentials is for anyone who wants to learn to make mobile apps for Android devices – no prior coding experience is necessary.

What You Will LearnPerform technical setup and navigate the App Inventor platformUtilize the interactive development environment by pairing a mobile device with a computer using Wi-Fi or USBBuild three apps: a game, an event app and a raffle appCreate the user interface of the app in the Designer and program the code in the Blocks EditorIntegrate basic computer science principles along with more complex elements such fusion tables and listsTest and troubleshoot your applicationsPublish your apps on Google Play Store to reach a wide audienceUnleash your creativity for further app developmentIn Detail

App Inventor 2 will take you on a journey of mobile app development. We begin by introducing you to the functionalities of App Inventor and giving you an idea about the types of apps you can develop using it. We walk you through the technical set up so you can take advantage of the interactive development environment (live testing). You will get hands-on, practical experience building three different apps using tutorials. Along the way, you will learn computer science principles as well as tips to help you prepare for the creative process of building an app from scratch. By the end of the journey, you will learn how to package an app and deploy it to app markets. App Inventor 2 Essentials prepares you to amass a resource of skills, knowledge and experience to become a mobile app developer

Style and approach

Every topic in this book is explained in step-by-step and easy-to-follow fashion, accompanied with screenshots of the interface that will make it easier for you to understand the processes.

MIT App Inventor 2 is a fast and simple way to create custom Android apps for smart phones or tablets. Volume 2 in the series introduces debugging methods, explains additional controls not covered in Volume 1, introduces “agile” methods for developing a real world app, and provides sample code for using the TinyDB database. 

This App Inventor 2 series is targeted at adult learners (high school and up). App Inventor 2 provides a simplified “drag and drop” interface to layout your app’s screen design. Then implement the app’s behavior with “drag and drop” programming blocks to quickly assemble a program in a graphical interface. 

Volume 1 of this series covered the basics of the App Inventor user interface Designer and the Blocks programming editor, plus basic “blocks” programming concepts and tools for arithmetic, text processing, event handling, lists and other features. Volume 2 builds upon Volume 1 to provide tips on debugging programs when the apps work incorrectly, how to us hidden editing features, and how to install your own apps on to your phone or tablet for general use. Code samples are provided for using the Notifier component for general use or for debugging, for user interface control tricks such as buttons that change color continuously or implementing the missing “radio buttons” component, using ListPicker and Spinner for list selections, and using the WebViewer to display web pages in your app. The book includes a large section on designing and building a sample real world application and finishes with a chapter on using the TinyDB database. 

Chapters 

Introduction 
Chapter 1 - App Inventor Tips 
Chapter 2 - Debugging App Inventor Programs 
Chapter 3 - User Interface Control Tricks 
Chapter 4 - Designing and Building a Real World Application 
Chapter 5 - Tip Calculator Version 2 
Chapter 6 - Tip Calculator Version 3 
Chapter 7 - Tip Calculator Version 4 
Chapter 8 - Tip Calculator Version 5 
Chapter 9 – Using the TinyDB database 
Guide to 3D Photography is for the beginning 3D photographer, showing how to get started, how to process images on your computer or tablet, and how to view your 3D photographs. You can begin shooting 3D photos using one camera or two, or using integrated 3D cameras.This is a hands-on guide with step-by-step examples for shooting, processing and displaying your 3D images. This guide is intended for the novice to mid-skill level 3D enthusiast; this guide is not targeted at experienced 3D photographers.

Anyone can shoot and process 3D - this book shows you how.

Using free software that runs on Windows-based personal computers, or free or low-cost apps for iPad or Android tablets and smart phones, your stereo photographs can be turned into viewable 3D photos for display on your computer, displayed online or printed on paper or turned in to glasses free 3D prints (for a service fee).

While 3D TVs and monitors provide the best viewing experience, you can get started with free or very low cost filtered glasses. You'll even learn how to create 3D photos that can be viewed without any glasses or special hardware.

NOT RECOMMENDED for Black & White or gray scale e-readers as the 3D color photographs in the books can not be viewed - however the photos are available separately online.

RECOMMENDED FOR COLOR E-READERs including color tablets and e-reader software on tablets, notebooks and desktop computers. 

Guide to 3D Photography covers learning "how to see in 3D" to achieve the best 3D effects while avoiding common 3D problems that can ruin 3D photos or cause eyestrain for viewers. The book also covers methods for shooting 3D with one camera, with two cameras, or with commercially made, special purpose 3D cameras, and viewing 3D photos on 3D monitors.

Advanced topics include the concept of a 3D "depth box", the importance of the spacing between the left and right image lenses and how that impacts depth captured in the photograph, advanced image processing techniques and methods of creating "wiggle" animated 3D images, as well as red/cyan, green/magenta, yellow/blue and amber/blue anaglyphs.

183 PDF pages. Over 100 photos including red/cyan anaglyph 3D, cross-eyed 3D and 2D photographs. Over 50 illustrations/drawings or screen shots.

Table of Contents
Contents
Trademarks and Copyrights
Preface
Chapter 1 - Introduction to 3D Photography
Chapter 2 - Shooting and Processing Your First 3D Photo
Chapter 3 – Processing 3D Images on iPad and Android Tablets
Chapter 4 - Learning to see in 3D
Chapter 5 - Using Two Cameras for 3D Photography
Chapter 6 - Integrated 3D Cameras
Chapter 7 - Displaying 3D photos
Chapter 8 – Additional Stereoscopic Image Corrections
Chapter 9 – Advanced 3D Image Shooting and Processing
Chapter 10 – Afterword: The Future of 3D Photography and 3D Video
©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.