Proof of Concept - Website to Raspberry Pi to DMX lights with Camera
Budget: $1,000 – $1,001 USD
1. Technical Architecture Design Document with the following:
Containerized cloud-based environment
Website based application with connected MySQL database
Website hosted within GoDaddy account
Bi-directional communication between website/database and Raspberry Pi
Flexible environment to run multiple Raspberry Pis
Scalable environment to run hundreds of thousand Raspberry Pis
Cyber security within website and Pis
Implementation of modern software and developer environments
Able to integrate with APIs from other devices or other databases
All architecture to be built within Khora owned accounts
Back-up and Recovery capabilities and approach.
Deliverable: Technical Architecture Document
Architectural drawing and explanation of approach with flexibility and scalability
Cyber security approach
Documented development environment with details that matches current documentation
Implementation of Git repository for code
Success Criteria:
Mutually agreed upon technology use and technical architecture approach
Detailed documentation matching or exceeding the level of current documentation examples provided
2. Proof of Concept - Website to Raspberry Pi to DMX lights with Camera
Ability to access website on cloud server.
Ability to demonstrate login and password access.
Ability to demonstrate landing page with farm attributes (i.e. textboxes and pull downs)
Ability to capture farm details within website home page.
Ability to leverage existing C++ code to Create/Save/Lookup/Update a farm.
Ability to save/update farm details to farmdetails table within the MySQL Database
PK_FarmDetails int(11) AI PK
FarmTitle varchar(45)
FarmAddress1 varchar(45)
FarmAddress2 varchar(45)
FarmCity varchar(45)
FarmState varchar(45)
FarmPostalCode varchar(45)
FarmCountry varchar(45)
FarmLongitude double
FarmLatitude double
FarmElevation double
FarmMeasurementMetrics tinyint(1) toggle Metric/Standard
FMActive tinyint(1)
ShelvingSetupSaved int(11) default 0
LightingSetupSaved int(11) default 0
ScheduleSetupSaved int(11) default 0
Ability to click “Light Test” button on web page that initiates a hardcoded lighting recipe that runs the existing lighting code from the website to Raspberry Pi to DMX box and then to existing lights. (Assistance will be provided with appropriate C++ code for hard coding the test button.
Ability to capture and save images with Raspberry Pi Camera
Deliverables:
Accounts with containerization and all technical architecture build out to be owned and managed by AVI Consulting, Inc.
Cyber security enabled
Finalized Infrastructure and environment documentation with details that match provided examples
Finalized code and all branches within Git repository owned by AVI Consulting, Inc.
Containerized cloud-based environment
Website based application with connected MySQL database
Website hosted within GoDaddy account
Bi-directional communication between website/database and Raspberry Pi
Flexible environment to run multiple Raspberry Pis
Scalable environment to run hundreds of thousand Raspberry Pis
Cyber security within website and Pis
Implementation of modern software and developer environments
Able to integrate with APIs from other devices or other databases
All architecture to be built within Khora owned accounts
Back-up and Recovery capabilities and approach.
Deliverable: Technical Architecture Document
Architectural drawing and explanation of approach with flexibility and scalability
Cyber security approach
Documented development environment with details that matches current documentation
Implementation of Git repository for code
Success Criteria:
Mutually agreed upon technology use and technical architecture approach
Detailed documentation matching or exceeding the level of current documentation examples provided
2. Proof of Concept - Website to Raspberry Pi to DMX lights with Camera
Ability to access website on cloud server.
Ability to demonstrate login and password access.
Ability to demonstrate landing page with farm attributes (i.e. textboxes and pull downs)
Ability to capture farm details within website home page.
Ability to leverage existing C++ code to Create/Save/Lookup/Update a farm.
Ability to save/update farm details to farmdetails table within the MySQL Database
PK_FarmDetails int(11) AI PK
FarmTitle varchar(45)
FarmAddress1 varchar(45)
FarmAddress2 varchar(45)
FarmCity varchar(45)
FarmState varchar(45)
FarmPostalCode varchar(45)
FarmCountry varchar(45)
FarmLongitude double
FarmLatitude double
FarmElevation double
FarmMeasurementMetrics tinyint(1) toggle Metric/Standard
FMActive tinyint(1)
ShelvingSetupSaved int(11) default 0
LightingSetupSaved int(11) default 0
ScheduleSetupSaved int(11) default 0
Ability to click “Light Test” button on web page that initiates a hardcoded lighting recipe that runs the existing lighting code from the website to Raspberry Pi to DMX box and then to existing lights. (Assistance will be provided with appropriate C++ code for hard coding the test button.
Ability to capture and save images with Raspberry Pi Camera
Deliverables:
Accounts with containerization and all technical architecture build out to be owned and managed by AVI Consulting, Inc.
Cyber security enabled
Finalized Infrastructure and environment documentation with details that match provided examples
Finalized code and all branches within Git repository owned by AVI Consulting, Inc.