13 projects tagged with "mysql"
- Python and Django Website using MySQL hosted at PythonAnywhere serving a Blog
19-August-2026Python 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 - Python and Django Starter Website using MySQL hosted at Vercel Cloud serving a Blog Employees and Todos
28-July-2026Python 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 - Node Express REST API Membership system + Email notification - JWT
16-March-2026Node 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 JWT Auth
16-March-2026Java 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 GitHubDeveloped 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 REST API with Basic Auth
09-February-2026Java 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 GitHubDeveloped 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-2026Java 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 GitHubTake a look at the Basic Starter at GitHub with the same functionality but without Spring Security
The Source code at GitHubDeveloped 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-2025Python 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 - Java Spring Boot MVC with Spring Security
08-February-2025Java 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!
The Source code at GitHubThe below code is an old version with semilar functionality by Spring Boot 2 using a MS SQL Database
The source code at GitHubMigration 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-2025Java 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!
The Source code at GitHubThe below code is an old version with semilar functionality by Spring Boot 2
The source code at GitHubMigration 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-2025Java Spring Boot 3 JAX-RS Jersey REST API + MVC Application
The source code at GitHubThe below code is an old version with semilar functionality by Spring Boot 2
The source code at GitHubMigration 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
05-December-2024Node 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-2024Node 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-2021Java Spring Boot 2 JSF PrimeFaces MVC
The source code at GitHubMigration 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