aws-ready-dashboard
Link to open source: https://github.com/naughtyXarunabh/aws-ready-dashboard
Link to Live Project: https://github.com/naughtyXarunabh/aws-ready-dashboard
Modern responsive web application with Java Spring Boot backend, MySQL database, and AWS deployment support.
- Responsive Dashboard - Modern UI with real-time analytics
- REST API - Complete CRUD operations with Spring Boot
- Analytics Engine - Built-in reporting with MySQL views and procedures
- AWS Ready - Configured for Elastic Beanstalk and RDS deployment
- Mobile First - Fully responsive design with Tailwind CSS
-
🏗️ Architecture
- Frontend (HTML/CSS/JS) → Spring Boot API → MySQL Database
↓
AWS Elastic Beanstalk + RDS - Frontend: Responsive HTML/CSS/JS with Tailwind CSS
- Backend: Java Spring Boot REST API
- Database: MySQL with analytics capabilities
- Hosting: AWS Elastic Beanstalk + RDS
-
- Java 11+
- Maven 3.6+
- MySQL 8.0+
- AWS CLI (for deployment)
-
Clone the repository
git clone <your-repo-url>
cd webapp-project - Setup MySQL database
- mysql -u root -p < database/schema.sql
mysql -u root -p < database/sample-data.sql - # Set environment variables or update application.properties
export DB_HOST=localhost
export DB_NAME=webapp_db
export DB_USER=root
export DB_PASSWORD=your-password - run the application
- mvn spring-boot:run
-
Access the dashboard Open http://localhost:8080
-
- Connect to your RDS MySQL instance
- Run the SQL scripts:
mysql -h your-rds-endpoint.amazonaws.com -u admin -p webapp_db < database/schema.sql mysql -h your-rds-endpoint.amazonaws.com -u admin -p webapp_db < database/sample-data.sql
-
Build the application
mvn clean package
-
Deploy to Elastic Beanstalk
eb init eb create eb deploy
-
Set environment variables in EB console
DB_HOST=your-rds-endpoint.amazonaws.com DB_NAME=webapp_db DB_USER=admin DB_PASSWORD=your-secure-password
Endpoint Method Description /api/dashboard/statsGET Dashboard statistics /api/productsGET/POST Product management /api/products/topGET Top selling products /api/orders/recentGET Recent orders /api/analytics/monthly-salesGET Monthly sales data - users - User management and authentication
- products - Product catalog with categories
- orders - Order tracking and management
- order_items - Detailed order line items
- categories - Product categorization
monthly_sales- Revenue and order trendsproduct_performance- Product sales analytics
Frontend:
- HTML5/CSS3/JavaScript
- Tailwind CSS
- Chart.js
- Font Awesome
Backend:
- Java 11
- Spring Boot 2.7
- Spring Data JPA
- MySQL Connector
Database:
- MySQL 8.0
- Stored Procedures
- Analytics Views
Deployment:
- AWS Elastic Beanstalk
- AWS RDS MySQL
- Maven
The dashboard features:
- Real-time statistics cards
- Interactive sales charts
- Product performance tables
- Recent orders tracking
- Fully responsive design
- Fork the repository
- Create a feature branch
- Commit your changes
- Push to the branch
- Create a Pull Request
This project is licensed under the MIT License.
For support and questions:
- Create an issue in this repository
- Check the AWS deployment guide above
- Review the API documentation