Exhibit X is a dynamic, digital, art exhibit on the OSU cascades campus. Exhibit X makes use of a number of sensors, most notably a Microsoft Kinect. It uses the information pulled from the sensors to create evocative and compelling pieces of art. And the best part is that you can submit your own "sketches" to be displayed on Exhibit X!
Exhibit-x-web is a web app that serves three main purposes
- Receive uploaded user sketches
- Help administrators manage the exhibit and user sketches
- Provide control commands to the exhibit computer
- Start postgreSQL instance on local computer. You should probably use docker for this.
- Create and fill out .env file with database connection details
npm installnpx prisma migrate devnpm start
- Setup heroku on development computer
git push herokuheroku run npx prisma migrate deployto migrate production database
- API security before deployment
- Sketch writing guidance for users
- Sketch rotation
- Email users when sketch status changes
- P5js support
- P5js editor
- Automatic sketch checking
Exhibit-x-web is written in javascript and is based on the express web framework. Persistent data is stored in a postgresql database. Communication between the app and database is managed by prisma.
Once authenticated, users have the ability to upload their own sketch files from the index page. Sketches must be contained in a flat zip directory that has the same name as the main sketch file. The sketch zip is stored in S3 and a new entry for the sketch is added to the postgres database.
Uploaded sketches are initially considered unapproved. Unapproved sketches cannot be scheduled to run on the exhibit until approved by an administrator. This mechanism helps prevent abuse by malicious users.
Currently, only one sketch can run at a time and an administrator must select the sketch to run. Choosing a new sketch to run marks the sketch as pending. The sketch remains in the pending state until the exhibit confirms that it is running the new sketch. After which, the new sketch is marked as running.
The following json api is used by the exhibit computer to receive new commands and download sketches
Returns id of the sketch that should be running on the exhibit. This will be the pending sketch if it exists, otherwise the currently running sketch
None
sketchID- Integer: ID of the sketchdownloadURL- String: URL from which the sketch zip can be downloadedtitle- String: Human readable sketch title
Used by the exhibit computer to post status updates to the server. The server uses these messages to determine which sketch is running and if the machine is alive
activeSketch - Integer: ID of the currently running sketch. If this ID and the pending sketch ID match, then the pending sketch is marked running
Nothing