{ZB}Ziyad Alboghdady

Case studies

Six systems, strongest first. Every one lists the decisions I made and what they cost.

Task Management API

.NET 9 · PostgreSQL 16 · Docker Compose · Supabase Auth · Hangfire

A containerised REST API where cross-user access is structurally impossible, slow work runs in the background, and the AI endpoint is tested for being right, not only well-formed.

  • .NET 9 Web API
  • C#
  • EF Core
  • PostgreSQL 16
  • Docker Compose
  • Supabase Auth
  • Hangfire
  • OpenRouter LLM

Read the decisions →

Car Rental Management System

ASP.NET Core MVC · EF Core · PostgreSQL · triggers & stored functions

Seven modules over one relational core, with the rules that matter — above all, no car booked twice for the same dates — enforced by the database itself rather than trusted to the UI.

  • ASP.NET Core MVC
  • C#
  • EF Core
  • PostgreSQL
  • ASP.NET Core Identity
  • PL/pgSQL triggers & functions

Read the decisions →

Campusly In progress

ASP.NET Core 8 Web API · PostgreSQL · EF Core · JWT · team of eight

A campus platform — map, maintenance reporting with duplicate detection, events and transport — built by eight people to a fixed demo date. I manage the project and work in the backend team.

  • ASP.NET Core 8 Web API
  • PostgreSQL
  • EF Core
  • ASP.NET Identity + JWT
  • OpenAPI
  • React + Vite (frontend team)

Read the decisions →

Cached Personnel System with Local LLM In progress

Spring Boot · Redis · MySQL · Hadoop HDFS · Ollama

Personnel data served through a Redis cache that flushes to MySQL, employee photos in Hadoop HDFS, and a chat page backed by a language model running on the same machine.

  • Spring Boot
  • Java
  • Redis
  • MySQL
  • Hadoop HDFS
  • Ollama (Llama 3.2)

Read the decisions →

University Management System

ASP.NET Core MVC + Web API · EF Core · PostgreSQL

One domain served two ways — Razor views for staff and a REST endpoint for other systems — without duplicating the data layer.

  • ASP.NET Core MVC
  • Web API
  • EF Core
  • PostgreSQL
  • ASP.NET Identity
  • Repository pattern
  • DTOs

Read the decisions →

Live Data Visualisation with R on the JVM

Spring Boot · MongoDB · R on GraalVM

A Spring Boot service that reads one MongoDB record per second and has R — running inside the same JVM on GraalVM — draw a live chart of the last 100 values.

  • Spring Boot
  • Java 17
  • MongoDB
  • R (lattice)
  • GraalVM FastR

Read the decisions →

Looking for the research? The machine-learning work is on the Research page.