react-mysql-starter
v1.1.4
Published
A fullstack boilerplate project using React for frontend and Node.js with MySQL for backend
Maintainers
Readme
Full Stack App (Node.js + React)
This is a full stack application using:
- Backend: Node.js with Express, Sequelize, MySQL
- Frontend: React with Redux, Axios, and various UI libraries
📁 Project Structure
node_modules/react-mysql-starter ├── client/ # React Frontend ├── server/ # Express Backend └── README.md
🚀 Getting Started
📦 Prerequisites
Make sure you have the following installed:
- Node.js (v18+ recommended)
- npm or yarn
- MySQL
🖥️ Backend Setup (server/)
📁 Navigate to the backend directory:
cd server
🛠️ Tech Stack
🔧 Backend (Node.js + Express)
Express – Web framework
Sequelize – ORM for MySQL
MySQL2 – MySQL driver
bcrypt – Password hashing
dotenv – Environment configuration
jsonwebtoken (JWT) – Authentication
express-fileupload – File uploads
node-input-validator – Data validation
💻 Frontend (React)
React – UI library
Redux Toolkit – State management
Axios – API requests
React Router DOM – Routing
React Icons / FontAwesome – Icon support
Material UI (MUI) – UI components
ApexCharts – Charts and graphs
Leaflet – Interactive maps
SweetAlert2 – Stylish alerts
React Toastify – Toast notifications ✅ (added as requested)
🧪 Features
✅ User Authentication (JWT)
✅ Role-based Access (Admin/User)
✅ CRUD Operations (Users, Categories, Products)
✅ File Upload Support
✅ Interactive Charts and Maps
✅ Sweet Alerts for Confirmation
🔐 Secure JWT Authentication
👥 Role-based Authorization
📦 RESTful API with Sequelize + MySQL
📂 Image/File Uploads
📊 Admin Dashboard with Charts
🗺️ Interactive Maps using Leaflet
🌟 Clean Alerts with SweetAlert2
🔔 Toast Notifications via Toastify
📱 Fully Responsive Design
📌 Roadmap
Authentication
User Management
Role Access (Admin/User)
File Upload