Featured Projects (3)

Open Source Contributions (1)

LightRAG

Implemented pgvector indexing (HNSW/IVFFLAT) and query optimization for large-scale vector retrieval, adopted in ticketing recommendation with 10k+ items.

  • Implemented pgvector indexing (HNSW/IVFFLAT) and auto-indexing on core VDB tables.
  • Rewrote vector-retrieval SQL (EXPLAIN-driven) to ensure index-backed execution plans.
  • Unified query interfaces across backends; improved maintainability on large corpora.
  • Adopted for ticketing recommendation (10k+ items) with pgvector HNSW.

Other Projects (2)

Portfolio Website

Personal portfolio built with Hexo and custom styling, showcasing projects, blogs, and open-source contributions.

Unity 2D Platformer Game

  • Developed and implemented a color-switching mechanic that governs interaction with platforms, enemies, and obstacles to add strategic depth.
  • Designed and optimized multiple levels; introduced a checkpoint system and a color-gun mechanic to enhance user experience.
  • Fixed critical bugs, optimized performance, and iterated level design based on extensive playtesting feedback.

This page showcases my projects and contributions.