t4ngo@workstation:~/repos $ ls -la ./projects

// REPO INDEX

Projects

Public repositories from GHT4ngo, grouped by project type. Live links are included when the project has one.

Data engineering

./GHT4ngo/myh-data-pipeline

myh-data-pipeline

LIVE

Pipeline harmonizing Swedish MYH vocational education data into PostgreSQL, FastAPI, an ML approval predictor, and a React dashboard.

  • HTML
  • PostgreSQL
  • FastAPI
  • React
  • ML
./GHT4ngo/fab

fab

LIVE

Flesh and Blood TCG card-data app: ingest to PostgreSQL bronze/silver/gold layers, then expose data through FastAPI.

  • Python
  • PostgreSQL
  • FastAPI
  • Data pipeline
./GHT4ngo/Dimensional-Modeling

Dimensional-Modeling

LIVE

Database design and modeling assignment for a data warehouse schema.

  • T-SQL
  • Data warehouse
  • Dimensional modeling

AI and automation

./GHT4ngo/LiaBot

LiaBot

LIVE

Automated LIA search using JobTech API, Swedish career sites, local AI analysis, and a dashboard UI.

  • Python
  • FastAPI
  • PostgreSQL
  • React
  • Ollama
./GHT4ngo/nexus-personal-assistant

nexus-personal-assistant

WIP

Personal assistant concept for pooling daily information, sorting it, and presenting it clearly.

  • Assistant
  • Automation
  • Product concept
./GHT4ngo/BreakPointBot

BreakPointBot

LIVE

Discord bot for break tracking and lunch menu updates.

  • Python
  • Discord
  • Automation

Card and game tools

./GHT4ngo/MTG-Store-Proof-of-Concept

MTG-Store-Proof-of-Concept

LIVE

Full-stack MTG retail platform concept with automated pricing, AI search, trade-in workflow, and decklist tools.

  • Full stack
  • Pricing
  • AI search
  • Retail
./GHT4ngo/FAB-Price-and-Trading-app

FAB-Price-and-Trading-app

LIVE

Application concept for checking Flesh and Blood card prices and making trades easier.

  • Cards
  • Pricing
  • dbt
  • Lovable

SQL assignments

./GHT4ngo/SQL_Assignment_1

SQL_Assignment_1

LIVE

T-SQL assignment for checking whether a Swedish personal identity number is valid.

  • T-SQL
  • Validation
  • Luhn
./GHT4ngo/SQL_Assignment_2

SQL_Assignment_2

LIVE

SQL script for ETL using Slowly Changing Dimension Type 2.

  • T-SQL
  • ETL
  • SCD2
./GHT4ngo/SQL_Assignment_3

SQL_Assignment_3

LIVE

SQL code for scanning user tables and performing index maintenance with a cursor.

  • T-SQL
  • Index maintenance
  • Database operations
./GHT4ngo/SQL_Assignment_4

SQL_Assignment_4

LIVE

SQL assignment focused on query performance analysis.

  • T-SQL
  • Performance
  • Query analysis

Utilities

./GHT4ngo/ai-token-tracker

ai-token-tracker

BETA

Track AI coding assistant token usage, model, estimated cost, and rate-limit events per project.

  • TypeScript
  • CLI
  • Telemetry
./GHT4ngo/sigkill

sigkill

WIP

Lightweight utility that monitors system memory and kills low-priority processes to keep a development environment responsive.

  • Utility
  • System monitoring
  • Developer tools