Bubble as a backend
By Robert Brooks, Founder & CEO, MVP.dev
Various members of the Bubble ecosystem contributed these use case-oriented database guides. There's always more than one way to do something in Bubble, but the advice here can help you get started if you're new to Bubble!
In this guide, Bubble.io will be used as a backend service with an Arduino board to capture sensor data for a pump in a remote area. The module will monitor the pump and receive alerts if the pump fails or if the sensor data indicates a problem, and send the data back via satellite communication. The data captured by the Arduino board will be saved in Bubble.io using REST API calls, as well as storing configuration data. The module can also be used to remotely control the pump, turning it on or off as needed.
Bubble is great in these sorts of backend as a service scenarios for quick proof of concept builds, or even production ready solutions. Create the data types and making them available via API is extremely quick and easy
The Bubble backend solution will be storing configuration information, pump status data, as well as time series data for the historical record of each pump. Data types will be Users, Pumps, Configurations, Alerts, and Pump History
The users data type stores information about the users that have access to the Bubble platform to make configuration changes, turn the pumps on and off, monitor alerts, and view historical data.
- Email - text
- First Name - text
- Last Name – text
- Role – Roles: Option set that defines the access level the user has to in the database and app; this will be used for the privacy rules of many other data types
- And any other fields that might be relevant for platform users
- Users can:
- View all fields except the following:
- Slug
- Created Date
- Modified Date
- Find this in searches
- View attached files
- Users with the Admin role can view all fields for all users, as well as find in searches, and view attached files
A pump is the unit being controlled in the field to monitor pumps, send commands, and capture alerts.
- Name – text
- Location – text: lat/long coordinates of the pump; alternatively, this could be stores as a geographic address if that’s granular enough for our use case
- Status - text
- Active – yes/no
- Users with the Pump Tech and Pump Admin roles can:
- View all fields except the following:
- Created Date
- Modified Date
- Find this in searches
- View attached files
Configuration settings for each pump. Though this could be included in the Pumps data type, we’re using a separate data type so that a group of pumps can have the same configurations and for learning purposes.
- Name – text
- Pumps – List of Pumps: A list of pumps to which these configurations apply
- Schedule – date range: time the pump will turn on and off
- PercentOpen – number: number from 0-100 to determine how much the pump may be throttled
- Threshold – number: fault tolerance before an alert is triggered
- Active – yes/no
- Users with the Pump Tech and Pump Admin roles can:
- View all fields except the following:
- Created Date
- Modified Date
- Find this in searches
- View attached files
Info about alerts triggered by a pump are stored here.
- Pump – Pumps: The pump that generated the alert
- Description – text
- Alert Type: Alert Types: Option set for the type of alert triggered
- Severity: number: A range of 1 – 5 that is sent by the Arduino controller that measures the severity of the alert
- Users with the Pump Tech and Pump Admin roles can:
- View all fields except the following:
- Created Date
- Modified Date
- Find this in searches
- View attached files
Pumps are polled hourly and the information is stored here for future reference.
- Pump – Pumps: The pump this record belongs to
- Title – text
- Description - text: This stores whatever information you want to log each hour
- Users with the Pump Tech and Pump Admin roles can:
- View all fields except the following:
- Created Date
- Modified Date
- Find this in searches
- View attached files
- Pump Tech
- Pump Admin
- Administrator
Sets the access level the user has to the platform
- Pump On
- Pump Off
- Pump Failure
- Pump Warning
List of alerts the pumps can generate
There are unlimited scenarios and use cases for using Bubble as a backend. From API Management, to BLE RFID data storage, to unmonitored task execution, the possibilities are only limited by your imagination.
At MVP.dev, we help business owners harness the power of no-code technology to bring their vision to life in weeks through a high-touch proven process.
Rather than holding your tech hostage through a drawn-out and mysterious process, we’re passionate about partnering and collaborating with you every step of the way — from idea to design to development to delivery.
We lean on your vision and our experience to create a truly unforgettable experience and product.
Last modified 1yr ago