A Blog full of Web Projects

11 projects tagged with "mysql"

  • Python and Django Starter Web App using MySQL

    08-May-2025

    Python Django and MySQL Basic Starter Web App hosted at Vercel Cloud implementing DevOps by GitHub + Vercel

    Try the demo...

    A Django Web App using MySQL for the Admin Backend ready for serving static files from Vercel

    CI / CD by VS Code + GitHub + Vercel Cloud - secured by HTTPS

    The source code at GitHub
  • Java Spring Boot REST API with Basic Auth

    02-March-2025

    Java Spring Boot 3 REST API doing Basic Auth with a Vue 3 Client

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

    Try the demo...

    The Web API at GitHub

    The Vue Client at GitHub

    Developed with Java 17 ! Showing the Users after a successful Logins by a Java Spring Boot 3 REST API doing Basic Auth and also JPA, Hibernate, Maven and MySQL with GET all Users functionality. Ready to be deployed to Azure App Service with Java 17 and Tomcat 10.1


  • Java Spring Boot REST API with JWT Auth

    21-February-2025

    Java Spring Boot 3 REST API doing JWT Auth with a Vue 3 Client

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

    Try the demo...

    The Web API at GitHub

    The Vue Client at GitHub

    Developed with Java 17 ! Showing the Users after a successful Logins by a Java Spring Boot 3 REST API using also JWT, JPA, Hibernate, Maven and MySQL with GET all Users functionality. Ready to be deployed to Azure App Service with Java 17 and Tomcat 10.1


  • Java Spring Boot MVC with Spring Security - Basic Starter

    13-February-2025

    Java Spring Boot 3 MVC and Spring Security - A Basic Starter with CRUD functionality

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

    Try the demo...

    The Source code at GitHub

    Take a look at the Basic Starter at GitHub with the same functionality but without Spring Security

    The Source code at GitHub

    Developed with Java 17 ! Showing and administrate a dataset of persons by a Java MVC Web Application (Secured by login) using also Spring Security, JSP, JPA, Hibernate, Maven and MySQL with CRUD functionality ready to be deployed to Azure App Service with Java 17 and Tomcat 10.1


  • Java Spring Boot MVC with Spring Security

    08-February-2025

    Java Spring Boot 3 MVC 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 1 minute. A 403 Status code may happen too!

    Try the demo...

    The Source code at GitHub

    The below code is an old version with semilar functionality by Spring Boot 2 using a MS SQL Database

    The source code at GitHub

    Migration from Java 11 to Java 17 ! Showing and administrate a dataset of persons by a Java MVC Web Application (Secured by login) using MVC, Security, JSP, JPA, Hibernate, Maven and MySQL


  • Java Spring Boot REST API + MVC using Spring Security

    07-February-2025

    Java Spring Boot 3 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 1 minute. A 403 Status code may happen too!

    Try the demo...

    The Source code at GitHub

    The below code is an old version with semilar functionality by Spring Boot 2

    The source code at GitHub

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


  • Java Spring Boot JAX-RS using REST API + MVC

    06-February-2025

    Java Spring Boot 3 JAX-RS Jersey REST API + MVC Application

    The source code at GitHub

    The below code is an old version with semilar functionality by Spring Boot 2

    The source code at GitHub

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


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

    10-January-2025

    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

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

    05-December-2024

    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

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

    02-December-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

    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

  • Java Spring Boot Jsf PrimeFaces MVC

    14-November-2021

    Java Spring Boot 2 JSF PrimeFaces MVC

    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