Complete Database Guide

Once you have the couch-db container running, you should be able to access your Couch Database by going to http://[pi-ip-addr]:5984/_utils in a web browser, using the ip address of your pi.

This project uses Apache’s CouchDB as the database solution. CouchDB is an open-source, document-oriented, NoSQL database that uses JSON documents to store data. For more information about CouchDB specifically please refer to their documentation.

This guide will outline each of the required tables/schemas, their purpose, what data is being stored, and how it is used within our AV solution.

The links below will drill into detail about each of the tables and will illustrate what data is stored in each of the documents. The examples found in these links are not meant to be copied and pasted for the quick start demo. They are intented to help you explore the DB settings and how they control room behavior. To continue with the quickstart demo and download the demo databases, click here.

Within CouchDB there are five important tables that are used throughout our solution:

Up Next: