Articles
Notes on Local LLM RAG in Practice
Lessons and optimizations from deploying a local LLM with RAG in a private environment.
Tag
#LLM
All content with this tag
Projects
Local RAG Knowledge Assistant
An intelligent Q&A assistant built on a local qwen3.5-9b model and vector retrieval, delivering accurate answers while preserving data privacy.
Projects
Bilibili Trending Analysis System
A full-stack analytics system covering the entire Bilibili trending pipeline: single/multi-day data scraping, content and metric analysis, visualization reports, and multimodal content understanding — all packaged into reusable Skills.
Projects
YouTube Subtitle Auto-Translation Pipeline
A one-command, fully automated pipeline for 'auto-download → subtitle translation → Chinese hardsub burn-in' of YouTube videos, designed for Chinese-speaking audiences consuming overseas video content.