Introduction

Built first full stack application using CRUD operations connected to a MySQL database.

Actions

• 🔹 Step 1: Created an app in Vscode using Node.JS and My SQL to create a database that stores the posts, categories and registered users.
• 🔹 Step 2: Create a register and log in and test the autheication. Additional filter the articles and posts by categories.
• 🔹 Step 3: Add a create, update, delete option for users create and remove posts.
• 🔹 Step 4: Check API calls from web page works before pushing it live server for the app and backend.

Result

Below is the result.

Live demo

GitHub Repository

• 📝 Summary of Key Findings:

  • Discovering key finding of using CRUD Operations in the back end using Sequlize & SQL.

  • How to connect to Front end using Node.JS / Express with a MySQL Database.

  • Deploying a full stack application to Render and how to search for platform to host the database.

Future Considerations

• 💡 Potential improvements:

  1. Add implemenation to arrange the post in order by time it was posted.

  2. Add a feature that tells you the name of the user that posted the post, rather then using the default name user.

  3. Make the application look visually more appealing.