Han Wang
Teaching Assistant at The University of Hong Kong
Hong Kong Island, Hong Kong, China
Summary
👤
Senior🎓
Top SchoolHan Wang is a PhD student and teaching assistant at the University of Hong Kong with eight years of software and database engineering experience, blending academic research with hands-on system development. He has practical expertise in spatial databases, contributing to PostGIS by enhancing GiST index support and optimizing spatial indexing strategies like Hilbert curve ordering. Comfortable at the intersection of research and engineering, he applies rigorous testing and SQL-level improvements to production-grade open-source projects. Based on a solid academic path through Wuhan University and Peking University, he describes himself as an "imagineer" who enjoys exploring novel technical ideas and turning them into tangible improvements.
8 years of coding experience
Bachelor of Engineering - BE, Bachelor of Engineering - BE at Wuhan UniversityMaster of Science - MS, Master of Science - MS at Peking UniversityThe University of Hong Kong (HKU)
Stackoverflow
83reputation
4kreached
1answer
5questions
Github Skills (18)
postgresql10
spatial-index10
geospatial10
postgis10
c119
c179
psql8
pg8
pgsql8
plpgsql8
sumo6
shapefile6
literals6
gis6
vue6
Programming languages (14)
Github contributions (5)
postgis/postgis
Jun 2021 - Aug 2021
PostGIS spatial database extension to PostgreSQL [mirror]
Role in this project:
Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:5 reviews, 10 commits, 1 PR in 2 months
Contributions summary:Han primarily focused on enhancing the GiST (Generalized Search Tree) index support within the PostGIS extension. Their contributions involved modifying test configurations and adding new sort support functions. The code changes suggest involvement in optimizing the GiST index for spatial data types, with specific focus on the Hilbert curve and other spatial indexing strategies. The user also modified SQL scripts related to testing GiST functionality.
geospatialspatialpostgisdatabasepostgres
HanwGeek/RailwayStar
Nov 2018 - Nov 2019
A railway visualization project with Vue.js.
Contributions:4 commits, 1 PR, 3 pushes in 1 year
vuejsrailwayvue-jsvuevisualization
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.