Projects

A Log-Structured Merge-Tree storage engine in C++ with a SkipList-based MemTable, CRC32-protected Write-Ahead Log for crash recovery, and size-tiered compaction. Integrates with the Linux perf subsystem to quantify write amplification and hardware-level execution metrics.

Benchmarks SIMD-vectorized operators against scalar tuple-at-a-time processing. Combines AVX-512 16-wide parallelism, Apache Arrow-inspired memory layouts, and dictionary encoding to measure the throughput ceiling of columnar query execution.

A C++ storage manager combining a buffer pool with Clock replacement, a disk-resident B+ Tree index, and a slotted-page heap file for variable-length records. Uses a custom PageGuard RAII wrapper to ensure pin safety across exceptions and automatic dirty-page flushing on eviction.

Rule-based SQL optimizer using sqlglot to parse queries into ASTs and apply composable rewrite passes: predicate pushdown, projection pruning, and constant folding in a fixed-point iteration loop. Paired with a React frontend that renders before/after logical plan trees as annotated node graphs with per-pass telemetry.

A high-performance thread pool library built from scratch in C++ using mutexes and condition variables for thread-safe task queuing. Workers pick up enqueued callables and return std::future handles, making it straightforward to parallelize workloads without managing threads directly. Validated with Google Test.

A Go CLI tool that parses YAML service definitions and drives the Docker Engine API to spin up or tear down local development environments in a single command. Handles image pulls with progress feedback, port and environment variable mapping, and a --force flag to automatically resolve container name conflicts.