An experimental e-commerce platform written in C# and TSQL. This project is for education purpose only as I intentionally shift as much logics to the database as possible.

Motivation

I am amazed by what SQL Server is capable of, so I decide to try out to write as much logics as possible directly in the SQL Server.

Asides, it is also an opportunity for me to learn SQL Server in depth for topics such as joins, common table expressions, stored procedure, table hints, concurrency and performance optimizations.

Tech

The technologies and tools used within this project.

• C#
• T-SQL/SQL Server
• ASP.NET Core MVC
• TailwindCSS/DaisyUI
• jQuery
• Azure Pipelines CI

Features

• Regular CRUD operations for entities
• MVC Portal

Design

The architecture currently is very simple. It is just a MVC app calling to the SQL Server database to manage the data. The coding principle here is, shift as much logic to the database using stored procedure, views, triggers, functions, and other SQL Server offerings.

Learnings

Having strict data integrity is good, but it restricts us from catering other feature that needed some leeway. I learned a lot about SQL Server and SQL in general along the way. I also wrote a Data generator with Bogus to seed the database or output as SQL script.

Future Development

Here are a few features that I think will be incredible to implement

• REST API server
• Add SvelteKit frontend for SPA experience
• Add OAuth/OIDC authentication
• Use Grafana for telemetry tracking
• Use Grafana Loki for log sinks
• Integrate with RabbitMQ for asynchronous processing
• GraphQL server to save bandwidth
• Use Table Hint for optimizing locks