Blog application api in Node.js express.js sequelize ORM and MYSQL Database

Related tags

Learning resource Blog-app-api
Overview

Node Express Mysql Sequelise Blog System Api

Node api with express mysql sequelise

Usage

To get started with this api follow the steps below

$ git clone https://github.com/Livingston-k/Blog-app-api
$ cd Blog-app-api
$ yarn install

DATABASE SETUP

  • Note that is project is using mysql database.
    • create a database forexample blog_system
    • In the project directory go to config/config.json and edit the database configurations to match your setup
    • To migrate the database tables run : 
      npx sequelize-cli db:migrate

START THE SERVER

$ yarn start

ENVIRONMENT VARIABLES

  • In the project main directory ceate a file name .env and put the following
JWT_SECRETE = "put any string here to act as your jwt secret"

API DOCUMENTATION

View api documentation

Follow Me

Comments
  • [Snyk] Upgrade fastest-validator from 1.12.0 to 1.13.0

    [Snyk] Upgrade fastest-validator from 1.12.0 to 1.13.0

    Snyk has created this PR to upgrade fastest-validator from 1.12.0 to 1.13.0.

    :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

    • The recommended version is 1 version ahead of your current version.
    • The recommended version was released 21 days ago, on 2022-08-15.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

    For more information:

    🧐 View latest project report

    🛠 Adjust upgrade PR settings

    🔕 Ignore this dependency or unsubscribe from future upgrade PRs

    opened by snyk-bot 0
  • [Snyk] Security upgrade jsonwebtoken from 8.5.1 to 9.0.0

    [Snyk] Security upgrade jsonwebtoken from 8.5.1 to 9.0.0

    This PR was automatically created by Snyk using the credentials of a real user.


    Snyk has created this PR to fix one or more vulnerable packages in the `yarn` dependencies of this project.

    Changes included in this PR

    • Changes to the following files to upgrade the vulnerable dependencies to a fixed version:
      • package.json
      • yarn.lock

    Vulnerabilities that will be fixed

    With an upgrade:

    Severity | Priority Score (*) | Issue | Breaking Change | Exploit Maturity :-------------------------:|-------------------------|:-------------------------|:-------------------------|:------------------------- high severity | 671/1000
    Why? Recently disclosed, Has a fix available, CVSS 7.7 | Improper Input Validation
    SNYK-JS-JSONWEBTOKEN-3180020 | Yes | No Known Exploit medium severity | 611/1000
    Why? Recently disclosed, Has a fix available, CVSS 6.5 | Improper Authentication
    SNYK-JS-JSONWEBTOKEN-3180022 | Yes | No Known Exploit medium severity | 611/1000
    Why? Recently disclosed, Has a fix available, CVSS 6.5 | Improper Restriction of Security Token Assignment
    SNYK-JS-JSONWEBTOKEN-3180024 | Yes | No Known Exploit medium severity | 526/1000
    Why? Recently disclosed, Has a fix available, CVSS 4.8 | Use of a Broken or Risky Cryptographic Algorithm
    SNYK-JS-JSONWEBTOKEN-3180026 | Yes | No Known Exploit

    (*) Note that the real score may have changed since the PR was raised.

    Check the changes in this PR to ensure they won't cause issues with your project.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open fix PRs.

    For more information: 🧐 View latest project report

    🛠 Adjust project settings

    📚 Read more about Snyk's upgrade and patch logic

    Learn how to fix vulnerabilities with free interactive lessons:

    🦉 Use of a Broken or Risky Cryptographic Algorithm

    opened by Livingston-k 0
  • [Snyk] Upgrade express from 4.18.1 to 4.18.2

    [Snyk] Upgrade express from 4.18.1 to 4.18.2

    This PR was automatically created by Snyk using the credentials of a real user.


    Snyk has created this PR to upgrade express from 4.18.1 to 4.18.2.

    :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

    • The recommended version is 1 version ahead of your current version.
    • The recommended version was released 21 days ago, on 2022-10-08.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

    For more information:

    🧐 View latest project report

    🛠 Adjust upgrade PR settings

    🔕 Ignore this dependency or unsubscribe from future upgrade PRs

    opened by Livingston-k 0
  • [Snyk] Upgrade nodemon from 2.0.19 to 2.0.20

    [Snyk] Upgrade nodemon from 2.0.19 to 2.0.20

    This PR was automatically created by Snyk using the credentials of a real user.


    Snyk has created this PR to upgrade nodemon from 2.0.19 to 2.0.20.

    merge advice :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

    • The recommended version is 1 version ahead of your current version.
    • The recommended version was released 22 days ago, on 2022-09-16.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

    For more information:

    🧐 View latest project report

    🛠 Adjust upgrade PR settings

    🔕 Ignore this dependency or unsubscribe from future upgrade PRs

    opened by Livingston-k 0
  • [Snyk] Upgrade dotenv from 16.0.1 to 16.0.2

    [Snyk] Upgrade dotenv from 16.0.1 to 16.0.2

    Snyk has created this PR to upgrade dotenv from 16.0.1 to 16.0.2.

    merge advice :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

    • The recommended version is 1 version ahead of your current version.
    • The recommended version was released 21 days ago, on 2022-08-30.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

    For more information:

    🧐 View latest project report

    🛠 Adjust upgrade PR settings

    🔕 Ignore this dependency or unsubscribe from future upgrade PRs

    opened by snyk-bot 0
  • [Snyk] Upgrade sequelize from 6.21.3 to 6.21.4

    [Snyk] Upgrade sequelize from 6.21.3 to 6.21.4

    This PR was automatically created by Snyk using the credentials of a real user.


    Snyk has created this PR to upgrade sequelize from 6.21.3 to 6.21.4.

    :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

    • The recommended version is 1 version ahead of your current version.
    • The recommended version was released 22 days ago, on 2022-08-18.

    Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

    For more information:

    🧐 View latest project report

    🛠 Adjust upgrade PR settings

    🔕 Ignore this dependency or unsubscribe from future upgrade PRs

    opened by Livingston-k 0
Owner
Kaddu Livingstone
I.T Software Developer. The true lover of Javascript and Typescript (Node.js, Vue.js, React Native)
Kaddu Livingstone
GitHub
A CRUD implementation using sequelize, mySQL, NODEJS, Express, JWT and other technologies.

A ideia do projeto é simular o funcionamento do backend de um blog através da implementação de uma aplicação em Node.js usando o pacote sequelize para

Vinicius Savordelli 6 May 11, 2022
CRUD de productos basado en el ORM sequelize y el login y el registro usando archivo en formato JSON.

Desarrollo de una aplicación muy sencilla, utilizando diferentes recursos ofrecdos por Node.JS. Aquí puedes encontrar : Login - Registro - Administración de productos completamente funcionales) Recursos utilizados: Middleware - Express validator - Validaciones del lado del Front-End - y del Back-End - Sessión - Cookies - Multer, entre otros)

Ángel Daniel Fuentes Segura 4 Sep 12, 2022
Nestjs, Sequelize, Mysql Boilerplate

Nestjs - Sequelize - Mysql Boilerplate Description NestJS framework TypeScript starter repository or boilerplate with jwt user authentication. Feature

Hossain Azad 8 Aug 27, 2022
simple-remix-blog is a blog template built using Remix and TailwindCSS. Create your own blog in just a few minutes!

simple-remix-blog is a blog template built using remix.run and TailwindCSS. It supports markdown and MDX for the blog posts. You can clone it and star

José Miguel Álvarez Vañó 8 Dec 8, 2022
Simple WhatsApp Gateway, Built Using Baileys, Express, Sequelize, and Mazer

WhatsApp - Gateway Simple WhatsApp Gateway, Built Using Baileys, Express, Sequelize + Mazer Installation Requirements Node.js Git VS Code or Any Text

Zekais 40 Dec 30, 2022
A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud

A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud.

ʀᴀʏ 5 Dec 15, 2022
A Restaurant (Table) Reservation API built with Node, TypeScript, Express, TypeORM, a MySQL DB, all running on Docker containers

Restaurant (Table) Reservation API A simple API for reserving tables at a restaurant. The API is based on the REST architectural style and uses Node.j

null 14 Oct 5, 2022
A Restaurant (Table) Reservation API built with Node, TypeScript, Express, TypeORM, a MySQL DB, all running on Docker containers

Restaurant (Table) Reservation API A simple API for reserving tables at a restaurant. The API is based on the REST architectural style and uses Node.j

null 14 Oct 5, 2022
This is another Express + TypeScript + DDD (Domain Driven Design patterns) + IoC/DI (Inversion of control and Dependency injection) + Primsa ORM + API REST boilerplate.

Express-TS-DDD REST API This is another Express + TypeScript + DDD (Domain Driven Design patterns) + IoC/DI (Inversion of control and Dependency injec

J.D. 6 Nov 3, 2022
practice site to utilize node.js, Express, and mySQL

fishing_site practice site to utilize node.js, Express, and mySQL Run Locally create local instance of MySQL database. Run DB/fishing_Schema.sql to cr

Ryan Graue 1 Jan 22, 2022
Simple REST API using Express with TypeScript, PostgreSQL, and MySQL to practice the Clean Architecture by Uncle Bob.

Clean-Architecture Simple REST API using Express with TypeScript, PostgreSQL, and MySQL to practice the Clean Architecture by Uncle Bob. About This RE

Abdullah Adel 10 Oct 16, 2022
Node.js Express + MySQL vulnerable boilerplate project

Node.js Express + MySQL vulnerable boilerplate project

null 13 Sep 16, 2022
CRUD APIs in NodeJS, Express and MySQL

Create CRUD APIs in NodeJS, Express and MySQL This is a simple NodeJS, Express and MySQL CRUD API example. that allows you to create, read, update and

Hala Ziani 5 Oct 19, 2022
Public project to perform migrations on mysql database.

node-mysql-migrate Public project to perform migrations on mysql database. How to run First step, install the dependency for your project. To make it,

Tiago Murilo 5 Aug 16, 2022
A dockerized express mysql starter using typescript which iclude user management

A dockerized express mysql starter using typescript which iclude user management

Nimatullah Razmjo 2 Jan 26, 2022
Gatsby-blog-cosmicjs - 🚀⚡️ Blazing fast blog built with Gatsby and the Cosmic Headless CMS 🔥

Gatsby + Cosmic This repo contains an example blog website that is built with Gatsby, and Cosmic. See live demo hosted on Netlify Uses the Cosmic Gats

Priya Chakraborty 0 Jan 29, 2022
This is a blog built with sveltekit, tailwind and daisyUI, made to be used as my personal blog.

svelte-blogger This is a blog built with sveltekit, tailwind and daisyUI, made to be used as my personal blog. This app also use graphql and use markd

lipe 6 Jun 23, 2022
Mongoose Node.js Express TypeScript application boilerplate with best practices for API development.

Node TypeScript Boilerplate Mongoose The main purpose of this repository is to show a good end-to-end project setup and workflow for writing a Mongoos

Chirag Mehta 20 Dec 13, 2022
Application template for NestJS + Docker + Prisma + MySQL

nestjs-docker-prisma-mysql Application template for NestJS + Docker + Prisma + MySQL Setup # install $ yarn # Setup env file for database $ cp .env.e

fsubal 6 Oct 15, 2022