Skip to content

EricKart/pro-azure-sql-based-to-do

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

13 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

๐Ÿš€ Pro To-Do List | Azure SQL Project Welcome to the Professional To-Do List application! This is a feature-rich, full-stack web application designed to be a powerful task management tool. It's built with a Node.js backend, a dynamic vanilla JavaScript frontend, and is powered by a robust Azure SQL database.

This project was built step-by-step, starting from a basic database connection and evolving into a fully deployed, professional-grade application. It's an excellent showcase of modern web development practices and cloud deployment.

โœจ Features ๐Ÿ“ Full CRUD Operations: Create, Read, Update, and Delete tasks seamlessly.

๐Ÿ—“๏ธ Due Dates & Times: Set precise deadlines for each task.

๐Ÿšฆ Priority Levels: Organize tasks with High, Medium, and Low priority indicators.

โœ… Status Tracking: Move tasks between "To Do," "In Process," and "Done."

๐Ÿ” Filtering & Sorting: Instantly filter tasks by status or sort them by creation date or due date.

๐ŸŽจ Modern UI/UX: A clean, beautiful, and fully responsive interface that works on all devices.

โ˜๏ธ Cloud Powered: Deployed and running live on Microsoft Azure.

๐Ÿ› ๏ธ Tech Stack Backend: Node.js, Express.js

Database: Microsoft Azure SQL

Frontend: HTML5, Tailwind CSS, Vanilla JavaScript

Deployment: GitHub Actions for CI/CD, Azure App Service

โš™๏ธ Running Locally To get this project running on your local machine, follow these steps:

Clone the repository:

git clone https://github.com/YOUR_USERNAME/YOUR_REPOSITORY.git

Navigate to the project directory:

cd your-repository-name

Install backend dependencies:

npm install

Set up your database:

Create an Azure SQL database.

Run the CREATE TABLE script found in the project to set up the Tasks table.

Configure Environment Variables:

Create a .env file in the root directory.

Add your database credentials to the .env file:

DB_USER=your_db_user DB_PASSWORD=your_db_password DB_SERVER=your_server.database.windows.net DB_DATABASE=your_db_name

Note: The deployed version reads these from Azure App Service settings.

Start the server:

node server.js

Open the application:

Open the public/index.html file in your web browser.

๐Ÿ‘จโ€๐Ÿ’ป Author Aryan Tripathi

๐ŸŒ Website: aryantripathi.me

๐Ÿ’ผ LinkedIn: linkedin.com/in/ary-tripathi

๐Ÿ“ง Email: aryktripathi@gmail.com

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published