A Blog full of Web Projects

6 projects categorized with "MySQL"

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

    17-August-2024

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

    Note: Due to the resource limitations of the Microsoft Azure Free App Service Plan, the initial load time will be up to 30 seconds!

    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 REST API Membership system + Email notification - JWT

    13-February-2024

    Node Express REST API 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 using REST API + MVC

    04-October-2023

    Java Spring Boot JAX-RS Jersey REST API + MVC 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 API + MVC Web Application using Jersey REST 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 REST API + MVC using Spring Security

    03-October-2023

    Java Spring Boot REST API + MVC using 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 + MVC Web Application (Secured by login) using REST API, MVC, Security, JSP, JPA, Hibernate, Maven, MySQL and jQuery for the frontend.


  • Node Express REST API Membership system + Email notification - JWT

    30-May-2023

    Node Express REST API 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

    14-November-2021

    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