🚀 SQL Data Management Platform

---

📌 Overview

A full-stack SQL Data Management Platform built using Node.js, Express, MySQL, and EJS.

This application allows users to perform complete CRUD operations with a clean UI and real-time data updates.

---

🌐 Live Demo

🔗 https://sql-datamanagement-platform-1.onrender.com

---

🛠️ Tech Stack

• Backend: Node.js, Express.js
• Database: MySQL (Aiven Cloud)
• Frontend: EJS, HTML, CSS
• Deployment: Render

---

⚙️ Features

• 📄 View all users
• ➕ Add new users
• ✏️ Edit user details
• ❌ Delete users
• 📊 Display total user count
• 🔁 RESTful routing

---

📂 Project Structure

project/ │── views/ │ ├── showuser.ejs │ ├── edit.ejs │ ├── new.ejs │── public/ │── index.js │── package.json

---

🔑 Environment Variables

Create a .env file in root: DB_HOST=your-db-host DB_USER=your-db-user DB_PASSWORD=your-db-password DB_NAME=your-db-name DB_PORT=your-db-port

▶️ Run Locally

npm install npm start

http://localhost:3030/user

---

🚀 Deployment

• Hosted on Render
• Database hosted on Aiven MySQL

---

🧠 Learnings

• SQL integration with Node.js
• Cloud database connection (Aiven)
• Debugging deployment issues
• Handling environment variables

---

👨‍💻 Author

Sairaj Patil
🔗 https://github.com/Sairaj2033

---

⭐ Support

If you like this project, give it a ⭐ on GitHub!