PostgreSQL DBA, Full-stack developer, Backend Architect @ Apple, TanTan, Alibaba. PostgreSQL ACE, Translator of two books: Designing Data-Intensive Applications & PostgreSQL Internal.
Dec 2017 - Present, Beijing
Tinder in China. The second largest stranger social platform in China
Nov 2019 - Present
Dec 2017 - Dec 2018
Aple deliver the best phone in the world! And we deliver best factory monitoring & tracing system for Apple!
Aug 2015 - Dec 2017
Jue 2014 - Sep 2014
Chinese translation version of 《Designing Data-Intensive Application》
StarChinese translation version 《PG Internal》. A book about PostgreSQL Kernel
DetailsBest Postgres Montoring System ever. Along with a provisioning solution for HA postgres clusters.
DetailsAho-Corasick Automaton with Double Array Trie. Multi-String substitute simultaneously.
StarPrometheus exporter for PostgreSQL metrics. Completly customizible
StarGolang SDK for alibaba’s datawarehouse MaxCompute (Original name is ODPS)
StarNotes and articles about postgres. (including a minimal sandbox environment)
StarFetch, parse, visualize NOAA ISD Dataset. Sub-hourly observation records of 30000 meteorology station from 1900-2020.
StarGolang wrapper for iTunes Search API. Can be used for crawler. Also Provides a binary tool for quick search.
StarChina Administrative Division Data. 5 level data with geo fences. Join from Stats.gov, Ministry of Civil Affairs and Gaode Map.
StarUpgrade existing 200+ PostgreSQL Instance (1PB data) to Pigsty HA deployment. (CentOS7, PostgreSQL 13)
Build monitoring , logging , alerting system for databases. Including PostgreSQL, Redis and TTDB.
Architecture evolution from 20 database to 200 database. Horizontal split and vertical split. Microservice refactor. Ton’s of database migration
Make exising tracing model works on iPhone factories
Desiging trace data warehouse schema, build ETL & streaming processing pipeline. Rewrite existing logic and makes it 10~100x faster
Setup backup and recovery plan. Solving database failures. Upgrading monitoring system and optimizing slow queries
Designing and managing database system for Umeng. Migrating HBase and MongoDB to Postgres. Build and maintain a knowledge database for DMP.
DetailsArchitect, tech leader,and 1 of 3 co-founders of Project FinPlus, A toB credit score (FICO) service in China. Intrapreneurship project with tens of millions $ income per year
DetailsWi-Fi probe for offline user profile. Plays a versatile role in it: Software, Hardware, Ops, DBA, Data Analyst,BD,etc…
Details