A Blog full of Web Projects

6 projects tagged with "mysql"

  • Node Express Membership system + Email notification - JWT and Refresh Token

    10-May-2024

    Node Express Role based Membership system with Email Verification and Forgot Password using Sequelize ORM towards a MySQL DB - Authentication by JWT + Refresh Tokens

    Volta was used for Node Version Management switching between Node versions

    Functionality of the Web App

    • JWT authentication with Refresh Tokens
    • Refresh token rotation
    • Revoked token reuse detection
    • Email sign up and verification
    • Forgot password and reset password functionality
    • Role based authorization with two roles "User" and "Admin"
    • CRUD Account management routes with role based access control

    Tech used for building the Web App

    • Node.js
    • Sequelize used to implement the ORM at the Web API
    • The Node.js Web API is hosted at Azure App Service with the Free App Service Plan
    • The React Client is hosted at a traditional Webhotel
    • MySQL as the Database for both Dev + Prod
    • CORS Policy implemented by Node.js and at Azure
    • JWT Token for access secure routes
    • Refresh Token by HTTP only Cookie to generate new JWT Tokens

  • Node Express Membership system + Email notification - JWT

    13-February-2024

    Node Express Role based Membership system with Email Verification and Forgot Password using Sequelize ORM towards a MySQL DB - Authentication by JWT

    Volta was used for Node Version Management switching between Node versions

    Functionality of the Web App

    • JWT authentication
    • Email sign up and verification
    • Forgot password and reset password functionality
    • Role based authorization with two roles "User" and "Admin"
    • CRUD Account management routes with role based access control

    Tech used for building the Web App

    • Node.js
    • Sequelize used to implement the ORM at the Web API
    • The Node.js Web API is hosted at Azure App Service with the Free App Service Plan
    • One React client at GH Pages which uses DevOps. The React HashRouter solves most 404 / Browser refresh issues at GH Pages
    • One React Client is hosted at a traditional Webhotel
    • The React TypeScript Client is hosted at a traditional Webhotel
    • MySQL as the Database for both Dev + Prod
    • CORS Policy implemented by Node.js and at Azure
    • JWT Token for access secure routes

  • Java Spring Boot JAX-RS Jersey RESTful Web API

    04-October-2023

    Java Spring Boot JAX-RS Jersey RESTful Web API Application

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 2 minutes. A 403 Status code may happen too!

    Try the demo...

    The source code at GitHub

    Migration from Java 8 to Java 11 ! Showing and administrate a dataset of persons by a Java Jersey REST and MVC Web Application using Jersey RESTful Web API, MVC, JSP, JAX-RS, JPA, Hibernate, Maven and MySQL. React, Fetch API (Not working in IE), AngularJS and jQuery for the frontend client


  • Java Spring Boot Restful Web APi Spring Security

    03-October-2023

    Java Spring Boot RESTful Web API and Spring Security

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 2 minutes. A 403 Status code may happen too!

    Try the demo...

    The source code at GitHub

    Migration from Java 8 to Java 11 ! Showing and administrate a dataset of persons by a Java REST API and MVC Web Application (Secured by login) using RESTful Web API, MVC, Security, JSP, JPA, Hibernate, Maven, MySQL and jQuery for the frontend.


  • Node Express Membership system + Email notification - JWT

    30-May-2023

    Node Express Role based Membership system with Email Verification and Forgot Password using pure SQL towards a MySQL DB - Authentication by JWT

    Try the demo...

    The Node.js Web API was made without any ORM framework like Sequelize

    Functionality of the Web App

    • JWT authentication
    • Email sign up and verification
    • Forgot password and reset password functionality
    • Role based authorization with two roles "User" and "Admin"
    • CRUD Account management routes with role based access control

    Tech used for building the Web App

    • Node.js
    • Pure SQL instead of using ORM like Sequelize
    • The Node.js Web API is hosted at Azure App Service with the Free App Service Plan
    • The React Client is hosted at a traditional Webhotel
    • MySQL as the Database for both Dev + Prod
    • CORS Policy implemented by Node.js and at Azure
    • JWT Token for access secure routes

  • Java Spring Boot Jsf PrimeFaces Mvc

    11-February-2020

    Java Spring Boot JSF PrimeFaces MVC

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 2 minutes. A 403 Status code may happen too!

    Try the demo...

    The source code at GitHub

    Migration from Java 8 to Java 11 ! Administrate a dataset of persons by a Java JSF and PrimeFaces Web Application using JSF, PrimeFaces, MVC, JPA, Hibernate, Maven and MySQL


A Blog made with Gatsby React and GraphQL