Besides working on my Lego projects, I am a software engineer and I build and maintain web-based database software applications. CustomersDB is my pet project I have been working on for several years now. It is a web-based application that help small businesses manage their day-to-day operations. CustomersDB is a suite of applications including the POS (Point-Of-Sales), Admin Portal, and an online Store. CustomersDB is a cloud based application using Microsoft Azure.
Version 1 of the software was started back in 2018 built using ASP.NET MVC and a backend SQL Server database. It uses the Microsoft .NET 4 framework and jQuery for the UI.
Version 2 of the software was done a couple of years later back in 2020 using .NET Core and Blazor for the UI. The application was separated out to use a web layer and a business layer using WebAP and Azure Functions. It is the current version in use today.
I am currently working on version 3 of the software. It will still uses Blazor WebAssembly as the UI but from .NET 5 to .NET 7. The authentication module will be upgraded from ID4 to Entra (Azure Active Directory). The middleware will still use WebAPI, Entity Framework, and Azure Functions but will also be upgraded to .NET 7. The goal is to upgrade the entire CustomersDB application to .NET 7 and lay the foundation work for iPad iOS development. The backend database will still be Azure SQL Server.
In the future, I hope to add an iPad POS mobile application and turn this into a business.
CustomersDB POS (pos.customersdb.com)
CustomersDB Portal (portal.customersdb.com)
CustomersDB Store (store.customersdb.com)