I'm Vonng

Ruohang Feng

Founder / CEO at Pigsty

PostgreSQL Expert, Full-Stack Engineer, Backend Architect @ Apple, TanTan, Alibaba. Individual open source contributor.
Author of Pigsty and Capslock Enhancement. Translator of 《PG Internal》 & 《Designing Data-Intensive Applications》.

Developer
Architect
DBA
SRE
Analyst
Entrepreneur

Skills

PostgreSQL
PostgreSQL

Expertise in PostgreSQL.
Author of Pigsty —— A battery included open source PostgreSQL Distribtion
Go
Go

Write robust, maintainable programs: web servers, crawlers, exporters, cli tools, etl pipeline, etc… with Go.
Database
Database

Rich experience on various data systems: Redis, HBase, MongoDB, Cassandra, MySQL, ODPS, Consul, Etcd, …
Domains
Domains

Domain knowledge about: Web FE/BE, Networking, Hardwares, Manufacturing Operation, GIS, Meteorology, Info Sec…
Data Analysis
Data Analysis

Write advanced SQL queries. Data analysis with statistic tools: SQL, Python, R, Matlab, Excel etc…
Visualization
Visualization

Rich experience on making interactive visualization products with D3.js, echarts.js, grafana panels, etc…
Ansible
Ansible

Write resuable, sophisticated playbooks & roles. Designing large scale provisioning solution based on it.
Linux
Linux

Using as the main operating system. familiar with *nix tools such as bash vim git awk sed grep systemd ntp ssh dns etc…
Cloud Service
Cloud Service

Familiar with most of the cloud service, such as S3, RDS, ECS, CDN, etc…
Grafana
Grafana

Designing sophisticated application with Grafana. Deeply customize, write plugins, advanced visualization.
Prometheus
Prometheus

Setup & configure Prometheus. Desinging record & alert rules. Writing PromQL Queries. Writing metric exporters.
Kubernetes
Kubernetes

Deploying and managing application on kubernetes, including kubernetes itself.
Nginx
Nginx

Configuring nginx, writing lua scripts for OpenResty. Customize API gateway such as Kong. And other LB such as haproxy
Python
Python

Handy tools for daily usage: solving trivial tasks. automation, crawlers. data process & analysis, web servers, AI models, etc…
Javascript
Javascript

Write FE & BE applications. Experience with common js libs: Jquery, Bootstrap, EazyUI and HTML, CSS, GraphQL, etc…
C# & Java
C# & Java

Writing entriprise applications with Java. Forge Windows UI programs with C#
C/C++
C/C++

C/C++ programming skills. For source code reading purpose.
Matlab
Matlab

Scientific modeling, neural network modeling, celluar automation simulation with Matlab

Experiences

1
Founder / CEO
PanJiYunShu / Pigsty

Nov 2020 - Present, Beijing

HashiCorp for Database, Redhat for PostgreSQL

Responsibilities:
  • Captain of the ship!
TanTan Co. Ltd

Dec 2017 - Present, Beijing

Tinder in China. The second largest stranger social platform in China

PostgreSQL Expert

Nov 2019 - Present

  • PostgreSQL Distribution/Solution Development
  • Building Infrastructure for DBA and Developers
PostgreSQL DBA

Dec 2017 - Dec 2018

  • Database Administration
2
3
Software Developer ICT4
Apple, APO (ShangHai) Co. Ltd

Dec 2018 - Jun 2019, ShangHai

Apple (AAPL) deliver the best eletronic devices in the world! And we deliver best factory monitoring & tracing system for Apple!

Responsibilities:
  • Trace for iPhone
  • Trace datawarehouse
  • Trace database administration
Alibaba (Beijing) Co. Ltd

Jue 2014 - Dec 2017, Beijing

Data intelligence department of the largetest e-commerace company – Alibaba (BABA)

Full-Stack Developer

Aug 2015 - Dec 2017

  • Project Finplus
  • Project Oplus
  • Umeng Data Platform
  • Knowledge Database
Algorithm Engineer (Intern)

Jue 2014 - Sep 2014

  • Designing and maintain Index for Cloud Recommendation System
4

Projects

DDIA
DDIA
Owner 2018

Chinese translation of 《Designing Data-Intensive Applications》

Star
PG Internal
PG Internal
Owner 2018

Chinese translation of 《PG Internal》. A book about PostgreSQL Kernel

Details
Pigsty
Pigsty
Owner March 2019 - Present

Pigsty —— the Battery-Included Open Source PostgreSQL Distribution.

Star
Capslock
Capslock
Owner 2016

Transform Capslock into a versatile modifier key, improve your productivity tremendously!

Star
PG Exporter
PG Exporter
Owner March 2019 - Present

Prometheus exporter for PostgreSQL & Pgbouncer metrics. With latest PG14 support

Star
ACDAT in Go
ACDAT in Go
Owner 2018

Aho-Corasick Automaton with Double Array Trie. Multi-String substitute simultaneously.

Star
MaxCompute Go SDK
MaxCompute Go SDK
Original Owner 2017

Golang SDK for alibaba’s datawarehouse ODPS (now known as MaxCompute)

Star
FDW Paper
FDW Paper
Co-Author June 2017

Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases, NPC2017

Star
Postgres Notes
Postgres Notes
Owner Dec 2017 - Now

Notes, articles, gist, scripts,… . Everything about PostgreSQL.

Star
ISD - Historic Meteorogly Visualization
ISD - Historic Meteorogly Visualization
Owner Sep 2020

Analyze & Visualize NOAA ISD Datasets. Sub-hourly observation records of 30000 meteorology station from 1900-2020.

Star
iTunes Search API for Golang
iTunes Search API for Golang
Owner Sep 2017

Golang wrapper for iTunes Search API. Can be used for crawler. Also Provides a binary tool for quick search.

Star
Adcode
Adcode
Owner Sep 2017

China Administrative Division Data. 5 level data with geo fences. Join from Stats.gov, Ministry of Civil Affairs and Gaode Map.

Star
DB New Order
DB New Order
TL 2021

Upgrade 200+ existing PostgreSQL Instance (1PB) to Pigsty deployment. (CentOS7, PostgreSQL 13)

Database Monitoring
Database Monitoring
TL 2020

Build monitoring , logging , alerting system for databases. Including PostgreSQL, Redis and TTDB.

Architecture Evolution
Architecture Evolution
DBA 2018

Architecture evolution from 20 database to 200 database. Horizontal split and vertical split. Microservice refactor. Ton’s of database migration

Trace for iPhone
Trace for iPhone
Software Developer 2019

Make exising tracing model works on iPhone factories

Trace Data Warehouse
Trace Data Warehouse
Software Developer 2019

Desiging trace data warehouse schema, build ETL & streaming processing pipeline. Rewrite existing logic and makes it 10~100x faster

Trace Database Admin
Trace Database Admin
DBA 2018

Build monitoring infrastructures and backup infrastructure. Handling & analyze database failures. Optimizing slow queries.

Umeng DMP
Umeng DMP
Full-Stack Developer 2017

Designing and managing database system for Umeng. Migrating HBase and MongoDB to Postgres. Build and maintain a knowledge database for DMP.

Details
Oplus
Oplus
Soft-Hardware Developer 2015

Wi-Fi probe for offline user profile. Plays a versatile role in it: Software, Hardware, Ops, DBA, Data Analyst,BD,etc…

Details
Finplus
Finplus
Co-Founder 2016

Architect, 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

Details

Achievements

2020 Database Carnival Guest

First TanTan Coding Champoin

PostgreSQL ACE

2019 PGConf China Guest

2021 GOTC Guest

Lecture in Dalian University of Technology

2020 PGConf China Host

Tantan 2021 Carnival Host

Trek on Wusu, Xinjiang

California State Route 1

Mt.Everest East Face Base Trek

Grand Tour

Solo Trek on Rock Shangri-La

Trek on Kanas

Trek on Meili, Mt. Kawagarbo , 2021

Ice Climbing

Manchuria

South Taihong