Projects.

A C++ retrieval engine with a streaming BSBI indexer, a sharded inverted index, mmap document access, and OpenCilk query execution. Optional BERT reranking through LibTorch.

SQL parser, binder, planner, and volcano executors over a buffer pool. Row storage, one file per table and index, snapshot isolation with per-tuple XMIN/XMAX.

Breakpoints, register and memory inspection, and single-step for Linux processes, written in C against ptrace directly.

Datapath and control logic for the SimpleRISC instruction set, paired with an assembler for writing test programs.

Hand-written lexer and parser, semantic checks, and LLVM IR generation for a toy language.

Rooms, message history, and presence. Built to learn how much state a live chat client actually has to manage.

Next.js front end over a MySQL schema for applications, vehicles, and policies. A course project.