Skip to content

A simple Tech Blog using the Model-View-Controller format. A MySQL database is used to store User data, as well as Posts and Comments on those Posts.

Notifications You must be signed in to change notification settings

cliff-rosenberg/14-MVC-Tech-Blog

Repository files navigation

14-MVC-Tech-Blog

Table of Contents-

Licensing

License

Link: MIT License

Description

A simple "Tech Blog" website using the Model-View-Controller format. A MySQL database is used to store User data, as well as Posts and Comments on those Posts. Database modelling is done through the Sequelize ORM for MySQL. The API ("Controller") functions are accessed using Express.js web application framework. The "View" functions are provided by Handlebars.js templating system.

Installation

NOTE: As of November 2022, Heroku has no "free" accounts, so the demo application has been taken offline until another suitable host can be found.

Can also be installed locally by copying directory structure as-is, then doing a npm install in the base directory to install necessary dependancies. Application database is MySql, and the database container can be created by navigating to the /db directory and then using the MySQL command line utility and the SOURCE command to create it. Data tables can be seeded into the container after this by navigating to the /seeds directory and using the command node seed.js to create them.

Screenshots

Base page

./assets/images/screenshot1.png

User login page

./assets/images/screenshot4.png

User now logged in

./assets/images/screenshot2.png

Add a comment to a post

./assets/images/screenshot3.png

User 'Dashboard' page

./assets/images/screenshot5.png

Editing a post

./assets/images/screenshot6.png

User sign-up page

./assets/images/screenshot7.png

Usage

To run when installed locally: The app server is launched by Node, type the command 'node server.js' to start the back-end. Then launch a web browser and go to the URL 'localhost:3001/' to get the inital page.

Credits

This application uses the following technologies/libraries:

Express.js v4.0

Sequelize v6

MySQL v8.0

dotenv

Contributing

Contributor Covenant

Testing

No testing is provided.

Additional Info

About

A simple Tech Blog using the Model-View-Controller format. A MySQL database is used to store User data, as well as Posts and Comments on those Posts.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published