A Blog full of Web Projects

8 projects categorized with "MySQL"

  • Java Spring Boot REST API with JWT Auth

    25-August-2026

    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 503 Status code may happen too!

    The Vue 3 client is using Vite as Build Tool

    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


  • Python and Django Starter Website using MySQL hosted at Vercel Cloud serving a Blog Employees and Todos

    25-August-2026

    Python Django and MySQL Starter Website serving a simple Blog Employees and Todos hosted at Vercel Cloud using Serverless Functions implementing DevOps by GitHub + Vercel

    Try the demo...

    Django is using the architectural pattern Model-View-Template (MVT) which is a derivation of the pattern Model View Control (MVC)

    This Django Website is serving static content - secured by HTTPS

    A simple Blog, a list of Employees and Todos demonstrates how to use Models (CRUD) by the Django Admin and display the Posts, Employees and Todos by the Frontend

    The Employees and Todos are also administrated by the Frontend with CRUD functionality

    The files models.py, views.py and forms.py are splitted up for showing how to scale the folder structure if the Django Website should grow with a lot of views and models

    Customized some of the Templates of the Django Admin Backend which display the Header and Menu

    CI / CD by VS Code + GitHub + Vercel Cloud

    The source code at GitHub
  • Python and Django Website using MySQL hosted at PythonAnywhere serving a Blog

    25-August-2026

    Python Django MySQL and SQLite Website serving a simple Blog hosted at PythonAnywhere which have a free plan as well as plans for scaling up if needed. The hosting is fast and user friendly with good documentation

    Try the demo...

    Django is using the architectural pattern Model-View-Template (MVT) which is a derivation of the pattern Model View Control (MVC)

    This Django Website is serving static content - secured by HTTPS

    A simple Blog demonstrates how to use Models by the Django Admin and display the Posts by the Frontend

    The files models.py and views.py are splitted up for showing how to scale the folder structure if the Django Website should grow with a lot of views and models

    FTP upload was used for deployment but initially the GitHub repo could be cloned to PythonAnywhere

    The source code at GitHub
  • Node Express REST API Membership system + Email notification - JWT

    16-March-2026

    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 REST API with Basic Auth

    09-February-2026

    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 503 Status code may happen too!

    The Vue 3 client is using Vite as Build Tool

    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 MVC with Spring Security serving a Starter

    05-January-2026

    Java Spring Boot 3 MVC and Spring Security serving 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 503 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


  • Python and Django Starter Website using MySQL hosted at Vercel Cloud serving a Membership System

    03-December-2025

    Python Django MySQL Starter Website serving a Membership System hosted at Vercel Cloud using Serverless Functions implementing DevOps by GitHub + Vercel

    Try the demo...

    Django is using the architectural pattern Model-View-Template (MVT) which is a derivation of the pattern Model View Control (MVC)

    This Django Website is serving static content - secured by HTTPS

    A simple Blog demonstrates how to use Models (CRUD) by the Django Admin and display the Posts by the Frontend

    A Membership System was implemented by django-allauth serving Signup with Email Verification, Login, and Reset Password (when not logged in). Logout, Change Password, Manage Email, Deactivate and Delete Account (when logged in)

    CI / CD by VS Code + GitHub + Vercel Cloud

    The source code at GitHub
  • 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

Software Developer - Per Olsen - Denmark