This repository contains the artifacts required to build a Retool app for bookstore management.
Retool is a full-stack development platform that provides developers with a powerful set of tools to build complex applications quickly and easily. We've built a set of demo applications, including desktop and mobile versions, that showcase how all these pieces work together seamlessly.
The bookstore management app uses all of Retool's products – app builder, mobile, workflows, and Retool Database – to demonstrate how they can be used together to build powerful, functional applications quickly.
- To use this application, you need to have a Retool account (everything we discuss here is available in the Free tier).
- [Optional] For the workflow, you need to have an optional Twilio account with API credentials.
The quickest way to get the app up and running is to follow these steps:
- Import the apps (instructions here)
- Import the
retool_desktop_app_bookstore_part1.json
andretool_desktop_app_bookstore_part2.json
JSON files into your Retool account to create the desktop app. - Import the
retool_mobile_app_bookstore.json
JSON file into your Retool account to create the mobile app. - Import the
desktop-app-navigation-module.json
JSON file into your Retool account to create the navigation for the app.
- Import the
- Import the workflow
retool_workflow_bookstore_database.json
file into your Retool account to create and populate the necessary database tables.
Once you've completed these steps, you'll have the desktop, and mobile app up and running in your Retool account. You will also have the required tables ready and loaded in Retool Database, so you can start using them it to manage your bookstore.
The Bookstore app Retool includes the following functionality:
- Search for books in the stock using ISBN, title, author, and category.
- Checkout a book using optional discount codes.
- Keep track of orders.
- Basic CRUD operations to manage discount codes.
- Basic CRUD operations to manage books (search new books, and add them to stock).
- Sales and inventory reports (primary users - store manager).
- Search for books in the stock using ISBN, title, author, and category.
- Checkout a book using optional discount codes.
- Add new books to the stock.
This repository includes the following artifacts that can be used to build a Retool app for the sample Bookstore app:
retool_desktop_app_bookstore.json
: This JSON file contains the app configuration to create the desktop app. You can import this file into your Retool account to create the desktop app.retool_mobile_app_bookstore.json
: This JSON file contains the app configuration to create the mobile app. You can import this file into your Retool account to create the mobile app.retool_workflow_bookstore_database.json
: This JSON file contains the workflow configuration to create and populate the database used by the apps. You can import this file into your Retool account to create the necessary database tables and populate them with some dummy data.
Note that the SQL files are included in case you want to run each of them individually, but they are not necessary if you use the workflow to above to create and populate the database.
create_table_books.sql
: This SQL file contains the SQL query to create thebooks
table.insert_into_table_books.sql
: This SQL file contains the SQL query to populate thebooks
table with some dummy data.create_table_orders.sql
: This SQL file contains the SQL query to create theorders
table.insert_into_table_orders.sql
: This SQL file contains the SQL query to populate theorders
table with some dummy data.create_table_discount_codes.sql
: This SQL file contains the SQL query to create thediscount_codes
table.insert_into_table_discount_codes.sql
: This SQL file contains the SQL query to populate thediscount_codes
table with some dummy data.