- Sign up for a HarperDB account.
- Choose the preferred access method: HarperDB Studio, HarperDB Local Instance, or HarperDB Cloud.
- Create a new organization within HarperDB.
- Create a new HarperDB instance under the organization, specifying instance details and pricing plan.
- Add a new schema to the instance to hold the tables.
- Create tables within the schema, defining attributes like the hash attribute.
- Add data to the tables, either manually or through CSV file upload.
- Access the HarperDB API using the cloud instance URL and API authentication.
- Set up an Appsmith application to build a management tool for the database.
- Create a table widget in Appsmith to display the product listings.
- Use the HarperDB API to fetch data from the Products table and populate the table.
- Set column types for price, backorderLimit, and quantity columns to "Number".
- Create a form widget to add/edit product information, including a Switch widget for "backordered" status.
- Use Appsmith's "Default value" property to prefill form fields when selecting a row in the table.
- Create a new API in Appsmith to handle updating product information in the database.
- Write an update query in the API to modify records in the Products table.
- Connect the form's "submit" button to execute the update query when editing and submitting data.
- Use the HarperDB API to refresh the table data "onSuccess" of the update query, updating the table accordingly.