A Blog full of Web Projects

15 projects tagged with "sqlite"

  • 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
  • .NET 10 REST API doing Authentication by JWT and Refresh Tokens

    19-August-2026

    Vue 3 client towards a REST API by .NET 10 with C# using JWT and Refresh Tokens for Authentication

    Traditional webhosting is used for this Application

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Functionality of the Web App

    • JWT authentication with Refresh Tokens
    • Refresh token rotation
    • Revoked token reuse detection

    Tech used for building the Web App

    • C#
    • The .NET 10 Web API is hosted at a traditional Webhotel
    • The Vue 3 Client is hosted at a traditional Webhotel
    • SQLite as the Database for both Dev + Prod
    • CORS Policy implemented by .NET
    • JWT Token for access secure routes
    • Refresh Token by HTTP only Cookie to generate new JWT Tokens

    By using JWT + Refresh Tokens the security will be improved. The JWT can have a reduced time to live and therefor less likely to be stolen


  • .NET 10 REST API with Dapper SQLite and xUnit

    09-June-2026

    .NET 10 REST API with C# and Dapper ORM + SQLite DB consuming a React 16 Client + Unit Testing

    Unit Testing:

    • xUnit - Used with one of the .NET Web API

    Coverage Reports are generated for visualize the result of Unit Testing ( .NET based xUnit )

    Try the demo...

    Dapper is a lightweight Micro-ORM which can be an alternative to Entity Framework Core ORM

    SQLite is local DB and fine for testing and small applications

    Traditional webhosting is used for this Application


  • .NET 10 and ASP.NET Core Identity MVC Web Application

    03-June-2026

    ASP.NET Core Identity MVC Web App serving as a Membership System using .NET 10 - A Starter

    Traditional webhosting is used for this Application

    An ASP.NET Core Identity MVC Web Application with Individual Accounts created by VS Code using .NET 10 serving as a Membership System towards a SQLite Database

    Below is a .NET 8 version of the Web App


  • .NET 10 and Umbraco 17 CMS based Website serving a Membership System

    23-November-2025

    A Website by Umbraco 17 CMS and .NET 10 with Member Registration + Confirmation + Login + Forgot Password + Manage Profile using SQLite DB for both Dev + Prod serving as a Starter

    The Website was upgraded from Umbraco 13 and .NET 8 which described in the Readme

    Try the demo...

    This Website was created by Umbraco 17 CMS and .NET with Member Registration + Confirmation + Login + Forgot Password + Edit and Delete own Profile and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub
  • .NET 10 and Umbraco 17 CMS based Website using custom MVC

    22-November-2025

    A Website by Umbraco 17 CMS and .NET 10 using SQLite DB for both Dev + Prod with MVC towards a custom Table in the DB serving as a Starter

    The Website was upgraded from Umbraco 13 and .NET 8 which described in the Readme

    Try the demo...

    This Website was created by Umbraco 17 CMS and .NET 10 and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub

    The Website implements CRUD functionality by administrating Employees towards a custom Table in the SQLite DB using MVC and Entity Framework Core


  • .NET 8 and Umbraco 13 CMS based Website

    21-November-2025

    A Website by Umbraco 13 CMS and .NET 8 using SQLite DB for both Dev + Prod serving as a Starter

    Try the demo...

    This Website was created by Umbraco 13 CMS and .NET and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub
  • .NET 8 and Umbraco 13 CMS based Website using custom MVC

    21-November-2025

    A Website by Umbraco 13 CMS and .NET 8 using SQLite DB for both Dev + Prod with MVC towards a custom Table in the DB serving as a Starter

    Try the demo...

    This Website was created by Umbraco 13 CMS and .NET 8 and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub

    The Website implements CRUD functionality by administrating Employees towards a custom Table in the SQLite DB using MVC and Entity Framework Core


  • .NET 8 and Umbraco 13 CMS based Website serving a Membership System

    21-November-2025

    A Website by Umbraco 13 CMS and .NET 8 with Member Registration + Confirmation + Login + Forgot Password + Manage Profile using SQLite DB for both Dev + Prod serving as a Starter

    Try the demo...

    This Website was created by Umbraco 13 CMS and .NET with Member Registration + Confirmation + Login + Forgot Password + Edit and Delete own Profile and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub
  • .NET 10 and Umbraco 17 CMS based Website

    17-November-2025

    A Website by Umbraco 17 CMS and .NET 10 using SQLite DB for both Dev + Prod serving as a Starter

    The Website was upgraded from Umbraco 13 and .NET 8 which described in the Readme

    Try the demo...

    This Website was created by Umbraco 17 CMS and .NET 10 and hosted at a tradiotional Web Hotel using IIS

    The source code at GitHub
  • .NET 8 REST API doing Authentication by JWT and Refresh Tokens

    02-September-2025

    Angular client towards a REST API by .NET 8 with C# using JWT and Refresh Tokens for Authentication

    Traditional webhosting is used for this Application

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Functionality of the Web App

    • JWT authentication with Refresh Tokens
    • Refresh token rotation
    • Revoked token reuse detection

    Tech used for building the Web App

    • C#
    • The .NET 8 Web API is hosted at a traditional Webhotel
    • The Angular Client is hosted at a traditional Webhotel
    • SQLite as the Database for both Dev + Prod
    • CORS Policy implemented by .NET
    • JWT Token for access secure routes
    • Refresh Token by HTTP only Cookie to generate new JWT Tokens

    By using JWT + Refresh Tokens the security will be improved. The JWT can have a reduced time to live and therefor less likely to be stolen


  • .NET 8 REST API with Dapper SQLite and xUnit

    11-November-2024

    .NET 8 REST API with C# and Dapper ORM + SQLite DB consuming an Angular 14 Client + Unit Testing

    Unit Testing:

    • xUnit - Used with one of the .NET Web API
    • Karma + Jasmine - Used with the Angular Client

    Coverage Reports are generated for visualize the result of Unit Testing ( .NET based xUnit )

    Try the demo...

    Dapper is a lightweight Micro-ORM which can be an alternative to Entity Framework Core ORM

    SQLite is local DB and fine for testing and small applications

    Traditional webhosting is used for this Application


  • .NET 8 REST API Membership system + Email verification

    13-October-2024

    .NET 8 REST API with C# using Entity Framework Core + SQLite consuming an Angular 14 Client - serving as a Membership System

    Unit Testing:

    • Karma + Jasmine - Used with the Angular Client

    Try the demo...

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    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

    • C#
    • The .NET 8 Web API is hosted at a traditional Webhotel
    • The Angular Client is hosted at a traditional Webhotel
    • SQLite as the Database for both Dev + Prod
    • CORS Policy implemented by .NET
    • JWT Token for access secure routes
    • Refresh Token by HTTP only Cookie to generate new JWT Tokens
    • Swagger API documentation with routes

  • .NET 6 REST API Membership system using MSSQL

    15-March-2024

    .NET 6 REST API with C# using Entity Framework Core + Remote MSSQL for Prod + local SQLite DB for Dev consumed by a Blazor Client serving as a Membership System

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Try the demo...

    - C#
    - Registration of Users
    - JWT authentication
    - CRUD Account management

    MSSQL Server is fine for Production

    SQLite is local DB and fine for testing locally and small applications

    Traditional webhosting is used for this Application


  • .NET 6 REST API Membership system - SQLite

    12-March-2024

    .NET 6 REST API with C# using Entity Framework Core + SQLite DB consumed by a Blazor Client serving as a Membership System

    The Web API was made without the ASP.NET Core Identity using custom JWT middleware

    Try the demo...

    - C#
    - Registration of Users
    - JWT authentication
    - CRUD Account management

    SQLite is local DB and fine for testing and small applications

    Traditional webhosting is used for this Application


Software Developer - Per Olsen - Denmark