Hi, I’m Pixelpig.

Footprints

Keep it simple, so as this bio.

  • Revisiting fundamentals while embracing AI. Familiar with mainstream AI coding tools like Kiro, Cursor, and CC. A vibe coding follower. Bypassing all GFW-related restrictions — been on the free internet for 10+ years.
  • Previously worked at Chinese internet and streaming media companies on data processing. ~5 years of backend development, ~2 years of full-stack. Currently freelancing with 100+ client projects completed. Hoping to build something fun in the future.
  • Passionate about sharing and open source. Contributed features and bugfixes to projects like APISIX and Sealos.
  • Interested in interaction design and streaming media processing. Currently exploring ffmpeg and iterating on ffmpig.
  • Not a fan of rigid systems and bureaucracy. Firmly believe that open source and freedom are prerequisites for a win-win in tech. The world is more interesting with creative and individualistic people — writing good code has nothing to do with wearing a suit and tie.

Technical Skills

  • Backend languages: Golang / PHP / Java / TypeScript / JavaScript / Lua
  • Frontend & backend frameworks: Vue / React / Nest.js / Uniapp — capable of independently building and maintaining applications
  • Databases & caching: Redis / MongoDB / MySQL / Kafka
  • Proficient with common microservice frameworks, Linux commands, and Shell scripting

Work Experience

@Pixel Studio

Frontend Visualization Component Development

  • Integrated data visualization components using ECharts.js, D3.js and other frontend frameworks to generate charts, maps, and visual widgets
  • Used Next.js for server-side pre-rendering to accelerate initial page load and improve user interaction responsiveness
  • Developed a quiz mini-program based on Uniapp

@Huya, Guangzhou (2021-2022)

Cloud Production Platform — Backend Common Module Development

Built custom plugins for the go-micro microservice framework, including a custom Circuit Breaker component with real-time API error rate tracking based on read-write locks.

Supporting Internal Service Systems

  • Participated in live streaming business development with 400K DAU. Responsible for the points & gift distribution system, using Redis + MySQL for distributed transactions with async delayed message queues for inventory consistency.
  • Developed the annual event game queuing feature, integrating the internal Tars RPC framework with DCache in-memory queues for user registration data.

@Kingsoft Seasun, Zhuhai (2018-2021)

PVP Arena Data Collection & Backend API Development

JX3 Online

  • Built a real-time game data reporting pipeline: custom Kafka partition strategies, consumer lag/lead monitoring, MongoDB for persistent log storage with shard key and read/write optimization
  • Handled 300K daily arena data ETL in real-time: built Redis in-memory compressed queues (hash + zset), producer-consumer model with Go channel rate limiting, failure retry queues, and sync.Pool for batch processing performance
  • Set up a ClickHouse data warehouse for offline ranking exports using ReplacingMergeTree engine with Crontab scheduled tasks for hourly incremental / daily full imports

Game Community App

  • Worked with common Go microservice frameworks. Contributed to department Gin web framework middleware: struct validation interceptors, latency tracking, Grafana tracing modules
  • Implemented database connection pool wrappers using P/V semaphore communication for connection queue management
  • Familiar with Nginx and Kong gateway frameworks, wrote custom Lua plugins for OpenResty

Community App Homepage Recommendation Feed Development

  • Built a cross-language tokenization service (Java + Go) over gRPC with Protobuf, providing text similarity computation and real-time ElasticSearch custom scoring modules
  • Designed user feed queues: Redis in-memory scoring queues with multi-category distribution, version-based content push

Further Reading

Juejin Column: Let’s Talk About Go