TASKS LIST APP

Installation guide

Clone the repository
Run from both directories npm install or yarn to install both app dependencies
Run from both directories npm start or yarn start to start both apps

Database setup

Create a database and change the database name in config/config.json file.
Change the database credentials in config/config.json and also in models files from models/* file with your own credentials.
Run npx sequelize-cli db:migrate to run the migrations.
Now you are ready to go.

Open `http://localhost:5000` in your browser to see the backend app running.

Packages used

express (Express used as a web framework)
mysql2 (MySQL used as a database)
sequelize (Sequelize used as an ORM)
sequelize-cli (Sequelize-cli used to run migrations)
cors (CORS used to enable cross-origin resource sharing)
connect-flash (Connect-flash used to flash messages)
express-session (Express-session used to manage sessions)
express-validator (Express-validator used to validate form data)
method-override (Method-override used to override HTTP methods)
EJS (EJS used as a templating engine)
nodemon (Nodemon used to restart the server on file changes)

Features

MVC architecture
ORM by using Sequelize
MySQL database
Models
Views
Controllers
Request validation / Requests
Routes
Session Flash Messages
Method Override
Migrations
View Engine / Templating Engine
Error Handling
404 Error Handling
500 Error Handling
etc & more

Backend API endpoints

GET /tasks - Get all tasks
POST /tasks - Create a new task
GET /tasks/:id - Get a task by id
GET /tasks/:id/edit - Get a task by id to edit
PUT /tasks/:id - Update a task by id
DELETE /tasks/:id - Delete a task by id

Note: The backend app is configured to use PORT 5000. Make sure that this port is not used by any other apps on your machine.

Note: The backend app is configured to use the MySQL database on port 3306. Make sure that this port is not used by any other apps on your machine.

Thanks for reading and happy coding!

mishajib/express-ejs-crud